Re: SEQ#, DUAL and Oracle literacy

LOL! I had to ponder this for a few seconds.

Good one Steve.

Jared

On Tuesday 18 June 2002 14:23, Orr, Steve wrote:
> Here's a performance tuning query to help identify the problem:
>
>
> SELECT column_name "The problem is the..."
> FROM dba_tab_columns
> WHERE owner='SYS'
> AND table_name = 'DUAL'
> /
>
> :-)
>
> -----Original Message-----
> Sent: Tuesday, June 18, 2002 2:13 PM
> To: Multiple recipients of list ORACLE-L
>
>
> So did you fix it?
>
> -----Original Message-----
> Sent: Tuesday, June 18, 2002 3:07 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Want to have a good laugh?... read on... I don't think its OT :)
>
> A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle
> Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the
> application will get a *specific* Sequence Number for something.
>
> DBA: Why do you think DUAL is the problem?
> Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'.
>
> Boy! Are we in trouble or what?? ;)
>
> - Kirti

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).