Doubt

[cherlapalli_jailer]

GOT it ignore the above use below one

[cherlapalli_jailer]

select CASE count(*) when 0 then 'F' else ZIP_STATE end as state from table_nm where ZIP= '12344'

or

[laggaitthu]

Ok ba lunch lo unna ellagaane try chestha

[cherlapalli_jailer]

hello r u there did it work??

[laggaitthu]

[quote name='cherlapalli_jailer' timestamp='1346353904' post='1302409236']
hello r u there did it work??
[/quote]
I'm in lunch mama

Syntax mottham same ey na ?

[cherlapalli_jailer]

[quote name='laggaitthu' timestamp='1346353997' post='1302409252']
I'm in lunch mama

Syntax mottham same ey na ?
[/quote]
table name and field names correct a Add cheyyi

[laggaitthu]

[quote name='cherlapalli_jailer' timestamp='1346354026' post='1302409255']

table name and field names correct a Add cheyyi
[/quote]

Ok sure try chesi cheptha

[vikuba]

aada pani kaavaala neeku lunch kaavala ? lunch can wait...isnt it

[cherlapalli_jailer]

i am looking for u aamphat
can u run that query ...i don't have any tool are DB ready to run the query

[laggaitthu]

[quote name='Aamphat' timestamp='1346354287' post='1302409287']
aada pani kaavaala neeku lunch kaavala ? lunch can wait...isnt it
[/quote]
Mama bayatakochi trainer ki Phn chesthunna mama answer chyatla LK gadu

[laggaitthu]

[quote name='cherlapalli_jailer' timestamp='1346354332' post='1302409299']
i am looking for u aamphat
can u run that query ...i don't have any tool are DB ready to run the query
[/quote]
Oka 5 mins lo eltha desk ki

[macha]

[quote name='Aamphat' timestamp='1346354287' post='1302409287']
aada pani kaavaala neeku lunch kaavala ? lunch can wait...isnt it
[/quote]


correct .... venky gif vesukoo ....

[Cherry25]

Edo try chesa..


create procedure test(zip number) as
--var1 this depends on table type u want to choose
var2 varchar2(1);
begin
select col2 into var1 from table where col1=zip;
--display var1;
exception
when no_data_found then
select col3 into var2 from table where col1=zip;;
--display var2
end;
/

[laggaitthu]

nenu download chesina flie ni DB lo kottha table create chesi aa table ki already unna zips table ki OUTER JOIN use chesi query raayamanandu

[vikuba]

nen thread ni follow aituna...its a CASE thing.
naa deggara table lekunda nen query etla run cheyaali ?
example create chesi run cheyadama antey not feasible[quote name='cherlapalli_jailer' timestamp='1346354332' post='1302409299']
i am looking for u aamphat
can u run that query ...i don't have any tool are DB ready to run the query
[/quote]