I have table that has student names in it.If I query on the
names my result set should return as 'VALUE NOT ENTERED'
for null entries.

Answer Posted / saiprasannach89

select nvl(ename,'value not available') from student;


Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

1961