Home » SQL & PL/SQL » SQL & PL/SQL » Definition in Synonym (Oracle 9i,windows)
Definition in Synonym [message #353786] Wed, 15 October 2008 02:02 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


hi all,

A synonym is simply an alias. It requires no storage other than its definition in the data dictionary.

Can anybody tell me, What is "definition" here?

Thanks & Regards,
Balaji.C
Re: Definition in Synonym [message #353789 is a reply to message #353786] Wed, 15 October 2008 02:11 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I think Definition in the data dictionry means the Synonym_name goes in to the data dictionary tables when we create synonym.

i.e. in all_synonyms, user_synonyms, dba_synonyms

Thanks,
Re: Definition in Synonym [message #353791 is a reply to message #353789] Wed, 15 October 2008 02:23 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Then what is "data definition"? Are they both have same meaning?
Re: Definition in Synonym [message #353792 is a reply to message #353791] Wed, 15 October 2008 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2 ways to say the same thing.

Regards
Michel
Re: Definition in Synonym [message #353814 is a reply to message #353792] Wed, 15 October 2008 03:58 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks for your information.
Previous Topic: Login to UNIX from Oracle stored procedure
Next Topic: OPEN Cursor at Package Level
Goto Forum:
  


Current Time: Thu Dec 08 16:29:25 CST 2016

Total time taken to generate the page: 0.18163 seconds