Clueless Newbie Question about Synonyms
11/02/2018 11:47
What's the difference between a synonym and a view? The stuff I've read from a Google search suggests that a synonym is another name for a table or view, but how can that be if you can create a synonym as an object? Many thanks.

Keith.

Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

Answer score: 5
11/02/2018 11:47 - FOR a view or a table. A Synonym is FOR an object.

Commonly like the synonym EMP for (table or view) SCOTT.EMP.


Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

Answer score: 5
11/02/2018 11:47 - Keith <keith.wilby@baeAWAYWITHITsystems.com> wrote in messagenews:425503e0$1_1@glkas0286.greenlnk.net...

or So what if it is an object? Don't worry about it. A view is stored SQL. Asynonym is another name for something.


Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

Answer score: 5
11/02/2018 11:47 - Alan <not.me@uhuh.rcn.com> wrote in message news:0685e.452$Zn3.67@trnddc02...

Are you saying that a synonym can be a view or a table? If I create a synonym based upon a view then that's just more stored SQL?

Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below