PLSQL TAble Type v/s Cursor

[vijay.patil2005]

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

[ramesh.3782]

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