Answer / nishi

OPEN cursor variable FOR SELECT...Statement

CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.

Answer / venkat

open cursor then the cursor points to the starting of the data......close the cursor it clears the data after the execution of a program

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,

---

How to retrieve first and last records from a table?

7 Answers   DELL, QSmart,

---

What is Index Cluster ?

2 Answers  

---

Can we create trigger on view in oracle?

1 Answers  

---

Is primary key = unique key,not null? If yes,please explain IF No,please explain

8 Answers   Genpact,

---

How to install oracle database 10g xe?

0 Answers  

---

Tell me New Feature of Oracle 10g?

5 Answers   Thermotech,

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

3 Answers  

---

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

---

Explain the use of control file?

0 Answers  

---

26. Display the earliest shipping date in the format: DD/MON/YYYY

5 Answers   Wipro,

---

Is java required for oracle client?

0 Answers  

---