Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
- 1 Answers
- 4035 Views
- I also Faced
- E-Mail Answers
Answer / nishi
No, a cursor variable points a row which cannot be stored in a two-dimensional PL/SQL table.
| Is This Answer Correct ? | 2 Yes | 1 No |
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
What is not equal to in oracle?
How to loop through data rows in the implicit cursor?
Explain the use of constraints option in exp command.
How to retrieve values from data fields in record variables?
Can a formula column be obtained through a select statement ?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
What is sequence?
How to rename an index in oracle?
What is blob datatype?
Difference between cartesian join and cross join?
How to get execution path reports on query statements?
Oracle General 
