SQL query help - Oracle syntax

[isthri_chembu]

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; 

[loveindia]

endi man rachaa eeda....

[kakatiya]

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

[loveindia]

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... 

[kakatiya]

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... 

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