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 can we write trigger in trigger???????? can we write one trigger on two table???
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is MTTR advisor in Oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
what are archived logs?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to open a cursor variable?
What are a collation and state the different types of collation sensitivity?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Difference between varchar and varchar2 data types?
What are transaction isolation levels supported by oracle?
What is a subquery?