The following will work: select "SIZE" from v$type_size;
Since 'size' is an ORACLE reserved word, that is why you can't use it in a
select statement. Since you get an 'invalid column name' message if you try
to use it as a column name in a view or a table, you'd think ORACLE would
know better.
John Wang wrote in message <6gepnq$rb$1_at_winter.news.erols.com>...
>Hi, folks:
>
>there is this view called V$type_size. if you do select size from
>v$type_size, you will get an oracle error: missing expression. i cannot
>figure why it does that. size is a column in the view. why can I not
>select it?
>
>The reason I use it is I need to get a formula to estimate the space for
>tables. In oracle documentation, there is a formula that does that, it is
>referencing that view. is there any script or utility that can estimate
>space for non clusterred tables?
>
>thanks
>
>john w.
>
>
Received on Wed Apr 08 1998 - 15:23:17 CDT
