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: Lamjed <antispam_lamjed_at_lineone.net>
Date: Mon, 23 Feb 2004 14:13:51 +0100
Message-ID: <c1cuam$1aljqj$1@ID-127366.news.uni-berlin.de>


http://www.oracle-base.com/dba/Security/Package_Synonyms.sql

"Lamjed" <antispam_lamjed_at_lineone.net> a écrit dans le message de news: c1crm9$1hdn84$1_at_ID-127366.news.uni-berlin.de...
> yes is't true
>
> uselly i use it for insert ,delete ...
>
>
> "Mark C. Stock" <mcstockX_at_Xenquery .com> a écrit dans le message de news:
> GoKdnfCddo7DQ6TdRVn-iQ_at_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 - 07:13:51 CST

Original text of this message

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