Toad World

Blogs

Iggy Fernandez
Follow /1 Nov 2016 at 1:00am / Oracle Blog

What keeps database administrators awake at night and the search for the promised land

What keeps you and me awake at night? When I was a consultant for a Fortune 500 company in Southern California, we were getting beaten up to prove that databases were being backed up correctly and that disaster recovery would work. The truth of the matter...
837 0 /
Iggy Fernandez
Follow /31 Oct 2016 at 1:00pm / Oracle Blog

What Dr. Edgar Codd said about the relational model in 1981

Dr. Edgar Codd introduced the relational model in his 1970 paper “A Relational Model of Data for Large Shared Data Banks”—there was an earlier 1969 version but let’s not digress. The 1970 paper was reprinted in the 25 th anniversary...
600 0 /
Iggy Fernandez
Follow /31 Oct 2016 at 3:02am / Oracle Blog

NoCOUG 30th anniversary conference sponsored by Google Cloud Platform

NoCOUG is “the little user group that could!” As you might imagine, it requires a vast amount of work to organize a full-day users group conference and publish a printed journal every quarter. No sooner has a conference ended and a journal...
404 0 /
Iggy Fernandez
Follow /31 Oct 2016 at 1:00am / Oracle Blog

The most inventive thing I’ve done

The most inventive thing I’ve done is a software program that I wrote for my first employer almost 30 years ago. I was a fresh-faced COBOL programmer for a software company in Bombay (now Mumbai) which had won a turnkey contract to write hundreds...
626 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

SQL pretzels created while experimenting with hallucinogens?

In an interview for the NoCOUG Journal , Steven Feuerstein was asked: “SQL is a set-oriented non-procedural language; i.e., it works on sets and does not specify access paths. PL/SQL on the other hand is a record-oriented procedural language, as...
670 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

How to rebuild a 12 TB index that you accidentally dropped from a 55 TB table

Once upon a time there was a very experienced database administrator who accidentally dropped a 12 TB index from a 55 TB table (you can read the sob story here ). The question I had was “How did he fix it?” but I did not have the details...
3255 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

NoCOUG Journal: A Few of My Favorite Things

As the editor of the NoCOUG Journal for ten years and counting, I’ve had the interview to interview some of the best minds in the Oracle world. These are a few of my favorite things they said: [Tim Gorman] You are old, father Gorman (as the young...
1280 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

The Little Oracle Users Group That Could

The story of the Little Engine That Could is very old. The oldest version that I could find is from The Expositor and Current Anecdotes , Volume XIII, Number 1 (1911). Once upon a time a little freight car loaded with coal stood on the track in a coal...
642 0 /
Iggy Fernandez
Follow /30 Sep 2016 at 2:00pm / Oracle Blog

Digital archive of the NoCOUG Journal—The best little Oracle users group magazine in the world

All issues since May 2001 (Vol. 15 No. 2)
1340 0 /
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...
1868 0 /