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;

Can you use a commit statement within a database trigger?

4 Answers  

---

Explain the use of control file?

0 Answers  

---

what is the uses of cusor

3 Answers   Perot Systems,

---

What types of joins are used in writing subqueries?

0 Answers  

---

 What are the oracle DML commands possible through an update strategy?

0 Answers   Informatica,

---

What is a oracle database?

0 Answers  

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

0 Answers   Cisco,

---

How to write a left outer join with the where clause in oracle?

0 Answers  

---

What is a deadlock in SQL? How can you prevent it?

1 Answers  

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

0 Answers   Oracle,

---

How can Oracle users be audited?

0 Answers   MCN Solutions,

---

How to convert a date to char in oracle? Give one example.

0 Answers  

---