Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQLPlus was Oracle - "can you imagine" ;-)
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
-- 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
![]() |
![]() |