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 declare a local variable?
What is the data type of dual table?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
After using set unused can we enable the column again to use? Please give me some answers....
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is oracle server autotrace in oracle?
How can Oracle users be audited?
Can we create trigger on materialized view in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How can I see all tables in oracle?
What are the commands youd issue to show the explain plan for select
What is autonomous transaction?