Home » SQL & PL/SQL » SQL & PL/SQL » Nested Table And UTL_FILE ??
Nested Table And UTL_FILE ?? [message #212980] Tue, 09 January 2007 00:38 Go to next message
Messages: 8
Registered: March 2005
Location: KSA
Junior Member
Hi All

i have some questions about Using UTL_FILE Pkg with Nested Table

IF i have created a TYPE and TABLE like this

(nest_col1   number(3),
 nest_col2   number(2),
 nest_col3   varchar2(3 char),
 nest_col4   number(2));

CREATE TYPE abc_nt AS TABLE OF abc_typ;

(col_1     number(4),
 col_2     varchar2(10 char),
 nest_col  abc_nt)
NESTED TABLE nest_col STORE AS nest_tbl;

the col_1 and col_2 of table abc_tbl will hold values like this

'1234'   'abcdef' one time only 

while the nested column nest_col

will hold vlaues like this one

001    Sat    01    20   
002    Sun    02    21   
003    Mon    03    22       this values in text file
004    Tue    04    23   
005    Wed    05    24   
006    Thu    06    25

Now how to use UTL_FILE Pkg to load the DATA to nested table
from the OS text file?

How to create Procedure , so i can use it every time i want to load more data to same table?


best regards
Re: Nested Table And UTL_FILE ?? [message #212991 is a reply to message #212980] Tue, 09 January 2007 01:13 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
utl_file has NOTHING to do with how you store the data in your database. utl_file reads files, not database structures.
Previous Topic: prime no through pl/sql
Next Topic: ...Verify this Answer...
Goto Forum:

Current Time: Fri Jul 28 14:24:38 CDT 2017

Total time taken to generate the page: 0.15184 seconds