why pl sql doesn't support retrieving multiple records
- 1 Answers
- 6461 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are the restrictions on external table columns?
Give the advantages and disadvantages of clusters.
What is the max number of columns in an oracle table?
Can a formula column be obtained through a select statement ?
How will you differentiate between varchar & varchar2?
How to get maxsal , minsal, ename department wise in single query
Explain the use of ignore option in imp command.
How to do a full database export?
What are the execution control statements in oracle?
Why cursor variables are easier to use than cursors?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Can you tell me how to add new column in existing views?how?How is possible?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is set verify off in oracle?
