"Anyone without a sense of humor is at the mercy of the rest of us!"
Funny SQL statements
Some funny SQL Statements we've encountered:
SELECT standard_disclaimer, witty_remark FROM company_requirements;
SELECT standard_disclaimer FROM company_stuff WHERE meaningful_content = 'NONE';
SELECT * FROM management WHERE clue > 0;
SELECT * FROM clients WHERE clue > 0;
SELECT * FROM users WHERE clue > 0;
SELECT * FROM genepool WHERE clue > 0;
SELECT * FROM politicians WHERE clue > 0;
Funny error messages
SQL> select intelligence_level from developer; select intelligence_level from developer * ERROR at line 1: ORA-00904: "INTELLIGENCE_LEVEL": invalid identifier
SQL> select count(*) from developer_brain; select count(*) from developer_brain * ERROR at line 1: ORA-00942: table or view does not exist
Yesterday: A DBA's backup song
YESTERDAY (to be sung to the tune of the Beatles' song - Yesterday):
Yesterday, All those backups seemed a waste of pay Now my database has gone away Oh I believe in yesterday Suddenly, There's not half the files there used to be And there's a deadline hanging over me The system crashed so suddenly. I pushed something wrong What it was I could not say Now my data's gone and I long for yesterday-ay-ay-ay. Yesterday, The need for back-ups seemed so far away. Thought all my data was here to stay, Now I believe in yesterday.
Here is a Youtube video of the song.
Genesis of a DBA Universe
- In the beginning was the disk array, and all was empty
- and raw, and Unix moved over the face of the platters.
- And the DBA said: Let there be Oracle. And there was
- Oracle. And the environmental variables were set and
- the disks were striped and mirrored and the OFA was
- established, and behold spindle was rent asunder from
- spindle. And the DBA saw that all was in spec.
- And it was day and it was evening of the first day.
- And the DBA said: Let there be scripts. And sql.bsq
- brought forth myriad crawling things upon the face of
- the array. And catalog.sql brought forth all manner of
- tables and views that swim unseen beneath the waters.
- And catproc.sql brought forth all the built-in
- programs and all the hosts of the air, that the users
- might be given wings and take fight over the data.
- And it was day and it was evening of the second day.
- And the DBA said: Let there be tablespaces. And there
- were tablespaces. And the network administrator looked
- upon the disk array and did see what the tablespaces
- had wrought upon the disk arrays, and he did gnash his
- teeth and seek a new work upon the Internet with an
- engine of search.
- And it was day and it was evening of the third day.
- And the DBA created users. Male and female he created
- them. And he said unto the users: Thou mayest create
- tables and views as thou wilt. Yea, though mayest
- create even indexes upon the data. Only meddle not
- with the system tablespace, for it is a holy place,
- and on the day wherein thou treadest upon it, on that
- day thy create session shall surely be revoked. And
- the serpent crept among the users and whispered to
- them, saying: Thine roles shall not be revoked. Taste
- ye all of the system tablespace, for ye shall know of
- b-trees and hints and ye shall be as DBAs. And the
- users heeded the serpent and filled the system
- tablespace with crap. And the instance did crash and
- the client did wax wroth at the DBA. And the DBA did
- gnash his teeth and partake of the fruit of the vine,
- for behold the users were permanent employees and the
- DBA was but a contractor and could not revoke their
- create session.
- And it was day and it was evening of the fourth day.
- And the DBA did set default tablespaces and temporary
- tablespaces and did lock down all that was upon the
- face of the array with roles and profiles and all
- manner of quotas, yea even from the rollback segments
- even unto the archived redo logs.
- And it was day and it was evening of the fifth day.
- And the DBA created synonyms and links and did tune
- the server and apply patches upon the face of the
- And it was day and it was evening of the sixth day.
- And on the seventh day the DBA did rest from all the
- labors of the creation. And his pager did ring and he
- ceased from resting and did spend his sabbath on the
- telephone with Oracle support. And by the time the DBA
- got through to someone who knew whereof they spake
- behold it was day and it was evening of the eighth
- And the DBA waxed wroth.
Some of Oracle's real life messages
- Q. What if your Dad loses his car keys?
- A. 'Parent keys not found!'
- Q. What if your old girl friend spots you with your new one?
- A. 'Duplicate value on index!'
- Q. What if the golf ball doesn't get into the hole at all?
- A. 'Value larger than specified precision!'
- Q. What if you try to freak out with somebody else's girlfriend and being kicked out?
- A. 'Insufficient privileges on the specified object!'
- Q. What if you don't get any response from the girl next door?
- A. 'No data found!' or ' Query caused no rows retrieved!'
- Q. What if you get response from the girl next door and her Mom too?
- A. 'SELECT INTO returns too many rows!'
- Q. What if you dial a wrong number?
- A. 'Invalid number' or ' Object doesn't exist!'
- Q. What if you try to beat your own trumpet?
- A. 'Object is found mutating!'
- Q. What if you are too late to office and the boss catches you?
- A. 'Discrete transaction failed!'
- Q. What if you see 'theatre full' when you go to a movie?
- A. 'Maximum number of users exceeded!'
- Q. What if you don't get table in the lunch room?
- A. 'System out of tablespace!'
- Q. What if you need to go on a diet?
- A. Invalid Body Size
- Q. What if you are tall and try to crawl into a mini?
- A. 'Inserted value too large for column'
12 days of denormalization
On the first day of denormalization, my design gave to me
- a really fast-running query.
On the second day of denormalization, my design gave to me
- 2 less tables.
On the third day of denormalization, my design gave to me
- 3 more indexes.
On the fourth day of denormalization, my design gave to me
- 4 larger disks.
On the fifth day of denormalization, my design gave to me
- 5 brand new reqs.
On the sixth day of denormalization, my design gave to me
- 6 times the locking.
On the seventh day of denormalization, my design gave to me
- 7 longer updates.
On the eighth day of denormalization, my design gave to me
- 8 more requirements.
On the ninth day of denormalization, my design gave to me
- 9 invalid rows.
On the tenth day of denormalization, my design gave to me
- 10 delays deleting.
On the eleventh day of denormalization, my design gave to me
- 11 questionable queries.
On the twelfth day of denormalization, my design gave to me
- 12 lessons learned.
All about toasters
If IBM made toasters...
- They would want one big toaster where people bring bread to be submitted for overnight toasting. IBM would claim a worldwide market for five, maybe six toasters.
If Oracle made toasters...
- They'd claim their toaster was compatible with all brands and styles of bread, but when you got it home you'd discover the Bagel Engine was still in development, the Croissant Extension was three years away, and that indeed the whole appliance was just blowing smoke.
If Sun made toasters...
- The toast would burn often, but you could get a really good cuppa Java.
Does DEC still make toasters?...
- They made good toasters in the '80s, didn't they?
And, of course: If Microsoft made toasters ...
- Every time you bought a loaf of bread, you would have to buy a toaster. You wouldn't have to take the toaster, but you'd still have to pay for it anyway. Toaster'98 would weigh 15000 pounds (hence requiring a reinforced steel countertop), draw enough electricity to power a small city, take up 95% of the space in your kitchen, would claim to be the first toaster that lets you control how light or dark you want your toast to be, and would secretly interrogate your other appliances to find out who made them. Everyone would hate Microsoft toasters, but nonetheless would buy them since most of the good bread only works with their toasters.
If Apple made toasters...
- It would be cute, inoffensive, and idiot proof. It would work as soon as you plugged it in. It would work with anyone's bread. It would take a long time to warm up. It would only have one slot - but you could upgrade. It would be expensive but never require servicing or opening the box. Other companies would say that it was too simple to make real toast but secretly fire their design teams and headhunt the ex-Apple employees. Religious wars would (re)start.
Popular IT quotes
Some popular IT related quotes you can learn to impress your fellow office workers:
- ORACLE = One Real A$#h%le Called Larry Ellison (Only joking, obviously!!!)
- "The degree of normality in a database is inversely proportional to that of its DBA".
- Unix is a very user-friendly system. It's just picky about who it's friendly with.
- "I'm too sexy for my code" - Awk Sed Fred.
- Program complexity grows until it exceeds the capability of the programmer who must maintain it.
- "Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
- "Technology is dominated by two types of people: those who understand what they do not manage, and those who manage what they do not understand."
- Users don't know what they really want, but they will know when they see it...
- Good, fast, cheap: pick two (you cannot have it all!)
- Proper Preparation Prevents Piss Poor Performance
- Keep It Simple Stupid (KISS)
- "Too many fingers on the keyboard" error....
- The problem is caused by UBF (User Brain Failure)
- PEBKAC: Problem Exists Between Keyboard And Chair
- CALM DOWN! It's Only 1's and 0's
- If you work on a program long enough, it will eventually send E-mail (a derivative of Zawinski's Law)
Super DBA Rap Video
Check out how Super DBA uses SQL powers to save the day!
Super DBA by William Avery CHORUS 1 Cooler than ice chillin' in refrigerators I'm Super Database Administrator Cooler than ice chillin' in refrigerators I'm Sup... Super DBA I was walking in the park. Saw a cat up a tree "Please, Super DBA. You got to help me" I looked up. The cat started falling down. I had to think quick before it hit the ground. UPDATE park SET ground='cotton candy'; COMMIT; The cat landed and everything was dandy. The lady said, "Thanks" and the kids had fun. Free cotton candy for everyone CHORUS 2 I'm Super Super DBA Using SQL powers to save the day RMAN's got my back night and day I fast commit transactions with no delay Hackers get back. No getting in my system Got powerful password packet encryption I roll like a stone. Walk like an Egyptian Anything WACK - not in my description I can undo the past. Flash you back to the present You got to give me space. Time is of the essence Forever growing. Knowledge flowing If I select one record, you can't handle what I'm showing. (CHORUS 1) My DBA phone was ringing early in the morning It was an ORA- critical. I had to get going To the DBA Mobile. Riding really fast. Putt, putt... Running out of gas. INSERT INTO car (tank) VALUES ('fuel'); COMMIT; Vroom. Cruising down the avenue. UPDATE traffic_light SET color='green'; COMMIT; Like that, I was there on the scene. I came in the door. I saw this before. It was a party but nobody was dancing on the floor. To make the people move. Get into the groove I grabbed the microphone went Check 1, 2 SELECT hip FROM hop; SELECT dont FROM stop; SELECT a_little_funk FROM the_planet_rock; SELECT cool FROM jazz WHERE the_beat='pizzazz'; SELECT the_best FROM anything_you_ever_had; All is good and the case is closed. Up to the cloud away I go... I got RACs on RACs to data guard your back Scaling through the grid stopping any attack (CHORUS 2) (CHORUS 1)
Here is a Youtube video of the song Super DBA.
Other fun pages on the Net
Links To Some non-Oracle Laughs on the Internet:
- Dilbert Comics - http://www.unitedmedia.com/comics/dilbert/
- Omri's Computer Humor Page - http://www.cs.bgu.ac.il/~omri/humor/
- User Friendly: The Comic Strip - http://www.userfriendly.org/
- Do you have a difficult problem that nobody can answer? Ask the Oracle at http://www.cs.indiana.edu/~oracle/