473,386 Members | 1,763 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Utl_file

how to retrive data from the csv file and update into the table by making use of utl_file i need to get the data from a csv file and i should keep the records in pl/sql table
Jul 25 '07 #1
2 1191
pbmods
5,821 Expert 4TB
Heya, krissathish. Welcome to TSDN!

I'm going to go ahead and move this thread to the Oracle forum, where one of our resident Experts will be more likely to be able to help you out.
Jul 25 '07 #2
debasisdas
8,127 Expert 4TB
it is recommended to use SQL*LOADER for the purpose instead of the package UTL_FILE.
Jul 26 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Souhail | last post by:
Hi all, I have a problem to put lines with about 3000 characters in my output file using UTL_FILE.put package. I'm using Oracle 7 !! So I can not specify the line size in UTL_FILE.FOPEN...
2
by: Mahesh Hardikar | last post by:
Hi , Oracle EE 8.1.7.0.0 on MS WIndows Advanced Server 2000 SP3 We have a proc which is using utl_file . procedure test_dump_csv as l_rows number; begin
2
by: Candy Robinson | last post by:
I have created a directory for the path name I use for a UTL_FILE.OPEN call, but when I run my call I get error ORA-29280 invalid directory path. What am I failing to do? Thanks for your help, ...
0
by: Peter Weidner | last post by:
Hello friends I have a problem with UTL_File under Oracle 9.2i there - operating system Windows 2000 Professional. Following: I have a procedure in a Package, that reads from an Utl_File and...
1
by: Shilpesh | last post by:
I have an issue in usage of utl_file package. I have setup utl_file_dir parameters correctly on the database side. Basically my goal is to convert csv files into table-structure. I do not know...
1
by: Zima | last post by:
Hi I'm using Oracle 9i My question is how can I use utl_file with network path utl_file_dir like '\\mycomputer\FolderA' I know that in this way this is illegal, and I know that on mycomputer...
2
by: Prasanna | last post by:
Hi All Nice to be in this Forum. I have questions to ask on UTL_FILE :roll: Let me explain the concept 1.When the net is down the user will take the records into on floppy(CLIENT 2.When the net...
1
by: djramesh04 | last post by:
ORA-29280: invalid directory path ORA-06512: at "SYS.UTL_FILE", line 33 ORA-06512: at "SYS.UTL_FILE", line 436 ORA-06512: at "CPLNMGR.PARSE_STRING", line 13 ORA-06512: at line 1 CREATE OR...
16
by: orajit | last post by:
I have created one file c;/temp/test.txt 000|23102007 001|21102007|23102007|GB11223344 001|20102007|22102007|GB11223345 001|19102007|22102007|GB11223346 999|3 The highlighted text are...
0
by: abulafia | last post by:
Originally posted by Julia Sats
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.