Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
write a stored procedure for following eg::
ramesh
Aug 13 2012 8:14 AM
1.5k
Reply
i have the backend table like
countryid countryname state
11
india
ap
12
aus
sydny
13
pak
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Procedure created with compilation errors.
Return types of Result Set variables or query do not match please correct the problem