I’d like to create pl/sql array variable to hold an ordered collection of data
thanks.
Question
ayaaliExplorer
How to create array variable in oracle pl/sql ?
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Basically VARRAY is varying array type that is typically used when the number of instances to be stored is small that means if we have one customer and this customer have number of phone numbers in our case if we know exact how many phone number he has so we will use VARRAY otherwise we will go for using nested tables.
You can use VARRAY data type for:
Now We can use VARRAY for a fixed-size array
Or TABLE for an unbounded array like:
for clarification we submit question and it’s answer to help others, please if you have any addition don’t hesitate to share with others here.