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;

What is the function of Redo Log ?

1 Answers  

---

Explain about functional dependency and its relation with table design?

0 Answers  

---

How to drop a tablespace?

0 Answers  

---

What is the data pump import utility?

0 Answers  

---

How to convert character types to numeric types?

0 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

0 Answers  

---

What is oracle update statement with inner join ?

0 Answers  

---

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

---

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 Answers  

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

How to use select statement to count the number of rows in oracle?

0 Answers  

---

What are the tools for Oracle ?

0 Answers   Infosys,

---