Basics of Oracle
page 4 of 5
by Abhinash Jena
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 23378/ 121



Synonyms are database objects that point to another object in the system. They are the aliases for tables, views, sequences, etc. These are used to hide certain details from the end user. There are two forms of synonyms – public synonyms which are owned by the public schema and are available to every user in the database and private synonyms which are present in the schema of the user who created it, and that user controls who can access it. The syntax for creating a synonym is:

Listing 3


In the above syntax, ABC is the system name.

Synonyms are used in distributed systems for simplifying the process of accessing certain data. For example, without using synonyms a SELECT statement may be written as:

Listing 4

SELECT * FROM abc.demo;

But by using synonyms the above statement may be simplified as:

Listing 5


As of now, abc.demo is defined as a demo; the user need not worry for knowing the system name.

View Entire Article

User Comments

Title: Basiscs of Oracle   
Name: code Guru
Date: 2008-08-18 3:58:07 PM
thanks 4 making the basics verry simple..otherwise most of the people make the basics so much difficult that beginners quit learning ..
nd yeah um looking 4 more topics
Title: Oracle Basics   
Name: Chiranjeevi
Date: 2008-04-08 7:12:23 AM
Hi Abhinash Jena,

Its a good and wonderful article.
please continue it and add cover more topics.
Title: Data Types   
Name: Steven M. Swafford
Date: 2007-09-01 10:14:23 PM
Is there are reason you did not cover all data types? Also why do you consider those you listed as important? It would have been nice to see TIMESTAMP, BLOB, and etc... There are also data types releveant to PL/SQL: binary_double, binary_float, dec, decimal, and more...
Title: Re:Whats wrong with ASPALLIANCE   
Name: Abhas Roy
Date: 2007-08-31 11:42:42 AM
Hello Mr Tired. First of all if this article was not of your use why did you read it. There are people for whom this knowledge is important. May not be for you. And second I dont think there is anything on internet that are not found on books. Internet and books are just two alternative mediums to gain knowledge.
Thanks Abhinash Jena for providing fundamentals of Oracle in this article.
Title: Re:Whats wrong with ASPALLIANCE   
Name: Haissam Abdul Malak
Date: 2007-08-31 7:20:10 AM
First thank you for this article.
Second Aspalliance provides articles for all users levels if you are an advanced developer, i think there are lots of beginners who need to read such articles.

Best Regards,
Title: What you want is what you get!!   
Name: Abhinash
Date: 2007-08-31 2:16:47 AM
well i tried to write your so called "advanced" article i.e Siebel Analytics but the article was rejected..hope you heard about siebel analytics.
Title: Whats wrong with ASPALLIANCE   
Name: Tired
Date: 2007-08-30 10:54:10 PM
ASP Alliance is losing it as per me. They are publishing useless articles. This information can be found in any book. Whats the use in these kind of articles. Nothing against the author but asp alliance should promote some advanced articles.
Title: Good start   
Name: Debjani
Date: 2007-08-30 1:02:37 AM
Good article for beginners
Title: Mr   
Name: Tarun Kanti Nanda
Date: 2007-08-28 3:44:20 AM
Thanks Abhi. This is very nice. Previously i was some doubt in view but now it is fine.
Title: Mr.   
Name: Byomokesh Sarangi
Date: 2007-08-28 2:43:37 AM
thanks abhi for such a wonderful article i was reall confused with the tables and views on tables and synonyms.

thanks buddy really appreciate this work,, and now even i can finish up my project
keep up the good work
Title: GR8   
Name: JOHN
Date: 2007-08-28 2:33:08 AM

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2020  |  Page Processed at 2020-01-26 3:42:52 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search