01-15-2009
load a data from text file into a oracle table
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Discussion started by: handynas
5 Replies
2. UNIX for Advanced & Expert Users
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
Discussion started by: handynas
4 Replies
3. Programming
I'm having a oracle server and i'm having a table in that.
I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input.
Please explain me the flow of process in that and also... (6 Replies)
Discussion started by: rramprasad
6 Replies
4. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies
5. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies
6. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4 variables... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
7. Shell Programming and Scripting
Hi all,
I need to know how to copy data from a table say ABC to a flat file say XYZ.dat in unix,
Please leave ur comments and the fastest way to do so,
I need to load the table records into flat file.
Regards
Ann (4 Replies)
Discussion started by: Haque123
4 Replies
8. Shell Programming and Scripting
I have a flat file with records like
Header
123 James Williams Finance2000
124 Pete Pete HR 1500
125 PatrickHeather Engg 3000
Footer
The structure is:
Eno:4 characters
Name:8 characters
Surname : 9 characters
Dept:7 characters
Sal:4characters
These are sample... (1 Reply)
Discussion started by: Shivdatta
1 Replies
9. Shell Programming and Scripting
Hi
I need to execute a select statement in a solaris environment with oracle database. The select statement returns number of rows of data.
I need the data to be inserted into a CSV file with proper format. For that we normally use "You have to select all your columns as one big string,... (2 Replies)
Discussion started by: rdhanek
2 Replies
10. Shell Programming and Scripting
Experts.
I have created a oracle table as below.
create table xml_tab
(
File_No number ,
File_content Varchar2(2000),
file_type xmltype
);
Daily we are receiving many XML files as below.
here is our sample xml file.
File1 : (7 Replies)
Discussion started by: vasuvv
7 Replies
LEARN ABOUT DEBIAN
mysql_import_combined_log2
mysql_import_combined_log.pl(1) General Commands Manual mysql_import_combined_log.pl(1)
NAME
mysql_import_combined_log.pl - Imports an Apache combined log into a MySQL database.
SYNOPSIS
mysql_import_combined_log.pl -d <database name> -t <table name> [-h <host name>] [-u <user name>] [-p <password>] [-f <filename>]
OPTIONS
--host|-h <host name>
The host to connect to. Default is localhost.
--database|-d <database name>
The database to use. Required.
--username|-u <username>
The user to connect as.
--password|-p <password>
The user's password.
--table|-t <table name>
The name of the table in which to insert data.
--logfile|-f <file name>
The file to read from. If not given, data is read from stdin.
--help|-?
Print out this help message.
--version
Print out the version of this software.
AUTHOR
Aaron Jenson
Updated to work under Perl 5.6.1 by Edward Rudd
MAN PAGE CREATED BY
Michael A. Toth <lirul.lists@gmail.com> - based on content of script
COMMENTS
This man page was written using xml2man (1) by the same author.
Manuals User mysql_import_combined_log.pl(1)