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.
Posted by Huiming Li at 3:56 PM No comments:

Tuesday, May 22, 2007

Initcap

An interesting function:

SQL> select initcap('abc XYZ') from dual;

INITCAP('ABCXY
--------------
Abc Xyz
Posted by Huiming Li at 4:43 PM No comments:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2021 (2)
    • ►  June (1)
    • ►  May (1)
  • ►  2019 (1)
    • ►  May (1)
  • ►  2017 (1)
    • ►  August (1)
  • ►  2016 (1)
    • ►  February (1)
  • ►  2015 (1)
    • ►  November (1)
  • ►  2013 (4)
    • ►  November (3)
    • ►  April (1)
  • ►  2012 (2)
    • ►  January (2)
  • ►  2010 (4)
    • ►  December (1)
    • ►  October (1)
    • ►  September (1)
    • ►  April (1)
  • ►  2008 (5)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
    • ►  June (1)
  • ▼  2007 (7)
    • ►  December (1)
    • ►  October (1)
    • ►  August (1)
    • ▼  May (2)
      • Unix Shell Integer Comparison
      • Initcap
    • ►  January (2)
  • ►  2006 (24)
    • ►  December (3)
    • ►  November (1)
    • ►  August (3)
    • ►  July (1)
    • ►  May (2)
    • ►  April (3)
    • ►  March (4)
    • ►  February (7)

About Me

Huiming Li
Life is a transaction with no option to issue a rollback.
View my complete profile

Links

  • Ask Tom
  • If you read chinese
  • Chinese Chess
Simple theme. Theme images by tjasam. Powered by Blogger.