Re: Is is possible to do this in Oracle?

1. View: You cannot do it directly, however, you may try to use some functions (e.g. SUBSTR for VARCHAR2). For NUMBER columns use TRUNC or combination TO_NUMBER(TO_CHAR(...)).
2. Hiding: there is a WRAP utility (on HP-UX it is $ORACLE_HOME/bin/wrap). It is described in (7.3 Docs) PL/SQL User's Guide and Reference, Appendix D. It does not work for triggers, so you'll have to create a procedure which you trigger will call.

More questions? Email to vafanassiev_at_westpac.com.au

Jimmy wrote in message <37B3C8CE.4F7940B8_at_comp.polyu.edu.hk>...
>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 Fri Aug 13 1999 - 06:17:57 CDT