SQL query help - Oracle syntax

[JollyBoy]

@pumpkin work ainda 

[mtkr]

Just now, JollyBoy said:

 

akada oracle sami.. 

yaap...

nen paina cheppidnhi maatram Tsql gurinche...

 

[pumpkin]

11 minutes ago, JollyBoy said:

select substr(col,1,NVL(Instr(Col,’.’),len(col))) 

it works except in one scenerio

 

RSAHULIII.D.MODIIII\.7865\.GF for this value i must get as it ease i am getting RSAHULIII

[JollyBoy]

Just now, pumpkin said:

it works except in one scenerio

 

RSAHULIII.D.MODIIII\.7865\.GF for this value i must get as it ease i am getting RSAHULIII

as it is enduku vastadi..   

"." find cheyagane truncate chestadi rest.. ade kada req 

[mtkr]

1 minute ago, pumpkin said:

it works except in one scenerio

 

RSAHULIII.D.MODIIII\.7865\.GF for this value i must get as it ease i am getting RSAHULIII

first union lo vasthadi gaa idii!!?

[JollyBoy]

Just now, mtkr said:

yaap...

nen paina cheppidnhi maatram Tsql gurinche...

 

ya nadi TSQL ey.. and dont use cases man 

[mtkr]

1 minute ago, JollyBoy said:

ya nadi TSQL ey.. and dont use cases man 

ok..

 

but

[pumpkin]

3 minutes ago, JollyBoy said:

as it is enduku vastadi..   

"." find cheyagane truncate chestadi rest.. ade kada req 

only numbers start avute ala truncate kavali if it starts with alpha numeric i need to see the value as it ease

[JollyBoy]

3 minutes ago, mtkr said:

ok..

 

but

i try to avoid for readability and use minimal only when needed

[JollyBoy]

6 minutes ago, pumpkin said:

only numbers start avute ala truncate kavali if it starts with alpha numeric i need to see the value as it ease

select case when to_number(LEFT(col,1) ) = 1 then substr(col,1,NVL(Instr(Col,’.’),len(col)))   else  col end 

[JollyBoy]

@pumpkin  try this

[mtkr]

6 minutes ago, JollyBoy said:

i try to avoid for readability and use minimal only when needed

okkk...

[pumpkin]

12 minutes ago, JollyBoy said:

select case when to_number(LEFT(col,1) ) = 1 then substr(col,1,NVL(Instr(Col,’.’),len(col)))   else  col end 

 select case when to_number(substr(name,1) ) = 1 then substr(name,1,NVL(Instr(name,'.'),length(name)))   else  name  end from tt;

thats what i am getting

ORA-01722: invalid number
01722. 00000 -  "invalid number"
*Cause:    
*Action:

[JollyBoy]

2 minutes ago, pumpkin said:

 select case when to_number(substr(name,1) ) = 1 then substr(name,1,NVL(Instr(name,'.'),length(name)))   else  name  end from tt;

thats what i am getting

ORA-01722: invalid number
01722. 00000 -  "invalid number"
*Cause:    
*Action:

man telidu man.. chuste kani chepalenu.. i am not oracle guy

[pumpkin]

1 minute ago, JollyBoy said:

man telidu man.. chuste kani chepalenu.. i am not oracle guy

thanks for ur insight