*** 24,29 ****
--- 24,40 ----
*: 2004.11.17 : INSERTing one record with all VALUES to DEFAULT: INSERT INTO example ()
VALUES ();
+ *: 2004.08.13 : Oracle's join syntax using (+) and (-):
+
+ SELECT a1.a, a1.b, a2.a, a2.b
+ FROM a1 LEFT JOIN a2 ON a2.b = a1.a
+
+ _:...can be written in Oracle as:
+
+ SELECT a1.a, a1.b, a2.a, a2.b
+ FROM a1, a2
+ WHERE a1.a = a2.b(+);
+
*: 2004.04.25 : a password('') function to mask some values (as used in MySQL) would be fine, I need it, if I give the db out of the house, or is there something I didn't find? Or a simple MD5 function to obscure data
using a one way hash. See the MySQL function MD5 or Password for examples.
***************
*** 90,106 ****
*: 2003.07.28 : Stored Procedures
*: 2003.07.28 : Rollup and Cube -> UnsupportedSqlRollupAndCube
-
- *: Oracle's join syntax using (+) and (-):
-
- SELECT a1.a, a1.b, a2.a, a2.b
- FROM a1 LEFT JOIN a2 ON a2.b = a1.a
-
- _:...can be written in Oracle as:
-
- SELECT a1.a, a1.b, a2.a, a2.b
- FROM a1, a2
- WHERE a1.a = a2.b(+);
*: Oracle's Named Parameter output syntax. In Oracle, one can declare
parameters and select into them
--- 101,106 ----
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|