Results 1 to 2 of 2

Thread: PL/SQL table vs Global Temporary Table

  1. #1
    Junior Member
    Join Date
    Aug 2013
    Answers
    2

    Question PL/SQL table vs Global Temporary Table

    Difference between PL/SQL table and Global Temporary Table.
    why we use Global Temporary Table without using PL/SQL Table.


  2. #2
    Expert Member
    Join Date
    Sep 2005
    Answers
    206

    Re: PL/SQL table vs Global Temporary Table

    Quote Originally Posted by Sukanta2013 View Post
    Difference between PL/SQL table and Global Temporary Table.
    why we use Global Temporary Table without using PL/SQL Table.

    Hello Sukanta,

    It's hard to compare these two as the purpose is different ..

    Any I am trying best to explain the difference between two

    Global Temporary table data is private and inserted on session basis and can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for the whole session, or just for the current transaction.

    PL/SQL tables are designed for access with PL/SQL commands. The only access to GTTs is via the SQL engine. You would use GTTs when you want to perform a small number of set-based operations without interleaving PL/SQL commands.

    Nested Table Object Types are a kind of hybrid solution. Pretty much the same as PL/SQL tables, but you can also access them with SQL at the overhead of casting the collection to what is effectively a temporary table.

    Thanks,
    Suji


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