Answer Posted / ganesh
cursor is a small work area like memory which are given by
oracle to execute sql statement, after execution this space
are made free for another sql staments to execute.
when we use the cursor with cursor name for a tble,then
that cursor will bring those from database one by one and
will keep in cursor memory for execution.
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Can we rename a column in the output of sql query?
How do I get sql certification?
Can you have more than one key in a database?
Is it possible to read/write files to-and-from PL/SQL?
Is sql a oracle?
How run sql*plus commands that are stored in a local file?
Can you join a table to itself?
What are the different ddl commands in sql?
Is left join inner or outer?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is sql and how does it work?
Can we connect to postgresql using sql developer?
What is a composite primary key?
What are the two parts of design view?
Can we use threading in pl/sql?