Answer / Jagdeep Kumar

To use attributes of the implicit cursor in Oracle, you can access them directly like variables. Here is an example:n```sqlnDECLAREn your_cursor SYS_REFCURSOR;nBEGINn OPEN your_cursor FOR SELECT column1 FROM your_table;n FETCH NEXT FROM your_cursor INTO variable1;nEND;n```

How many types of segments in Oracle?

1 Answers   MCN Solutions,

---

What is the purpose of a cluster?

1 Answers  

---

can u call user defined functions in select statements

2 Answers  

---

Explain the concept of the DUAL table.

2 Answers  

---

What privilege is needed for a user to delete rows from tables in another schema?

1 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1 Answers  

---

Can we call a trigger inside a function and function inside a trigger? Give example.

1 Answers   Metric Stream,

---

What is the data type of dual table?

1 Answers  

---

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

1 Answers  

---

What is max rowid in oracle?

1 Answers  

---

How to Select second Maximum salary in a Table ?

13 Answers   Oracle,

---

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  

---