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 |
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
What are inner join and outer join?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the oracle built-in data types?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
What is a Data Dictionary ?
what is IDE,DMV in sql server?
can u call user defined functions in select statements
What are the database administrators utilities available?
What to do if the startbd.bat failed to start the xe instance?
What are the most common interview questions on ETL Testing for experience?
What is the difference between translate and replace?