Answer / jyothsna

cursor variables are subject to the following
restrictions:You cannot declare cursor variables in a
package spec. For example, the following declaration is not
allowed:CREATE PACKAGE emp_stuff AS TYPE EmpCurTyp IS REF
CURSOR RETURN emp%ROWTYPE; emp_cv EmpCurTyp; -- not
allowedEND emp_stuff;You cannot pass cursor variables to a
procedure that is called through a database link.If you
pass a host cursor variable to PL/SQL, you cannot fetch
from it on the server side unless you also open it there on
the same server call.You cannot use comparison operators to
test cursor variables for equality, inequality, or
nullity.You cannot assign nulls to a cursor
variable.Database columns cannot store the values of cursor
variables. There is no equivalent type to use in a CREATE
TABLE statement.You cannot store cursor variables in an
associative array, nested table, or varray.Cursors and
cursor variables are not interoperable; that is, you cannot
use one where the other is expected. For example, you
cannot reference a cursor variable in a cursor FORloop

Answer / swapna

You cannot store cursor variables in an associative array,
nested table, or varray.Cursors and cursor variables are
not interoperable;

that is, you cannot use one where the other is expected.
For example, you cannot reference a cursor variable in a
cursor FOR loop.

how to select unique records from a table? : Sql dba

0 Answers  

---

What are the types of queries in sql?

0 Answers  

---

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

How to call shell script from pl sql procedure?

0 Answers  

---

Can you rollback after commit?

0 Answers  

---

Explian rowid, rownum?

0 Answers  

---

Which nosql database is best?

0 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

Is sqlite thread safe?

0 Answers  

---

What is user define exception and example

1 Answers   HP, KP,

---

What is user in sql?

0 Answers  

---