Is sql a scripting language?
No Answer is Posted For this Question
Be the First to Post Answer
If a cursor is open, how can we find in a pl/sql block?
What is sql and its types?
Is stored procedure faster than query?
what is called after appearing where clause
When sql appeared?
What is the difference between UNIQUE KEY and UNIQUE INDEX?
why not null constraint showing its constraint type as 'c'
Which are the most commonly used sql joins?
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 are tables in sql?
3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);
What is normalization in sql?