Sqlplus [message #1652] |
Fri, 17 May 2002 08:37 |
Raja
Messages: 57 Registered: March 2000
|
Member |
|
|
Hi,
I would like to know the different flavours of the SQL-92-ANSI standard for SQL. Oracle provides SQL-PLUS as its SQL product.
I would like to find out the different versions of SQL-92 from different RDBMS vendors. This is for comparison purposes. Could anyone help me please.
Thanks
Raja
|
|
|
Re: Sqlplus [message #1677 is a reply to message #1652] |
Tue, 21 May 2002 21:54 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
SQL*Plus is Oracle's Command Line Tool for issuing SQL commands. With the environmental setting FLAGGER (Usage: SET FLAGGER { OFF | ENTRY | INTERMEDIATE | FULL }) you can decide whether you want to follow the SQL-92 standard. Example (DECODE is an Oracle specific built-in):
==========================
SQL> show flagger
flagger OFF
SQL> select decode(dummy,'X','Y',dummy)
2 from dual;
D
-
Y
SQL> set flagger full
SQL> select decode(dummy,'X','Y',dummy)
2 from dual;
from dual
*
ERROR at line 2:
ORA-00097: use of Oracle SQL feature not in SQL92 Full Level
ORA-06550: line 2, column 8:
PLS-01416: Use of <id> (<value>...) here
====================
All depends, of course, what version of Oracle we're talking about. Oracle 9i is contains even more features concerning ANSI:
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/ap_standard_sql.htm#10293
See also:http://www.tek-tips.com/gfaqs.cfm/spid/220/sfid/1073
HTH,
MHE
|
|
|