*** 36,41 ****
--- 36,43 ----
START WITH <conditions> CONNECT BY [PRIOR]<conditions> (ORACLE)
+ *: 2003.10.30 : INSERTing fewer values than columns does not fill the missing columns with the default values; if fewer values than columns in the table are supplied, all columns filled have to be named before the keyword values
+
*: 2003.09.04 : Multi-column IN clause (ie. SELECT * FROM tab WHERE (key1, key2) IN (SELECT...)
*: 2003.08.29 : UPDATE with a FROM clause (not sure if this is standard, Sybase and Microsoft have it). -> UnsupportedSqlUpdateWithFrom
***************
*** 61,72 ****
*: 2003.07.28 : Stored Procedures
*: 2003.07.28 : Rollup and Cube -> UnsupportedSqlRollupAndCube
-
- *: INSERTing fewer values than columns does not fill the missing columns with
- the default values; if
- fewer values than columns in the table are supplied, all columns filled have to
- be named before the
- keyword values
*: INSERTing one record with all VALUES to DEFAULT: INSERT INTO example ()
VALUES ();
--- 63,68 ----
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|