Answer Posted / anil kumar jampana
cursor for loop is also a cursor. Here no need to handle
open,fetch,close operations. These operations are handled
by for loop.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What are sql objects?
Why we use cross join?
Why left join is used in sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is the difference between nvl function, ifnull function, and isnull function?
What does rownum mean in sql?
How do you concatenate in sql?
How can a function retun more than one value in oracle with proper example?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is clause in sql?
what is commit? : Sql dba
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
What are the two parts of design view?
what is the difference between join and union? : Sql dba