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

This message: [ Message body ]
Next message: RDC: "[announce] Automated Encryption & Security Tool Available based on the DBMS_Obfuscation_Toolkit"
Previous message: ctcgag_at_hotmail.com: "Re: VARCHAR2 and trailing spaces - what's going on!"
In reply to: Cynic: "Alter View statements in PL/SQL?"
Next in thread: Cynic: "Re: Alter View statements in PL/SQL?"
Reply: Cynic: "Re: Alter View statements in PL/SQL?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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