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 12087declare 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 7732Given 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 13132What action do you have to perform before retrieving data from the next result set of a stored procedure ?
2078What cursor type do you use to retrieve multiple recordsets?
Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,
17 64604
What is the difference between drop and truncate commands?
What are the rules to be applied to nulls whilst doing comparisons?
Is not equal in sql?
What are reports usually used for?
How many scalar data types are supported in pl/sql?
What is nested table in pl sql?
what are date and time intervals? : Sql dba
What is parameter substitution in sql?
what are the types of join and explain each? : Sql dba
what is primary key? : Sql dba
what is timestamp in mysql? : Sql dba
How do you create a db file?
How to add new employee details in an employee_details table with the following details
What is the most restrictive isolation level? : Transact sql
What is secondary key?