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 |
What are transaction isolation levels supported by oracle?
What is blob data type in oracle?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to use values from other tables in update statements using oracle?
Explain coalesce function?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
interview questions with answer for cts
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is tns service name?
Will you be able to store pictures in the database?explain.
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?