Home » SQL & PL/SQL » SQL & PL/SQL » Synonyms (10.2.0.4.0 ,windows)
Synonyms [message #425532] Fri, 09 October 2009 08:27 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi ,

Can somebody explain about synonym and its purpose with some examples
else provide some good link for it?


Thanks
Re: Synonyms [message #425535 is a reply to message #425532] Fri, 09 October 2009 08:34 Go to previous messageGo to next message
joy_division
Messages: 4616
Registered: February 2005
Location: East Coast USA
Senior Member
You have been here over three years and you do not know the answer or how to search for it?

http://google.com

or

http://tahiti.oracle.com

would be good starts.
Re: Synonyms [message #425536 is a reply to message #425532] Fri, 09 October 2009 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://dictionary.reference.com/browse/synonym
http://www.thefreedictionary.com/synonym
http://www.answers.com/topic/synonym

Regards
Michel
Re: Synonyms [message #425537 is a reply to message #425536] Fri, 09 October 2009 08:47 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Not good enough
Re: Synonyms [message #425539 is a reply to message #425537] Fri, 09 October 2009 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
balaji14 wrote on Fri, 09 October 2009 15:47
Not good enough


Laughing


Re: Synonyms [message #425542 is a reply to message #425539] Fri, 09 October 2009 09:24 Go to previous messageGo to next message
ThomasG
Messages: 3185
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
If those links are "Not good Enough", maybe you should try The Manga Guide to Databases first.
Re: Synonyms [message #425848 is a reply to message #425532] Mon, 12 October 2009 08:27 Go to previous messageGo to next message
Kevin Meade
Messages: 2098
Registered: December 1999
Location: Connecticut USA
Senior Member
Synonyms have at least three distinct purposes:

1) to hide ownership
2) to hide location
3) to hide identity

Notice in all cases the emphasis on HIDING.

Hiding knowledge provides protection from change. If my program references a synonym which points to an underlying table then I can do several things:

I can change the owner of my underlying table by for example, creating it in a different schema and as long as I provide the right privileges and correct my synonym to point to the newly owner-ed table, my program still works.

I can change the location of my table by for example, moving it to a different database. As long as I make sure the needed database link and privileges are in place, and the synonym is corrected to point to the now remote table, my program still works.

I can change the identity of my underlyting table by for example renaming it, or better yet by swapping my table out and a different table in thus giving me different data, and as long as the new table presents at least those columns required by my program, and all the necessary privileges are in place and I correct my synonym to use either the new table name, or reference the new object I want to use, my program still works.

So the idea of synonyms is that they hide a certain kind knowledge from those who reference a synonym and thus protect the users of a synonym from certain kinds of changes done to the hidden object the synonym points to.

Think of it like this: A synonym changes what used to be data and application work into data only work. 9 times out of 10, turning a problem that requires application work into a problem that is a database only exercise is a good thing.

But just to re-iterate, synonyms are about hiding.

Is this more like what you were looking for?

Kevin

[Updated on: Mon, 12 October 2009 08:31]

Report message to a moderator

Re: Synonyms [message #425892 is a reply to message #425848] Mon, 12 October 2009 23:36 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Like "balaji14" is Synonym for you in the forum, hope this suffice

Cool
Re: Synonyms [message #426047 is a reply to message #425848] Wed, 14 October 2009 00:08 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member



Thanks kevin.

Well understood.
Re: Synonyms [message #426048 is a reply to message #425539] Wed, 14 October 2009 00:17 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Michel

You need to consult with doctor.Being old, i think probably your eyes would had went wrong.
Are you using specks,if not suggest you to use a specks with -1 contact lens
which would do something good.

When Kevin could understand my question and respond to it , then why you cannot understand
and posting some rubbish link instead.

I really appreciate Kevin's response and his gentlness.

Awaiting your (Michel) response on this.
Let me see if i could write something more based on your response.




Re: Synonyms [message #426054 is a reply to message #426048] Wed, 14 October 2009 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
./fa/1604/0/
Re: Synonyms [message #426076 is a reply to message #425532] Wed, 14 October 2009 01:06 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member

To Balaji /Mohan,

We understand your question very well .. The reason why Michel had responded like this is . You people are misusing this forums if you ask what is ORACLE .. we can answer this question to a layman and more every you people being oracle professionals asking what is a synonym this is very edostic question i guess . Look into the documentation first read it and try to understand .

Do never post questions like this no one will have patience to answer and don't waste our time too.

Try to utilize this forms and learn most of it .

Michel,

You have answered well in one way . ha ha ha .

Regards

Bala
Re: Synonyms [message #426078 is a reply to message #426048] Wed, 14 October 2009 01:08 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
@Mohan10g: Read this...
Re: Synonyms [message #426213 is a reply to message #426076] Wed, 14 October 2009 07:20 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member
[unwarranted attack removed by moderator]
Re: Synonyms [message #426217 is a reply to message #426213] Wed, 14 October 2009 07:32 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


bala,

I never asked you any questions and i dont expect your rubbish answer.

if you say its a simple question , dont answer and bloody dont enter into my thread hereafter.

On top of it you deserve the beating for your anger and
scribbling something on my thread.
Re: Synonyms [message #426219 is a reply to message #426217] Wed, 14 October 2009 07:38 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Right, I think this has gone far enough.

@Mohan10g - this isn't your thread, it is a thread on a public forum, to which anyone may contribute. Furthermore, it isn't even a thread that you started. Please refrain from personal attacks and insults in the future.

@balakrishnay - the same applies to you, to a lesser degree. Your last post crossed the line from witty to abusive.

@michel - DNFTT? Good smiley though.
Re: Synonyms [message #426220 is a reply to message #426217] Wed, 14 October 2009 07:39 Go to previous messageGo to next message
ThomasG
Messages: 3185
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well.

You ask "What is Blue?", and you get upset when someone answers "It's a color.", citing the answer "The sky is." as a good answer.

When the question is not clear, the answers can't be either.



Re: Synonyms [message #426226 is a reply to message #426220] Wed, 14 October 2009 08:17 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

People may ask simple questions like what had i asked.But do not assume that
he doesnt know competely of what he is looking for .It can be something like this also.
He may be looking for some good links with some examples where he could not
find it in google or in some links.Its not like when simple questions are asked
and you reply in a wrong way.If you dont wanna answer .. its simple... leave
and look for some other thread where you feel the questions are up to your level instead.



Re: Synonyms [message #426227 is a reply to message #426226] Wed, 14 October 2009 08:30 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Enough!!!!

Let's just all take a deep breath, calm down, and move on.

Mods - if anyone wants to add a comment, could you lock the thread again afterwards.
Previous Topic: choose attribute from cursor dynamically (merged)
Next Topic: Committing Transaction without handling exception in Procedure
Goto Forum:
  


Current Time: Wed Sep 28 05:42:33 CDT 2016

Total time taken to generate the page: 0.24107 seconds