RE: Sr. Oracle DBA Needed in Ft. Lauderdale, FL..

'dual' reminds me of a tuning suggestion that was made when Oracle 6 was introduced, which said - one must select from system.dual and not from dual itself.

• Deepak
  • Brian_McQuillan_at_gelco.com wrote:
    > Diana
    > Are you sure ?
    > I'm the kind of sad puppy that still has all my
    > sql*plus documentation for v6
    > (and forms3 and reportwriter etc etc )
    > and I cannot recall dual ever coming back with two
    > rows
    >
    > Brian.
    >
    >
    >
    >
    >
    > Diana Duncan <Diana_at_fileFRENZY.com> on 08/17/2000
    > 05:49:19 PM
    >
    > Please respond to ORACLE-L_at_fatcity.com
    >
    > To: Multiple recipients of list ORACLE-L
    > <ORACLE-L_at_fatcity.com>
    > cc: (bcc: Brian McQuillan/GELCO)
    >
    >
    >
    >
    > I do remember DUAL at one point (in version 6?)
    > actually returned two rows.
    >
    > -----Original Message-----
    > Sent: Thursday, August 17, 2000 5:10 PM
    > To: Multiple recipients of list ORACLE-L
    >
    >
    > Well, I think most people know Tiger was Scott's
    > cat...
    >
    > Jim
    >
    > >>> richard_at_letsplay.com 08/17/00 03:39PM >>>
    > Thanks for the little history. I often wonders why
    > that name whenever I
    > sees it. Got any others? :)
    >
    > Richard
    >
    > -----Original Message-----
    > Sent: Thursday, August 17, 2000 12:04 PM
    > To: Multiple recipients of list ORACLE-L
    >
    >
    > Then, IF statements and looping capabilities were
    > added to UFI (User
    > Friendly Interface), and the name was changed to AFI
    > (Advanced Friendly
    > Interface). But alas, the AFI functionality was
    > released as PL/SQL.
    > However, the AFI name lives on -- where? ... The
    > temp file created when
    > using SQL*Plus edit command. This file also
    > reflects Oracle's early VMS
    > ties. AFIEDT.BUF. (EDT is the default editor in
    > VAX/VMS).
    >
    > history lesson for the day.
    >
    > -----Original Message-----
    > Yosi_at_comhill.com
    > Sent: Thursday, August 17, 2000 8:16 AM
    > To: Multiple recipients of list ORACLE-L
    >
    >
    > Hey Michael,
    >
    > Remember when SQL*Plus was called UFI... :-)
    > Ahh.... the good old days!
    >
    > Yosi Greenfield (1986 - Oracle 4.?)
    > Comhill Systems, Inc.
    > yosi_at_comhill.com
    >
    >
    > -----Original Message-----
    > Sent: Wednesday, August 16, 2000 4:36 PM
    > To: Multiple recipients of list ORACLE-L
    >
    >
    >
    > I started with 4.1.0 in 1983.... Been working with
    > Oracle in the last 4-5
    > jobs. Still like it.
    >
    > My largest area is keeping it running smooth and
    > fast and database trending,
    > but I've pretty much done it all.
    >
    > Started IT, then EDP... in 1971... :-P
    >
    >
    >
    >
    > Michael Kline
    > ThinkSpark
    > Richmond, VA
    > 804-744-1545
    >
    >
    > -----Original Message-----
    > Sent: Wednesday, August 16, 2000 3:58 PM
    > To: Multiple recipients of list ORACLE-L
    >
    >
    >
    > 8 years of experience... and I'd like a new Mercedes
    > on a silver platter
    > too, please...
    >
    > Seems to me after 8 years Oracle may become boring
    > and something else may be
    > more interesting. Anyone been there/done that?
    >
    >
    >
    >
    >
    > --
    > Author: Jim Conboy
    > INET: Jim.Conboy_at_trw.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).
    > --
    > Author: Diana Duncan
    > INET: Diana_at_fileFRENZY.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).
    >
    >
    >
    >
    >
    >
    > --
    > Author:
    > INET: Brian_McQuillan_at_gelco.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).