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.
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.
Click Here to Expand Forum to Full Width