OraFAQ Forum: Server Utilities » Loading data into a VARRAY

Home » RDBMS Server » Server Utilities » Loading data into a VARRAY

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading data into a VARRAY [message #70494]

Fri, 21 June 2002 06:32

Mark Grimshaw
Messages: 73
Registered: June 2002

Member

Hi,

I am having problems with the syntax in a control file for loading data into a table that has a VARRAY column defined in it. The VARRAY column type is defined as a type in the CREATE TABLE statement as follows: -

CREATE TYPE MYVARRAY AS VARRAY(5) OF NUMBER(4)

Can anyone help me ?

Report message to a moderator

Re: Loading data into a VARRAY [message #70495 is a reply to message #70494]

Fri, 21 June 2002 06:52

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you can do something like this. BUT THE SYNTAX IS BASED ON THE FLAT FILE WHICH YOU ARE GOING TO USE

load data
infile *
into table employe
insert
fields terminated by ",'
(name char, phone varray count(constant 5)
	(phone	number)
begin data
cp.haddock,	111,222,333,555,66
whoami,         3, 5, 4, 0, 0
whocares,       0, 5, 4, 4, 5

Report message to a moderator

Previous Topic:	SQLLoading with Comma Delimiter and Quoted Strings
Next Topic:	LogMiner

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 11:22:51 CDT 2024