Re: Is is possible to do this in Oracle?

It appears that you have a misunderstanding about the nature of views. When you create a view the attributes of a column will exactly mirror that of the underlying table. What you see when you enter:

describe myview;

is only an estimation of the structure. You can't expect it to exactly reflect the real attributes.

Ken

Jimmy wrote:

> Hello all,
>
> I wonder whether the below requirements can be implemented in Oracle
> 7.3.3. (or higher)
>
> 1) Is it possible to specify the data type (and width) of the column in
> a view? I try "create view aaa (aaa number(22,6)) as select bbb from
> bbb" but failed.
>
> 2) I developed triggers and PL/SQL procedures and functions in Oracle
> 7.3.3. I don't want to let other developers to read the PL/SQL coding
> (triggers, procedures and functions). Is it possible to "hide" this
> coding even the developers have privileges to query the dba_source view?
> (for example, is it possible to set up the password?)
>
> Thanks,
> Jimmy
Received on Thu Aug 12 1999 - 20:36:02 CEST