Home » Other » Community Hangout » The quick brown fox
The quick brown fox [message #187835] Tue, 15 August 2006 22:40 Go to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
What's a minimal SQL statement (least number of characters) that works on any post-8.0 database that contains
- all letters of the alphabet
- no quote marks
- no aliases

I wrote a quick one with 98 chars. Hover here to see it in your browser bar, or try your own without looking first.
Re: The quick brown fox [message #187853 is a reply to message #187835] Wed, 16 August 2006 00:42 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
solution


[Edit: BLAST!!
Any post 8.0 db....
Knew it could not be that simple...]

[Updated on: Wed, 16 August 2006 00:54]

Report message to a moderator

Re: The quick brown fox [message #187854 is a reply to message #187835] Wed, 16 August 2006 00:43 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Was the weather THAT bad in Melbourne last weekend? Or is your wife in maternity hospital and you were too nervous to sleep? Very Happy
Re: The quick brown fox [message #187855 is a reply to message #187854] Wed, 16 August 2006 00:47 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Littlefoot wrote on Wed, 16 August 2006 07:43

... Or is your wife in maternity hospital and you were too nervous to sleep? Very Happy

How about the name of the little one? Is it gonna be Larry after all?
Re: The quick brown fox [message #187856 is a reply to message #187855] Wed, 16 August 2006 00:51 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
I think it would be safe to assume any post 8.0 database has more than 26 rows in a certain view.
55 positions:
solution

[Updated on: Wed, 16 August 2006 00:53]

Report message to a moderator

Re: The quick brown fox [message #188069 is a reply to message #187856] Wed, 16 August 2006 22:10 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
I phrased the question badly; I was after all of the letters of the alphabet IN THE STATEMENT, not in the OUTPUT.

And damn!, my solution doesn't work pre-9.0, because I used the keyword JOIN to include the letter 'J'. Back to the drawing board.

You could always do
CREATE TABLE DFHIJKMPQSUVWXYZ(B LONG)
but that's not in the spirit of the challenge.

For those interested, the baby comes out next Thursday (24th). Still no name, although the list is getting shorter and Larry is not on it. Wink

Second last day at work today, then 6 weeks leave. Thumbs Up

Ross Leishman
Re: The quick brown fox [message #188084 is a reply to message #188069] Thu, 17 August 2006 01:03 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
rleishman wrote on Thu, 17 August 2006 05:10

For those interested, the baby comes out next Thursday (24th). Still no name, although the list is getting shorter and Larry is not on it. Wink
The tension rises...

How about Maaher? It appears to mean 'expert" in Indian (or one of its dialects). Very Happy

(Please don't. It is a joke. Don't go there, Ross. Really.)

MHE

[Updated on: Thu, 17 August 2006 01:03]

Report message to a moderator

Re: The quick brown fox [message #188149 is a reply to message #188084] Thu, 17 August 2006 05:30 Go to previous messageGo to next message
hobbes
Messages: 173
Registered: January 2006
Senior Member
Quote:

How about Maaher? It appears to mean 'expert" in Indian (or one of its dialects)


I have been curious about this for a long time Maarten: Is that why you chose that login name Maaher, or is the special meaning of your name a happy coincidence you discovered later?

Just FYI: Maaher means 'expert' in Urdu (the national language of Pakistan), which is similar to Hindi (the official language of India). There is no language called 'Indian' Smile

The word 'Maaher' in itself is archaic, and even in countries that speak the language, 'Maaher' would be an unusual name for a person!
Re: The quick brown fox [message #188162 is a reply to message #188149] Thu, 17 August 2006 05:57 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
hobbes wrote on Thu, 17 August 2006 12:30

I have been curious about this for a long time Maarten: Is that why you chose that login name Maaher, or is the special meaning of your name a happy coincidence you discovered later?
I have discovered it by accident. Some users pointed me to the meaning of this nick. I have just taken the three first characters of my first name and the three first of my last name.

Quote:

Just FYI: Maaher means 'expert' in Urdu (the national language of Pakistan), which is similar to Hindi (the official language of India). There is no language called 'Indian' Smile
Thanks for pointing that out. I knew it wasn't 'Indian' but I couldn't remember the language name (and ok, I was too lazy to look it up Very Happy). This would explain why I get mails in Urdu or related languages...

MHE
Re: The quick brown fox [message #188295 is a reply to message #187835] Thu, 17 August 2006 18:29 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
SELECT JAVA_EXEC_TIME,TYPE_CHK_HEAP,DIRECT_WRITES,BUFFER_GETS,OPTIMIZER_ENV FROM V$SQL;

[Updated on: Thu, 17 August 2006 18:33]

Report message to a moderator

Re: The quick brown fox [message #188311 is a reply to message #187835] Thu, 17 August 2006 21:29 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
rleishman wrote on Wed, 16 August 2006 13:40

...that works on any post-8.0 database


SQL> SELECT JAVA_EXEC_TIME,TYPE_CHK_HEAP,DIRECT_WRITES,BUFFER_GETS,OPTIMIZER_ENV FROM V$SQL
  2  /
SELECT JAVA_EXEC_TIME,TYPE_CHK_HEAP,DIRECT_WRITES,BUFFER_GETS,OPTIMIZER_ENV FROM V$SQL
                                                              *
ERROR at line 1:
ORA-00904: "OPTIMIZER_ENV": invalid identifier

Nice solution for 10g though!
Previous Topic: site
Next Topic: Suckerrrrrrrrrrrrssssssss !!!!!
Goto Forum:
  


Current Time: Thu Mar 28 05:06:47 CDT 2024