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

From: <Chaim.Katz_at_Completions.Bombardier.com>
Date: Fri, 18 Aug 2000 16:28:22 -0400
Message-Id: <10593.115012@fatcity.com>

I didn't know that in Oracle8i you can't insert more than one row into dual. How does that work - it still appears as a table in dba objects. (Do you remember when they moved dual from system to sys).

"Steve Orr" <sorr_at_arzoo.com> on 08/18/2000 01:43:43 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Chaim Katz/Completions/Bombardier)

Subject: RE: Sr. Oracle DBA Needed in Ft. Lauderdale, FL... The DUAL table

I don't think it was a "bug" really. It wasn't a pseudo table back then; it was the realy thing and you could actually insert rows with any char value you wanted. Dual had no primary key constraint. If you did an import you would actually insert a second row into the table. If dual had more than one row it was really a "user error."

IMHO,
Steve Orr

-----Original Message-----

Duncan
Sent: Friday, August 18, 2000 7:58 AM
To: Multiple recipients of list ORACLE-L

Yeah, I think it was actually a bug! But I do remember getting two rows back at some version of 6. Since I was just starting out in Oracle, I figured at the time that was why the pseudo-table was called dual, and I was mighty surprised when the second row went away!

Then again, I guess it could just be a hallucination -- since I've been doing this for 8 years now. ;-)

-----Original Message-----

Sent: Thursday, August 17, 2000 6:58 PM
To: Multiple recipients of list ORACLE-L

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

--

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

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

--

Author: Steve Orr
INET: sorr_at_arzoo.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 Received on Fri Aug 18 2000 - 15:28:22 CDT