OCI Question:
Download Questions PDF

Suppose 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:

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

Download OCI (Oracle Call Interface) Interview Questions And Answers PDF

Previous QuestionNext Question
What is difference between sap and oracle applications and which is now market leader?What is difference between SQL Server and Oracle?