State the difference between implict and explict cursor's?
Answer Posted / nageswara rao orsu
Implicit cursors: used for all DML statements and
single-row queries
Explicit cursors: used for queries of zero, one, or
more rows
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is dense_rank?
What is informix sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
When sql appeared?
what is union, minus and interact commands? : Sql dba
How many types of tables are there?
What is record variable?
Why do we use partitions in sql?
what are date and time functions in mysql? : Sql dba
What is posting?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How do I run a pl sql procedure in sql developer?
What is java sql driver?
Describe sql comments?
Are pl sql variables case sensitive?