TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ramesh
NA
19
47.1k
write a stored procedure for following eg::
Aug 13 2012 8:14 AM
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
Reply
Answers (
2
)
Procedure created with compilation errors.
Return types of Result Set variables or query do not match please correct the problem