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 the diffeenes between oracle 9i,oracle 10g
What is the Tune Query
What is the data pump import utility?
how to produce numbers from 1 to 10 using dual table
Explain about your project and its relation to the current job position you are applying to?
Define oracle database
How to pass a cursor variable to a procedure?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are the differences between interval year to month and interval day to second?
What is Water Mark in Oracle?
query optmization techniques and quwry analyser+projects+ppts
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