-
Junior Member
PLSQL TAble Type v/s Cursor
I have a Requirement to extract data fron database into .csv file...
I m using utl_file pckg to do so...
But But before writing into the file , I am fetching the records using cursors...
I can also use PLSQL table types to do .....
I wanted to know which one to use either cursor or plsql types..which one is most feasible solution ?
Thanks,
Vijay
-
Junior Member
Re: PLSQL TAble Type v/s Cursor
Hi Vijay,
PL/SQL Table type we can declare and we need to initialize all the value to that table.
But cursors will take all the data from database table.
Ramesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules