how to we delete a row using varray

3 Answers   CTC,

---

How to retrieve 5th highest sal from emp table?

8 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

what are indexes..how many types of index's are there and what are they?

7 Answers   Green Info Solutions, TCS,

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

Difference between NO DATA FOUND and %NOTFOUND?

1 Answers  

---

How to define a cusotmer as a supplier in ORACLE R12

0 Answers   Intelligroup,

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

0 Answers  

---

Write query to fetch second maximum salary from employee table.

4 Answers   Bravura Solutions, HCL,

---

What is coalesce function?

0 Answers  

---

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

What is the purpose of a cluster?

1 Answers  

---