Results 1 to 2 of 2

Thread: PLSQL TAble Type v/s Cursor

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Post 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


  2. #2
    Junior Member
    Join Date
    Apr 2008
    Answers
    1

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact