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
How many types of normalization are there?
What is a cursor ? Why Cursor is required ?
who introduced sql?
what is sql profiler
What is the difference between between and in condition operators?
package specification-3 procedures package body-4 procedures how can i write for other procedure in package body
What is mutating trigger?How to avoid it??
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;
explain the advantages and disadvantages of stored procedure? : Sql dba
How to run sql commands in sql*plus?
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.
How do you update a value in sql?