Answer Posted / cb

What is exact answer??

What is query image?

925

---

How to connect to oracle using service name instead of sid?

964

---

What is the difference between pre-select and pre-query?

1125

---

State any two functions of oracle?

984

---

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?

2398

---

What happens to the indexes if a table is recovered?

944

---

What happens if recursive calls get out of control?

1000

---

How to compare dates in oracle sql?

1043

---

What is snapshot is too old? Give and example for better understand.

1546

---

How to define a procedure inside another procedure?

965

---

What is rich query?

929

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2075

---

What is the difference between $oracle_base and $oracle_home?

1029

---

How to create a new table in oracle?

1067

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2095

---