what is main def between plsql/table and array?
Answer / sudipta santra
In array we can not make index upon that but in PL/SQL Table
we can set the index upon that.
Rest of the features are more or less not so much strong
difference.
| Is This Answer Correct ? | 0 Yes | 0 No |
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
What is a Garbage Collection? and what is full recursive Garbage collection?
what is Single Byte Overhead...?
What are the components of logical database structure in oracle database?
How does oracle handle read consistency?
How to retrieve the count of updated rows?
What are the database administrators utilities available?
does Oracle has only one table space?
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
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What is the CAP theorem?
How to specify default values in insert statement using oracle?