Answer Posted / suresh somayajula
Cursor for loop implicitly declares %rowtype as Loop index
opens the cursor and fetch the rows from active set into
fields and then process it and then close the cursor.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How to revise and re-run the last sql command?
What is character functions?
when is the use of update_statistics command? : Sql dba
What are crud methods?
Is sql port 1433 encrypted?
What is the difference between sql and mysql?
what is a database lock ? : Sql dba
How do I count rows in 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
What is difference between pls_integer and integer?
What is the difference between an inner join and an outer join?
What is union?
How do I run a sql query in pgadmin 4?
Why use truncate instead of delete?
What are sql procedures?
