what is pl/sql table and pl/sql records? what is the use of
that?
Answer Posted / srinivasa reddy k
Pl/Sql table comes under collections.
Pl/Sql table ,Pl/Sql datatypes comes under User Defined
Datatypes.
Pl/Sql table is used for storing and processing the values
in a Pl/Sql procedures.
Pl/Sql records are used to hold the row structed values
we can use pl/ql records with pl/sql tables to form a table
like structed to hold the values in a Pl/Sql program.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What is instead of trigger in where we will use?
Tell me where we find the status of order information?
How to create a purchase order without a requisition?
Explain oracle apps architecture.
What is oracle soa suite?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Can we create tables in apps schema?
What is sca and how is it useful?
What is the concept of soa governance?
Can u give the Documentation of Custom.pll in oracle apps
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
How many schemas we have? how many you have used?
What are do's and dont's of Interface?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?