Answer Posted / shriram
It is a type of composite data type in pl sql .. The other
two composite types are nested tables and varrays .. example :
TYPE type_name IS TABLE OF NUMBER INDEX BY VARCHAR2(64);
name type_name;
It is also called as index by tables.
Now "name" can be given any values like :
name('raja'):=100;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to move files from one directory to another in pl sql?
what is offset-fetch filter in tsql? : Transact sql
what is bcp? When does it used? : Sql dba
How to select all records from the table?
how do you control the max size of a heap table? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How many commands are in sql?
Define join and name different types of joins?
What do you know by pl/sql cursors?
What program will open a mdb file?
What is the mutating table and constraining table?
What are the advantages of indexing?
What does cursor do in sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
what is csv? : Sql dba