TAB view

[Chintz]

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.

[DBAtrix]

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.