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

Home -> Community -> Usenet -> c.d.o.server -> 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