What is difference between cursor and ref cursor?

1 Answers  

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is recursive join in sql?

0 Answers  

---

What are the two types of periodical indexes?

0 Answers  

---

How did you export data from database to excel file.

1 Answers   TCS,

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

how can you see all indexes defined for a table? : Sql dba

0 Answers  

---

Is delete faster than truncate?

0 Answers  

---

What are some predefined exceptions in pl/sql?

0 Answers  

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---