Answer Posted / orawhiz

Public database link is created for the special user group
PUBLIC.

A public database link can be used when any user in the
associated database specifies a global object name in a SQL
statement or object definition.

How to write a query with an inner join in oracle?

976

---

Can a formula column referred to columns in higher group ?

2458

---

How to delete an existing row from a table in oracle?

1019

---

Who developed oracle & when?

944

---

What is a static data dictionary in oracle?

1025

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2577

---

Can a parameter be passed to a cursor?

1053

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2247

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1950

---

What is the difference between translate and replace in oracle?

1114

---

How to create a new user account in oracle?

955

---

How to start a new transaction in oracle?

1016

---

How do I reset a sequence in oracle?

1052

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

970

---

How to define and use table alias names in oracle?

885

---