OraFAQ Forum: Community Hangout » The quick brown fox

Home » Other » Community Hangout » The quick brown fox

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

The quick brown fox [message #187835]

Tue, 15 August 2006 22:40

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.

Report message to a moderator

Re: The quick brown fox [message #187853 is a reply to message #187835]

Wed, 16 August 2006 00:42

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

Littlefoot
Messages: 21823
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

Report message to a moderator

Re: The quick brown fox [message #187855 is a reply to message #187854]

Wed, 16 August 2006 00:47

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?

Report message to a moderator

Re: The quick brown fox [message #187856 is a reply to message #187855]

Wed, 16 August 2006 00:51

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

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

Report message to a moderator

Re: The quick brown fox [message #188084 is a reply to message #188069]

Thu, 17 August 2006 01:03

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

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!

Report message to a moderator

Re: The quick brown fox [message #188162 is a reply to message #188149]

Thu, 17 August 2006 05:57

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

Report message to a moderator

Re: The quick brown fox [message #188295 is a reply to message #187835]

Thu, 17 August 2006 18:29

Barbara Boehmer
Messages: 9102
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

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!

Report message to a moderator

Previous Topic:	site
Next Topic:	Suckerrrrrrrrrrrrssssssss !!!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 22:50:33 CST 2025