Jump to content

SQL query help - Oracle syntax


pumpkin

Recommended Posts

Try this..

WITH a 
     AS (SELECT 'barackobama.123' col1 
         FROM   dual 
         UNION ALL 
         SELECT '67.MP.PK\.2211\.E8' col1 
         FROM   dual) 
SELECT CASE 
         WHEN Length(Trim(TRANSLATE(Substr(col1, 1, 1), '0123456789', ' '))) IS 
              NULL 
       THEN 
         Substr(col1, 1, CASE 
                           WHEN Instr(col1, '.') = 0 THEN Length(col1) 
                           ELSE Instr(col1, '.') - 1 
                         END) 
         ELSE col1 
       END 
FROM   a; 

Link to comment
Share on other sites

  • Replies 34
  • Created
  • Last Reply

Top Posters In This Topic

  • JollyBoy

    10

  • mtkr

    9

  • pumpkin

    8

  • loveindia

    2

Top Posters In This Topic

Friends i am trying to learn SQL..where can I get free oracleSQL server download for running SQL queries and testing them ?

 

Also database create chesi how to import tables??

 

Two days nunchi enni softwares install chesina i couldn't find a SQL coMpiler.

 

SQL plus aithe iNka best

Link to comment
Share on other sites

1 minute ago, kakatiya said:

Friends i am trying to learn SQL..where can I get free oracleSQL server download for running SQL queries and testing them ?

 

Also database create chesi how to import tables??

 

Two days nunchi enni softwares install chesina i couldn't find a SQL coMpiler.

 

SQL plus aithe iNka best

sql developer download chesko man... look for backup copy and restore it man... oracle antunnav kabatti... sql server aitey download 2016 from microsoft directly and download backups like adventure works / north wind / contoso man... gallery_8818_6_385253.gif

Link to comment
Share on other sites

2 minutes ago, loveindia said:

sql developer download chesko man... look for backup copy and restore it man... oracle antunnav kabatti... sql server aitey download 2016 from microsoft directly and download backups like adventure works / north wind / contoso man... gallery_8818_6_385253.gif

Links dedi..manaki abcds kooda raavu..just time pass ki nerchukuni na

I would like to install Oracle SQL coMpiler..microsoft vi work out kala

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...