Answer Posted / krishna

PARAMETERS <p>[(<length>)] [TYPE <type>|LIKE <obj>]
[DECIMALS <d>]
[DEFAULT <f>]
[MEMORY ID <pid>]
[LOWER CASE]
[OBLIGATORY]
[VALUE CHECK]
[AS CHECKBOX]
[RADIOBUTTON GROUP <radi>]
[NO-DISPLAY]
[MODIF ID <key>].

Explain the use of Merge statement in oracle 11g

985

---

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?

2411

---

How a tablespace is related to data files?

1072

---

what is reindexing?

1620

---

How to retrieve the count of updated rows?

1070

---

What is tns name?

934

---

6. Display the client name and order date for all orders using the traditional method.

2257

---

What is the relation of a user account and a schema?

1071

---

How to invoke the original export import utilities?

998

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2059

---

What is a snapshot in oracle database?

980

---

what is the difference between restoring and recovering?

972

---

How do we get field details of a table?

941

---

How to experiment a data lock in oracle?

1010

---

How to update values on multiple rows in oracle?

989

---