i want to run update query for oracle which is in up.sql taking values from a.csv.
I have implemented shell script to do it.
up.sql contains
The code to update is as below
Since there are a large no files..i dont want to run the sqlplus command that much of time...
Is there any way to use a.csv to update the table...I tried sqlldr but it is working only for inser not for update.
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
ocr4gamera
OCR4GAMERA(1)OCR4GAMERA(1)NAME
ocr4gamera - OCR system using the Gamera framework
USAGE
ocr4gamera -x <traindata> [options] <imagefile>
OPTIONS -v <int>, --verbosity=<int>
Set verbosity level to <int>. Possible values are 0 (default): silent operation; 1: information on progress; >2: segmentation info
is written to PNG files with prefix debug_.
-h, --help
Display help and exit.
-d, --deskew
Do a skew correction (recommended).
-f, --filter
Filter out very large (images) and very small components (noise).
-a, --automatic-group
Autogroup glyphs with classifier.
-x <file>, --xmlfile=<file>
Read training data from <file>.
-o <xml>, --output=<xml>
Write recognized text to file <xml> (otherwise it is written to stdout).
-c <csv>, --extra_chars_csvfile=<csv>
Read additional class name conversions from file <csv>. <csv> must contain one conversion per line.
-R <rules>, --heuristic_rules=<rules>
Apply heuristic rules <rules> for disambiguation of some chars. <rules> can be roman (default) or none (for no rules).
-D, --dictionary-correction
Correct words using a dictionary (requires aspell or ispell).
-L <lang>, --dictionary-language=<lang>
Use <lang> as language for aspell (when option -D is set).
-e <int>, --edit-distance=<int>
Correct words only when edit distance not more than <int>.
OCR4GAMERA(1)