How do you optimize a query?
No Answer is Posted For this Question
Be the First to Post Answer
What is pl sql quora?
i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject
Describe different types of general function used in sql?
Can you have more than one key in a database?
what are the security recommendations while using mysql? : Sql dba
What are the default Oracle triggers??
What is null in pl/sql?
How long it takes to learn pl sql?
What is the difference between inner join and left join?
declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba