Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

queries regarding using VARRAY type

Status
Not open for further replies.
sourabhjha

sourabhjha

Programmer
Jan 13, 2002
121
IN
I have some queries regarding VARRAY datatype in oracle.First query is that is it possible to create a varray type data with dynamic length.
And the second is that what is the syntax for inserting records into that varray type field.Say i have a table SMAPLE with a column named MYCOL which is of type of MYDATATYPE(VARRAY type which i had created earlier).Assuming MYDATATYPE is varray of datatype NUMBER then what will be the syntax for inserting records into the table SAMPLE.
 
Status
Not open for further replies.

Similar threads

Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
194
Olutee360
Olutee360
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
934
EM1107
EM1107
ClowneUser
  • Locked
  • Question
Using sysdate as a paramter
Replies
1
Views
155
Beilstwh
Beilstwh
rk68
  • Locked
  • Question
data import using SQLLDR
Replies
5
Views
147
rk68
rk68
rk68
  • Locked
  • Question
Using dbms_connection_pool
Replies
0
Views
93
rk68
rk68

Part and Inventory Search

Sponsor

Back
Top