Interested to Buy Any Domain ? << Click Here >> for more details...
What is a public synonym?
- 1 Answers
- 2380 Views
- I also Faced
- E-Mail Answers
Answer / basanti
Synonym is an alias for a object of a database.
It can be created for TABLE or VIEW.
There are two type of synonym PRIVATE and PUBLIC.
public synonym is created by a keyword public.
public synonym is accessible to any schema in the database.
Syntax to create public synonym:
CREATE PUBLIC SYNONYM synonym_name FOR object_name;
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Library Cache in Oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
Explain the family trees and connection by clause
What is a Tablespace?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is the difference between Outer join and Full outer join?
Give syntax for SQL and ORACLE joins.
How do I manually create a database in oracle?
What is flashback in Oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
Oracle General 
