Answer Posted / yaswanth
IN looks for specified value and
EXISTS looks for whether particular row exists or not
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is assignment operator in pl sql?
What are all different types of collation sensitivity?
What are sql indexes?
How do I count records in sql?
give the syntax of grant and revoke commands? : Sql dba
What is foreign key sql?
What are the types of operators available in sql?
What is the difference between partitioning and sharding?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Does db2 use sql?
what are the features and advantages of object-oriented programming? : Sql dba
Define concurrency control. : Transact sql
What is a left inner join?
What is forward declaration in pl sql?
Which normal form is best?