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

Wednesday, November 22, 2006

Decimal to hex and vice versa

select to_char(134829, 'XXXXX') from dual;
select to_number('AFF0', 'XXXXXX') from dual;
Posted by Huiming Li at 1:30 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (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)
    • ►  January (2)
  • ▼  2006 (24)
    • ►  December (3)
    • ▼  November (1)
      • Decimal to hex and vice versa
    • ►  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.