Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

asterisk (select * ) - possible disadvantages?

533392Sep 12 2006 — edited Apr 27 2007
hi!

Could you list all possible disadvantages you can see of using asterisk in views/inline views etc.?

For instance, I can't realize this wide-used practice to select all columns by using asterisk in inline view and then let's say select only two columns from 50 columns of this view at upper level of query. something like this
select cv.id,
cv.name
from
(
select cv.* from some_table) cv;

I guess there might be some other reasonable exaplanations/reasons not use asterisk.

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2007
Added on Sep 12 2006
19 comments
2,196 views