Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Alter View statements in PL/SQL?

Re: Alter View statements in PL/SQL?

From: res0nlrn <res0nlrn_at_verizon.net>
Date: Mon, 30 Sep 2002 21:55:25 GMT
Message-ID: <20020930.145524.1012502954.2682@verizon.net> 





try dynamic sql



sql_stmt := 'alter view prod.v_view_name1 compile';
execute immediate sql_stmt;



You can make a for loop also on view name from dba_views / user_views.
Received on Mon Sep 30 2002 - 16:55:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US