Answer Posted / saiprasannach89

A user in oracle database is called as schema.Objects created by user is called schema objects.

How to manage transaction isolation level?

1005

---

What is a cursor variable?

1127

---

How to login to the server without an instance?

1162

---

Explain the use of log option in exp command.

1120

---

What are the types of trigger in oracle?

979

---

How to define a cusotmer as a supplier in ORACLE R12

2230

---

What do you mean by merge in oracle?

996

---

How to resolve name conflicts between variables and columns?

1031

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2460

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4520

---

How to define an anonymous block?

1156

---

How to use subqueries with the exists operator in oracle?

1027

---

How to load data through external tables?

1135

---

How to find the duplicate rows count from employees table in oracle?

1090

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2208

---