Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQLPlus was Oracle - "can you imagine" ;-)

RE: SQLPlus was Oracle - "can you imagine" ;-)

From: Keith Peterson <keithpson_at_YAHOO.COM>
Date: Fri, 17 May 2002 09:28:36 -0800
Message-ID: <F001.0046389B.20020517092836@fatcity.com>


You mean that 40% A/V - 80%proof was not ketchup...?

and the most complex question for the group in those days would have been:

"I am new to Oracle and I have this problem....
SQL> desc emp

 Name                            Null?    Type
 ------------------------------- -------- ----
 EMPLOYEE_ID                              NUMBER(4)
 LAST_NAME                                VARCHAR2(15)
 FIRST_NAME                               VARCHAR2(15)
 MIDDLE_INITIAL                           VARCHAR2(1)
 JOB_ID                                   NUMBER(3)
 MANAGER_ID                               NUMBER(4)
 HIRE_DATE                                DATE
 SALARY                                   NUMBER(7,2)
 COMMISSION                               NUMBER(7,2)
 DEPARTMENT_ID                            NUMBER(2)
 FAT/TITLE                                VARCHAR2(40)

SQL> select fat/title
  2 from emp;
select fat/title

           *
ERROR at line 1:
ORA-00904: invalid column name

SQL> c/fat\/\title/"FAT/TITLE"
String not found.
SQL> drop the employees fat/title;
drop the employees fat/title

     *
ERROR at line 1:
ORA-00950: invalid DROP option

SQL> huh?
unknown command "huh?" - rest of line ignored. SQL> Keith

Date: Fri, 17 May 2002 07:18:21 -0800
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Reply-to: ORACLE-L_at_fatcity.com
;-)
Organization: Fat City Network Services, San Diego, California      

Have you been on the sauce ???

-----Original Message-----
Sent: 17 May 2002 15:54
To: Multiple recipients of list ORACLE-L

ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid.

"About 15 years ago, Sqlplus WAS Oracle". Nothing
else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes):
no procedures,
no packages, package body, functions
no triggers
no sequences (can you imagine... this came with V6) no ref constraints
no 2-phase commit
no snapshots, no snapshot logs
no parallel server
...

can you imagine! and it was already the most powerful database server growing at >100% year over year (100% growth for 13 years in a row)

I mean "can you imagine" SQLPLUS "was" ORACLE....can you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues.... "can you imagine"....;-)

Keith



Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Keith Peterson
  INET: keithpson_at_yahoo.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).
Received on Fri May 17 2002 - 12:28:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US