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

Thread: TAB view

  1. #1
    Join Date
    Dec 1999
    Posts
    217
    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,
    Chintz.

  2. #2
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    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.

    d.

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