Explaint the nvl2 function - Sybtax:- - nvl2(expr1,expr2,expr3)In nvl2 if expr1 evaluates to NULL then expr3 is returned and if it evaluates to some value it returns expr2.for e.g select nvl2(commission_pct,'SAL+COMM','SAL') from employees;if commission_pct is having null value then SAL will be displayed else SAL+COMM.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question: Explaint the nvl2 function

Answer: Sybtax:- - nvl2(expr1,expr2,expr3)In nvl2 if expr1 evaluates to NULL then expr3 is returned and if it evaluates to some value it returns expr2.for e.g select nvl2(commission_pct,'SAL+COMM','SAL') from employees;if commission_pct is having null value then SAL will be displayed else SAL+COMM.

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7986 users
Added on	8/18/2011
Views	74296
Rate it!

Question: Explaint the nvl2 function

Answer:

Sybtax:- - nvl2(expr1,expr2,expr3)In nvl2 if expr1 evaluates to NULL then expr3 is returned and if it evaluates to some value it returns expr2.for e.g select nvl2(commission_pct,'SAL+COMM','SAL') from employees;if commission_pct is having null value then SAL will be displayed else SAL+COMM. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	what is place holder column? where we can use other than formula column?	View Answer
	What is the difference between groupby and orderby?	View Answer
	What is the process of upgrading oracle forms /reports from older version to new versions?	View Answer
	How many codds rule should oracle satisfies	View Answer
	What is the difference between object library and pl/sql library	View Answer
	List out differences between Oracle Server 9i and Oracle Server 10g.	View Answer
	Explain truncate with restore option with example	View Answer
	What is the difference between Anonymous Block and subprogram? Can we call a procedure from Anonymous PL/SQL block?	View Answer
	How to get a calender in date field in oracle forms?	View Answer
	I have a server with 2GB RAM.Who is the optimal size for the shared pool size The shared pool reserved size is 1/10 to shared pool size Is there a mathematic type for compute the shared pool size ?	View Answer
	I want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string...what should i do with login.sql script.. i Put it in /Bin directory..but not working..	View Answer
	Explaint the nvl2 function	View Answer
	When transporting a tablespace from one database to another, it should be a. Read-only. b. Offline. c. Online. d. Tablespace status does not matter.	View Answer
	Which NLS parameter can be specified only as an environment variable? a. NLS_LANGUAGE b. NLS_LANG c. NLS_TERRIROTY d. NLS_SORT	View Answer
	Which parameter in the export file is used to specify a structure –only export (no rows)? a. ROWS b. TABLE c. NODATA d. DIRECT	View Answer
	What does the parameter DIRECT=Y in the export parameter file signify? a. When exporting table data, bypass the SQL buffer cache and read the data blocks directly form the disk to the export file. b. When exporting table data, bypass the SQL processing layer and read data from disk to the buffer cache, and copy them directly to the export files c. When importing data using the export file create, write data blocks directly to the file, rather than going through the buffer. d. To perform a direct import, the export file must be created sing the direct method.	View Answer
	Choose the statement that is not true. Direct-path load a. Disables insert triggers on the table and enables them after the load completes. b. Disables referential integrity constraints and enables them after the load completes. c. Disables unique constraints and enables them after the load completes. d. Does not disable any constraints or triggers.	View Answer
	Which utility would you use to refresh the test table with production data? a. SQLLoader conventional path b. SQL Loader direct path c. Export/import d. SQL * Plus direct-load insert	View Answer
	To use the transportable tablespace feature, the block size of the target and source database should be a. 4KB b. Same size c. Not larger that 16KB d. Different size	View Answer
	If you run the ALTER SESSION SET NLS_DATE_FORMAT + ‘DDMMYY” statement, which dictionary view would you query to see the value of the parameter? a. V$SESSION_PARAMETERS b. NLS_SESSION_PARAMETERS c. NLS_DATABASE_PARAMETERS d. V$SESSION	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode