what is an associative array with example?
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 |
what are the different functions in sorting an array? : Sql dba
What is the difference between functions, procedures, and packages in pl/sql?
what is data integrity
what is cursor procedure
Why do we use sql constraints?
What is the use of partition by in sql?
How delete all data from table in sql?
How can I change database name in sql?
What is dynamic SQl and how you will create and execute dynamic sql?
How many sql are there?
define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.
How does sql store data?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)