2
Reply

write a stored procedure for following eg::

ramesh

ramesh

Aug 13 2012 8:14 AM
1.5k
i have the backend table like 
countryid  countryname  state
11india                 ap
12aus                sydny
13pak                  

so  when i give the countrynam 'pak' state column display null value but i want display some text msg instead of null pls write the program for that in stored procedure in plsql only




countryname: pak     statename:  

i want result like that countryname: pak     statename:there is not states

Answers (2)