What is the difference between join and union.27 170038
What is the difference between anonymous block and named blocks?3 8862
what is inline view?15 36412
what is the difference between implicit conversions and explicit conversions?2 7823
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 11295
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 7259
What is Referential Integrity?3 6479
can we update a view which is created from two tables11 29873
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 12084
Can u create a primary key with out unique index.8 11836
what are the demerits of sql?1 4376
What action do you have to perform before retrieving data from the next result set of a stored procedure ?1957
What cursor type do you use to retrieve multiple recordsets?17 62262
What is a data manipulation language?
What is the difference between mdf and ndf files?
What is the difference between left and left outer join?
How can you tell the difference between an index and a view?
How do I view output in sql developer?
What is the full form of sql?
What is normalization in sql?
What is a mutating table and a constraining table?
What is sql query optimization?
Write the alter statement to enable all the triggers on the t.students table.
Show code of a cursor for loop.
What is Histogram?
What is Difference Between Unique and Primary Key Constraints?
How do I create a sql script?
What is the difference between sql and mysql?