What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 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,

---

query to find the maximum no persons with same age(age colomn) from emp table

1 Answers  

---

What is Database Trigger ?

1 Answers  

---

Difference between cartesian join and cross join?

0 Answers  

---

State all possible different index configurations a table can possibly have?

0 Answers  

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

How to create a table index?

0 Answers  

---

What is the difference between I and G in Oracle?

0 Answers   MCN Solutions,

---

Explain the use of tables option in exp command.

0 Answers  

---

How to drop a tablespace?

0 Answers  

---