What is the difference between join and union.27 165776
What is the difference between anonymous block and named blocks?3 8186
what is inline view?15 34335
what is the difference between implicit conversions and explicit conversions?2 7418
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 10329
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 6649
What is Referential Integrity?3 5974
can we update a view which is created from two tables11 28510
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 10814
Can u create a primary key with out unique index.8 10869
what are the demerits of sql?1 4044
What action do you have to perform before retrieving data from the next result set of a stored procedure ?1742
What cursor type do you use to retrieve multiple recordsets?17 58018
What are all different types of collation sensitivity?
What are database links used for?
Can you join views in sql?
Can you upgrade sql express to full sql?
What is percent sign in sql?
how is myisam table stored? : Sql dba
What is rowtype?
What is data abstraction in sql?
what is row? : Sql dba
How do I run a query in pl sql developer?
Can we join same table in sql?
Is ms sql traffic encrypted?
What is foreign key in sql with example?
what is the difference between sql and t-sql? : Transact sql
how to use regular expression in pattern match conditions? : Sql dba