why pl sql doesn't support retrieving multiple records
Answer / rahul
pl/sql supports retriving multiple records but u need to
use of cursors. using cursor you can retrieve multiple
records.
| Is This Answer Correct ? | 24 Yes | 3 No |
How to rename a column in an existing table?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
Is it possible to insert comments into sql statements return in the data model editor ?
How to bring a tablespace online?
Explain the use of file option in exp command.
What is SYSTEM tablespace and When is it Created?
how can we store any pdf file in oracle
Describe the types of sub query?
What is the difference between substr and instr?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
What is procedure overloading in oracle?