How can a function retun more than one value in oracle with proper example?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

How many types of normalization are there?

0 Answers  


What is a cursor ? Why Cursor is required ?

3 Answers  


who introduced sql?

0 Answers  


what is sql profiler

2 Answers   Fidelity,


What is the difference between between and in condition operators?

0 Answers  






package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,


What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,


Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,


explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  


How to run sql commands in sql*plus?

0 Answers  


I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  


How do you update a value in sql?

0 Answers  


Categories