Toad World

Blogs

Iggy Fernandez
Follow /31 Aug 2016 at 2:00pm / Oracle Blog

A very gentle introduction to Oracle PL/SQL programming for beginners

In response to Tim Ford’s #EntryLevel Challenge . Oracle Database gives you the ability to store programs in the database using a language called Procedural Language/SQL ( PL/SQL ). As the name indicates—and just like database programs...
1453 0 /
Iggy Fernandez
Follow /31 Aug 2016 at 2:00pm / Oracle Blog

A day in the life of a problem solver

P.O.I.S.E.D. is the acronym I invented for the performance tuning method described by Chris Lawson in The Art and Science of Oracle Performance Tuning; it stands for Problem, Observation, Interpretation, Solution, Execution, and Documentation. P...
833 0 /
Iggy Fernandez
Follow /31 Aug 2016 at 2:00pm / Oracle Blog

An excellent review of where we are, where it all came from, and where we are going‏

For twelve years, Brian Hitchcock has been reading books on Oracle Database. And taking extensive notes. And publishing them in the NoCOUG Journal. About the book he reviewed for the August 2016 issue of the NoCOUG Journal, Brian had this to say: “You...
480 0 /
Iggy Fernandez
Follow /31 Aug 2016 at 2:00pm / Oracle Blog

Conference Report: NoCOUG 2016 summer conference at Chevron

The Northern California Oracle Users Group (NoCOUG) is a volunteer-run 501(c)(3) organization and the longest-running—“oldest” is such a negative word—Oracle users group in the world. It organizes a full-day conference every quarter...
703 0 /
Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part V

A series of posts in response to Tim Ford’s #EntryLevel Challenge . “If we shadows have offended, Think but this, and all is mended, That you have but slumber’d here While these visions did appear. And this weak and idle theme, No...
1400 0 /
Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part IV

A series of posts in response to Tim Ford’s #EntryLevel Challenge . Part I: Getting started with Oracle Database Part II: What is a Database? Part III: What is a Relational Database? Part IV: What is a Database Management System? ...
1162 0 /
Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part III

A series of posts in response to Tim Ford’s #EntryLevel Challenge . Part I: Getting started with Oracle Database Part II: What is a Database? Part III: What is a Relational Database? Part IV: What is a Database Management System? ...
889 0 /
Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part II

A series of posts in response to Tim Ford’s #EntryLevel Challenge . Part I: Getting started with Oracle Database Part II: What is a Database? Part III: What is a Relational Database? Part IV: What is a Database Management System?...
1274 0 /
Iggy Fernandez
Follow /1 Aug 2016 at 2:00am / Oracle Blog

An introduction to Oracle Database for beginners: What is a relational database management system?—Part I

A series of posts in response to Tim Ford’s #EntryLevel Challenge . “If we offend, it is with our good will. That you should think, we come not to offend, But with good will. To show our simple skill, That is the true beginning of our end...
1938 0 /
Iggy Fernandez
Follow /1 Jul 2016 at 3:30am / Oracle Blog

Believe it or Not: Converting an Inner Join to an Outer Join to improve performance

The cost-based optimizer tries to merge views whenever possible but sometimes we ma y want to override this behavior; that is, we may want the optimizer to push predicates into the view instead of merging the view into the main query. For example, consider...
1782 0 /