You could create a Oracle 'external table' linked to your file(a.csv) that contains the data to update with and perform all the updates in one update script or statement, example of external table:
You can then use a 'update' sql statement or a cursor in a sql script to perform your updates.
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)
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)
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Hi,
I 'd like to update the below highlighted values in a sample file based on the following table:
8283879A25918000000000005400000000000065629TTF3
8683884F40273000000000003900000000000047399TTF3
8883884FG0063000000000002600000000000031599TTF3... (7 Replies)
Hi
I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file.
It is an Oracle database
Thank you (1 Reply)
Hi there,
i have a file like that in attachment (PLEVA3_280711_SAP.txt), i would extract some basic information from it and report in a new file or table like this:
i try to use bash and i extract the single object in this way (see attach scriptino.sh), but i receive a strange... (5 Replies)
Hi,
I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below...
if (start_new_rec=="true"){
exclude_user="false";
user=toupper($6);
match(user, "XXXXX.");
if (RSTART ==2 ) {
... (9 Replies)
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Gents,
Can you please help me to create a pivot table from a csv file. ( I have zip the csv file)
Using the file attached, columns 1,28 and 21 i would like to get something like this output
JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total... (4 Replies)
Discussion started by: jiam912
4 Replies
LEARN ABOUT DEBIAN
biomaj
biomaj(1) USER COMMANDS biomaj(1)NAME
biomaj - downloads and transform remote biological data banks
SYNOPSIS
biomaj [-h]
DESCRIPTION
BioMAJ (BIOlogie Mise A Jour) is a workflow engine dedicated
to data synchronization and processing.The Software automates
the update cycle and the supervision of the locally mirrored
databank repository. User must have roots rights to run biomaj.
OPTIONS -h display the list of commands.
INSTALL
At installation, BioMAJ requires a database to run (MySQL), installer should first create a database (biomaj_log) and a database user (the
one used at installation setup).
The database configuration for biomaj can be set or modified in /etc/biomaj/db_properties/global.properties.
In the install fails due to a SQL error, the install script must be manually run to create/upgrade the database:
perl /usr/share/biomaj/sql/migration/update.pl
The script will create/upgrade the database and update the configuration files.
ADMIN USER
A default admin user (admin) is created by the scripts. If using the biomaj-watcher, the default password (admin) MUST be changed immedi-
atly via the watcher interface.
If only biomaj core is used, password is useless.
.PP
UPGRADE
In the case of a package upgrade, if properly configured, the migration scripts will be ran automatically at install.
It is possible to run manually the script:
.B See perl /usr/share/biomaj/sql/migration/update.pl -h
for usage.
DATA BANKS
By default, biomaj is configured (data.dir in global.properties) to write banks to /var/lib/biomaj.
EXAMPLES
Update a bank:
biomaj --update genbank
Show console
biomaj --update genbank --console
Show status:
biomaj --status
EXIT STATUS
biomaj returns a zero exist status if it succeeds, it does not represent the bank update status.
AUTHOR
Olivier Sallou (olivier.sallou (at) irisa.fr) Romaric Sabas (romaric.sabas (at) irisa.fr)
version 1.2.0 September 14, 2011 biomaj(1)