Sql Exferts Ravali

[4Vikram]

Solution sepna ardam seskoleni stage lo unavanmata..jpgif

spider ga 

[twitteshbabu]

 

number(8,3)

 

 SELECT 'Y'

     INTO mul

     FROM DUAL

    WHERE REGEXP_LIKE (multiplier, '[._%-]');

 

ela try sesa vuncle .. "." unte .. Y ostadi lekapothe null ostadi ..danitoh i can find out ... but oracle form regexp_like use cheyanivatle ..

 

use translate instead

 

select * from tablename where translate(x, '.1234567890', '.') is null;

[twitteshbabu]

Select Case when column_name = round(column_name) then 'whole_number'else 'mod_number' end as ne_good from table_name;

spider spam spam spam spam 

[nenu_devudni]

Solution sepna ardam seskoleni stage lo unavanmata..jpgif

ipudu ardam ayindi nu seppagane .. thanks vuncle 

[nenu_devudni]

spider ga 

4vik etta unav  ...  is this real spider vuncle id or fake faker spider vuncle id 

[Afdb_spider]

spider spam spam spam spam

I no spam..jpgif

[Afdb_spider]

spider ga

After long long time camed...jpgif

[4Vikram]

4vik etta unav  ...  is this real spider vuncle id or fake faker spider vuncle id 

i am good devudu vuncle how you,, long time?  he is real man see the way he replied in query

[4Vikram]

After long long time camed...jpgif

nina word ante word  ee adi idi anav 

[twitteshbabu]

I no spam..jpgif

leader thata scene 

[Afdb_spider]

nina word ante word ee adi idi anav

Chapathi gadu struggle aithunte sudaleka reply ichna..adh kuda tappena adhyaksha..jpgif..

[nenu_devudni]

spider va .. case statement works just like regexp_like .. but oracle form la use cheste galiz ga thidutundi ..

[nenu_devudni]

i am good devudu vuncle how you,, long time?  he is real man see the way he replied in query

yes naku ee kastam ochina .. case statement toh ochi help sessadu ... he is the real spider 

[nenu_devudni]

Chapathi gadu struggle aithunte sudaleka reply ichna..adh kuda tappena adhyaksha..jpgif..

batta emana cover ayinda spider maya .. nu sepina solution inka work kale .. form la case pedithe thengay anadi .. aa case thapite inko solution seppav  ru 10+yr exp outside in handling cases

[4Vikram]

Chapathi gadu struggle aithunte sudaleka reply ichna..adh kuda tappena adhyaksha..jpgif..

ne help ki chapathi reaction vere undi no kaani