How can check sql version from command line?
Does sql backup shrink transaction log?
how to saw triggers output in pl/sql database?
Define the select into statement.
What does pl sql stand for?
With out using count() function. How to the find total number of rows in a table?
what is user defined functions? : Sql dba
What can sql server reporting services do?
what are aggregate and scalar functions? : Sql dba
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;
What is a primary key, and how is it different from a unique key?
Is delete faster than truncate?
What is a primary key example?