What is correlated sub-query?7 32460
how instead of triger is helpful for mutating tables errors handlling ?2 6461
What are the advantages of the packages6 6070
what are the advantages of primary key over unique+notnull7 13394
how to retrieve the top 3 salaries of the table using rownum31 19982
what is the difference between union and union all14 30704
What is the difference between join and union.27 145466
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 7831
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 4852
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 7446
What cursor type do you use to retrieve multiple recordsets?17 45681
Two Methods of retrieving SQL?7 42810
How do you optimize SQL queries ?6 23037
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?12 9596
what is 16kHz use in GSM
How to calculate entry tax on kraft papers format in excel under Assam Entry tax rules?
hiiiii Respected sir/madam gd morning sir/Madam Can you please give me following questions of answer.? 1) what is the main difference between Current Assests and Fixed Assests? 2) working capital Management? why? which steps requried for working capital management at the statring day of the any type of business? 3) Ratio analysis? why? (Note: 1,on the above questions of answer the following points are exculded) 1) object 2) theory 3) features (Note :2,on the aove questions of answer the follwing points are inculded) 1) Practical oriented 2) aspects of business please reply..................
Do any body have successfully submitted P&G management evaluation form online. I did it but failed. Can anybody help me ? I put all questions on a paper and tried my best to solve it but facing problems? Can anybody discuss it ?
Tell me something about any ur tour?How u enjoy in that tour tell briefly?
why u have changed the university?
What are the advantages of oledb compared with other classes?
what to in pro
Hi all, Is there any certification exams available for TCL and Perl. If so please let me know, my mailid is email@example.com. Thanks in advance, Bharathi.P
how to calculate cooling requirement of datacentre from electrical load?
What is Non-Linear Filters?
What is Edge finding?
Can any One Plz Help Me with TDS Charts & Filling? Plz Send Me All Details to My email Id: firstname.lastname@example.org Plz Its Asked to Me In My Interview Held In Coming 2 Or 3 Days
hi i have applied for lic of india south cenrtal zonal ,hyd. i didnt get hall ticket till now.let me know how can i get form internet
What are the challenges have you face as a Team Leader ?