Is is possible to do this in Oracle?

From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Fri, 13 Aug 1999 00:30:05 -0700
Message-ID: <37B3C97D.56D6EFDC@comp.polyu.edu.hk>

Hello all,

I wonder whether the below requirements can be implemented in Oracle 7.3.3. (or higher)

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.
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 Fri Aug 13 1999 - 02:30:05 CDT