what is the difference between restoring and recovering?

0 Answers   MCN Solutions,

---

Do View contain Data ?

10 Answers  

---

How to write a left outer join with the where clause in oracle?

0 Answers  

---

Explain the use of constraints option in exp command.

0 Answers  

---

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?

0 Answers   Sierra Atlantica,

---

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 Answers  

---

How to best split csv strings in oracle 9i?

0 Answers  

---

What is SYSTEM tablespace and When is it Created?

2 Answers  

---

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 Answers  

---

What are the composite date types in oracle?

6 Answers   HCL,

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

0 Answers  

---

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---