ÇáÓáÇã Úáíßã æÑÍãÉ Çááå æÈÑßÇÊå

ÓäÊäÇæá Ýí åÐÇ ÇáÏÑÓ ßíÝíÉ ÇáÊÚÑÝ Úáì Çá Synonyms æãÇåí æßíÝíÉ ÇäÔÇÆåÇ æÍÐÝåÇ

Çá Synonyms
åæ ÚÈÇÑÉ Úä ÈÏíá áãÍÊæíÇÊ ÞÇÚÏÉ ÇáÈíÇäÇÊ ãËá Çátables, views, sequences, stored procedures, æÛíÑåÇ ãä ÇáãÍÊæíÇÊ æÝÇÆÏÊåÇ Çä ÇáãÓÊÎÏã íÓÊØíÚ Çä íÌáÈ Çæ íÚÏá ãä ÎáÇá ÓßíãÇ ãÎÊáÝÉ

ÞÇÚÏÉ ÇáÇäÔÇÁ

create [or replace]  [public]  synonym [schema .] synonym_name
for [schema .] object_name [@ dblink];

or replace æåÐå äÓÊÎÏãåÇ ÚäÏãÇ äÑíÏ ÇáÊÚÏíá Úáì Synonyms ãæÌæÏ ÇÕáÇ

public äßÊÈåÇ ÇÐÇ ßäÇ äÑíÏ ÌãíÚ ÇáãÓÊÎÏãíä Úáì ÞÇÚÏÉ ÇáÈíÇäÇÊ ÇáÇÓÊÝÇÏÉ ãäåÇ

schema . æåäÇ äßÊÈ ÇÓã ÇáÓßíãÇ ÇáÊí äÑíÏ ÇäÔÇÁ Çá Synonyms ÚáíåÇ

object_name åæ ÇÓã tables, views, sequences, stored procedures ÇáÊí äÑíÏ ÇäÔÇÆåÇ .

æåí ÚÈÇÑÉ Úä

 table                         package 
view                           materialized view 
sequence                  ************************ class schema object 
stored procedure    user-defined object 
function                     synonym

ãËÇá

create public synonym suppliers
for app.suppliers;

ßãÇ äÑì ÇääÇ ÇäÔÃäÇ synonym Úáì ÓßíãÇ app Úáì ÌÏæá suppliers æäæÚå puplic íÚäí íÓÊØíÚ Çí ãÓÊÎÏã ãä ÓßíãÇ ÇÎÑì Çä íÓÊÚáã Úáì åÐå ÇáÓßíãÇ æåäÇ ÊÃÊí ÝÇÆÏÉ Çá synonym ÇäåÇ ÊÓÊØíÚ ãä ÎáÇáåÇ ÇáÞÑÃÉ ãä ÇßËÑ ãä ÓßíãÇ

select * from suppliers;

æááÊÚÏíá Úáì synonym
äßÊÈ ÇáÊÇáí

create or replace public synonym suppliers
for app.suppliers;

ÇãÇ áÍÐÝ Çá synonym

drop [public] synonym [schema .] synonym_name [force];

ÍíË public ÊÓÊÎÏã Ýí ÍÇá ßÇä Çá synonym ÇÕáÇ puplic

force ÊÓÊÎÏã áÍÐÝ Çá synonym ÍÊì áæ ßÇä áåÇ ÊÈÚíÇÊ ÝÅäåÇ íÌÈÑ ÇáÇæÑÇßá Úáì ÍÐÝåÇ æáÇ íÓÊÍÈ ÇÓÊÎÏÇãåÇ áÇäåÇ ÞÏ ÊÚØá Úãá Çá oject

ãËÇá

drop public synonym suppliers