Oracle SQL tips and tricks + Unix/Linux Work Log
See how much a single Oracle SQL statement can do... Plus some Unix/Linux Work Log
Friday, May 25, 2007
Unix Shell Integer Comparison
In Unix shell,
Use -ne -eq -lt -gt to compare numbers.
== and != are used for string comparison.
Perl does the things on the opposite.
Tuesday, May 22, 2007
Initcap
An interesting function:
SQL> select initcap('abc XYZ') from dual;
INITCAP('ABCXY
--------------
Abc Xyz
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)