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?
Submitted by: Administratorselect nvl(ename,'value not available') from student;
Submitted by: Administrator
Submitted by: Administrator
Read Online OCI Job Interview Questions And Answers
Top OCI Questions
| ☺ | What is database normalization? |
| ☺ | What is the main difference between foreign key and primary key? |
| ☺ | Tell me in function why return single value? |
| ☺ | What is difference between SQL Server and Oracle? |
| ☺ | Can we use a having clause in groupby clause? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
