Geeks Talk

Prepare for your Next Interview




Extend function of Varrays

This is a discussion on Extend function of Varrays within the Oracle forums, part of the Databases category; HI All, I have some doubt regading the extend function of Varrays. I am little bit confused. Can someone explain that in detail. What my doubt is, suppose i declare ...


Go Back   Geeks Talk > Databases > Oracle

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 05-05-2007
Junior Member
 
Join Date: Apr 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Jyothi.g is on a distinguished road
Extend function of Varrays

HI All,

I have some doubt regading the extend function of Varrays. I am little bit confused. Can someone explain that in detail. What my doubt is, suppose i declare a varray of size say 100, can I extend that varray beyond 100 or not? What is the actual purpose of this function?

Can someone please explain.
Thanks in advance.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 05-07-2007
Junior Member
 
Join Date: May 2007
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
rishamjeet is on a distinguished road
Re: Extend function of Varrays

Hi Jyoti,
it is not like hte way that u think. we need to initalize the varray before using it using a constructor. suppose ur initial lenght of varray is 100 n while initializing it u have given 10 elements. so logically u can use EXTEND function to use declare the elements beyond 10 and not beyond 100.

Regards
Risham
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Query about a Function Remasri PHP 3 03-17-2007 03:10 AM
pl/sql function gujjar Oracle Certification 3 02-22-2007 10:47 AM
TSL Function sutnarcha WinRunner 1 12-20-2006 05:40 AM
How can i call that function? JobHelper Java 1 12-06-2006 03:16 AM
Function in PHP sripri PHP 1 07-20-2006 12:13 PM


All times are GMT -4. The time now is 01:29 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved