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: creation of synonim in plsql

Re: creation of synonim in plsql

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 23 Feb 2004 06:03:56 -0500
Message-ID: <GoKdnfCddo7DQ6TdRVn-iQ@comcast.com>

"Arti" <iktornek_at_interia.pl> wrote in message news:1b157597.0402230202.3eca30ac_at_posting.google.com...
| Hi.
|
| I've got a problem. I need to create synonim of a view in plsql.
| in sql i can do it with :
|
| create synonym syn_temp_view for temp_view_0luk1;
|
| Is there any function to do that or just syntax is wrong?
|
| Thanks in advance
| Artur

use execute immediate 'sql statement in quotes' for doing non-DML in pl/sql

;-{ mcs Received on Mon Feb 23 2004 - 05:03:56 CST

Original text of this message

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