Answer Posted / guest

Synonym is an alternate name for a table or alternate name
for database object.It is used to provide an alternate name
for a table permanently.

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2544

---

How to create a new table in your schema?

1124

---

Explain the use of Merge statement in oracle 11g

1074

---

How to count duplicated values in a column in oracle?

1101

---

Explain a private synonyms?

1095

---

What are the different types of synonyms?

1197

---

How to export your connection information to a file?

1171

---

Please explain compound trigger in oracle?

1107

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1436

---

Differentiate between post-database commit and post-form commit?

1092

---

Is oracle the best database?

1008

---

material view and view disadvantages?

1122

---

How to add a new column to an existing table with a default value?

1055

---

What is an oracle data file?

1153

---

How does the on-delete-cascade statement work?

1158

---