What is correlated sub-query?7 37470
how instead of triger is helpful for mutating tables errors handlling ?2 8493
What are the advantages of the packages6 8650
what are the advantages of primary key over unique+notnull7 18134
how to retrieve the top 3 salaries of the table using rownum31 28136
what is the difference between union and union all14 38216
What is the difference between join and union.27 166337
declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?7 10454
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 ?3 6743
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.9 10986
What cursor type do you use to retrieve multiple recordsets?17 58536
Two Methods of retrieving SQL?7 50616
How do you optimize SQL queries ?6 29213
How well can multiple sessions access the same data simultaneously ?1 2036
Delete duplicate records in the emp table.6 11402
Are c# objects passed by reference?
Whether php supports microsoft sql server?
Explain the processing speed difference between Hadoop and Apache Spark?
Which is dependent variable?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is embedding projector?
Do you have to initialize variables in php?
How will you reverse a list?
rajha power sector details
Define the term Capacitance and Inductance?
list the important tables used in pp.
What are cells?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
what is the full form for MAN B&W engine which is as follows - 6ESDZC 34/82
What are the steps to create a data model?