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