DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: TAB view

  1. #1
    Join Date
    Dec 1999
    I have code in the application where it reads:

    "select xxx.NextVal from TAB;"

    Could someone give me some details on what is the reason of using TAB instead of DUAL?

    I believe, TAB is a vew for the user_tables. I would appreciate some more information on this.

    Thank You,

  2. #2
    Join Date
    Oct 2000
    Cambridge, MA (Boston)
    TAB was a data dictionary in versions prior to and including 6. i can think of no good reason to use it in lieu of dual. in fact, it is a bad idea, since there is no way of knowing how many rows will be returned. it's very curious.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.