Explain the difference between rename and alias?
No Answer is Posted For this Question
Be the First to Post Answer
What is auto increment?
What is a package ? What are the advantages of packages ?
What is the Query to print out the individual total number of duplicate row in sql.
Does db2 use sql?
What is package in pl sql?
How to disable a trigger name update_salary?
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;
How do I send sql query results to excel?
table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.
Why query optimization is needed?
What is the difference between execution of triggers and stored procedures?
How do I partition a table in sql?