Bernandas Savarimuthu

SQL & PL/SQL Colletions

Friday, February 20, 2009

Query - Names in given order

SELECT REGEXP_REPLACE('Muthu Bernandas Savari', '(.*) (.*) (.*)','\2 \3\1') FROM dual
Posted by Bernandas at 4:24 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)
free counters

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Total Pageviews

HitCount

hit counter
hit counter
Nothing comes easy...

Blog Archive

  • ►  2014 (1)
    • ►  November (1)
  • ►  2012 (3)
    • ►  September (1)
    • ►  August (2)
  • ►  2011 (4)
    • ►  April (1)
    • ►  January (3)
  • ►  2010 (12)
    • ►  December (1)
    • ►  September (1)
    • ►  July (2)
    • ►  June (5)
    • ►  May (1)
    • ►  March (2)
  • ▼  2009 (10)
    • ►  September (1)
    • ▼  February (5)
      • Query - Names in given order
      • Query - Contain any character that is not a numeri...
      • Second Largest Number
      • Last month first date
      • To know the current week of the year
    • ►  January (4)
  • ►  2008 (68)
    • ►  October (37)
    • ►  September (31)

About Me

My photo
Bernandas
View my complete profile
Picture Window theme. Theme images by Airyelf. Powered by Blogger.