Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help on view constraint and plsql scripts
The alter view comand is used only to recompile a view. In order to
modify a view structure you must drop and create it again.
deb wrote:
>
> 1) I tried to drop the constraint from a view with the check option but
> could
> not do so...
> The command that I used was :
>
> Alter view s_r
> drop constraint c_ck;
>
> 2) The other thing that I wanted to know was how do we create scripts..do
> we create them in sqlplus editor especially the ones containing 'ACCEPT' and
> 'PROMPT'commands ...cause when we do not use the editor the accept and
> prompt commands immediately ask us for the value and do not let us complete
> the script...I hope I am clear...
>
> thanks/
--
+-------------------------------+----------------------------------+ | Dyrson Rodrigues Alves Junior | Casa de Software | | Analista de Sistemas | Oracle Approved Education Center | | mailto:dyrson@casasoft.com.br | http://www.casasoft.com.br | +-------------------------------+----------------------------------+Received on Thu May 13 1999 - 06:33:28 CDT