What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

How to run sql commands in sql*plus?

0 Answers  

---

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,

---

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

---

how to find 5th row ?

10 Answers  

---

---

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

What are the different datatypes available in PL/SQL?

0 Answers  

---

Why is sql better than hql?

0 Answers  

---

Why does %isopen return false for an implicit cursor?

0 Answers  

---

Why do we use set serveroutput on?

0 Answers  

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

---