Interested to Buy Any Domain ? << Click Here >> for more details...
why pl sql doesn't support retrieving multiple records
- 1 Answers
- 6948 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
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How do I limit the number of rows returned by an oracle query after ordering?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to delete a column in an existing table in oracle?
Explain cascading triggers.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is an oracle user account?
Explain the use of analyse option in exp command.
Explain oracle instance.
How to create a table in a specific tablespace?
What is ceil and floor in oracle?
How many categories of data types in oracle?
How to write text literals in oracle?
What is the difference between a primary key & a unique key?
