Are subqueries better than joins?
No Answer is Posted For this Question
Be the First to Post Answer
In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;
What plvcmt and plvrb does in pl/sql?
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 audit the sql sent to the server?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is dcl in sql?
What are the different set operators available in sql?
Difference between views and materialized views?
What is primary key in db?
Types of joins ?
What are different sql data types?
How to call a javascript function from pl sql?