Interviewer And Interviewee Guide

OCI Interview Question:

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: Administrator
select nvl(ename,'value not available') from student;
Submitted by: Administrator

Read Online OCI Job Interview Questions And Answers
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.