I have 20000 numbers present in a file in each line like
25663,
65465,
74579,
56446,
..
..
I have created a table in db with single number column in it.
create table testhari (no number(9));
I want to insert all these numbers into that table. how can i do it?
can anybody please... (4 Replies)
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)
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)
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)
Hi,
I want to insert data into a table from a flat file, the file is having around 25 columns and some 10,000 records.
The columns values are seperated by a space.
Thanks (1 Reply)
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 (2 Replies)
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)
Hi,
I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script.
The table has two columns - Acct_number (not nullable) and date (timestamp).
I'm not able to write a shell script for that. Can any one help me?
... (3 Replies)
Hi All,
I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far.
1. Table.txt ==> database extract file
2. flat.txt ==> pipe delimited after some manipulation of the original db... (0 Replies)
Discussion started by: express14
0 Replies
LEARN ABOUT POSIX
receive
RECEIVE(1) General Commands Manual RECEIVE(1)NAME
receive - receive files from the sendfile spool
SYNOPSIS
receive [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] [ -ffrom ] file [...]
receive -n [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] file-number [...]
receive [ -s ] [ -l ] [ -L ] [ -R ] [ -ffrom ]
receive -b user[@host] [ -k ] [ -f"from" ] file [...]
receive -b user[@host] [ -k ] [ -f"from" ] -n file-number [...]
receive -b user[@host] [ -k ] -a
DESCRIPTION
receive files from the sendfile spool which has been sent to you.
If there is already a file with the same name you will be prompted for overwriting or renaming.
Allowed wildcards in file names are: * ? [abc] [^abc]
CAUTION: you have to put wildcards and other special characters in '' quotes to hide them for interpretation by your shell.
OPTIONS -n receive file number(s)
-d delete instead of receive
-a receive (or delete or bounce) all files
-r rename before receiving
-k keep files in spool after receiving
-P pipe files to stdout
-S receive only pgp-signed files
-s list files in short format
-l list files
-L list files and look inside archives, too
-R renumber files in spool
-b bounce (forward) files to another recipient
-q quiet mode: no questions asked
-fuser all actions refer only to files from this user
-Z spool
specify an alternate spool directory
EXAMPLES
receive -L
list all files in long format.
receive 'blubb*'
receive all files starting with string "blubb".
receive -daf microsoft.com
delete all files from microsoft.com sites.
receive -b framstag@bofh '*.jpg'
bounce all *.jpg-files to framstag@bofh.
FILES
/var/spool/sendfile The sendfile spool directory.
/var/spool/sendfile/$USER/log
A log of the last transfers.
/etc/sendfile.deny Users which are not allowed to receive files or messages (set by root).
SEE ALSO sendfile(1).
AUTHOR
Ulli Horlacher - framstag@rus.uni-stuttgart.de
3rd Berkeley DistributionRECEIVE(1)