Home » SQL & PL/SQL » SQL & PL/SQL » Querying array element
Querying array element [message #9548] Wed, 19 November 2003 01:34 Go to next message
Jeffrey
Messages: 30
Registered: January 2003
Member
How do i query out the items in a varray of number type? The situation is like i am writting a trigger to get the first 4 values of the varray and insert the values into 4 columns of a table. Could anyone help? Thanks in advance

Report message to a moderator

Re: Querying array element [message #9620 is a reply to message #9548] Mon, 24 November 2003 09:20 Go to previous message
Adrian Billington
Messages: 139
Registered: December 2002
Senior Member
Search the Records and Collections manual in the online Oracle docs at OTN - you are looking for the TABLE expression ( or TABLE ( CAST ()) if you are on 8i ).

Regards
Adrian

Report message to a moderator

Previous Topic: Long-to-Varchar2 Migration
Next Topic: rollup and cube
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 09:13:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.