05-28-2014
The thing is I want to udate a row with clob value ,
Sqlldr will only insert a row
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Guys,
I want to insert some values from a log file into a temporary table. the values in the log file looks like this
SV_NAME CC_NAME CP_DISP_RUN_STATE
------- ------------------- -----------------
sble01 ALLTEL WorkMon24Hrs Running
I want to enter the... (2 Replies)
Discussion started by: ragha81
2 Replies
2. Shell Programming and Scripting
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)
Discussion started by: Hara
4 Replies
3. Shell Programming and Scripting
Cant understand the error
#!/bin/bash
temp=""
A=""
D=$(date +"%Y-%m-%d")
H=$(date +"%R")
temp=$(wget -q -O - website | grep -o "Temperature:]**" | grep \-E -o "+")
mysql -D "weather_wise" -e "INSERT INTO weather (Date, Hour, Degrees) VALUES ($D,$H, $temp)";
my data types for... (11 Replies)
Discussion started by: vadharah
11 Replies
4. Shell Programming and Scripting
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)
Discussion started by: ss_ss
1 Replies
5. UNIX for Dummies Questions & Answers
Hi
I have a log file stored in unix file server i need to prepare the clob object of that and store in Oracle Database.
Please suggest me or give me some examples
Thanks
Raj (0 Replies)
Discussion started by: rajeshorpu
0 Replies
6. Shell Programming and Scripting
Hi All,
I have a big file (basically .log file) want to store in oracle database.
Please help me in preparing CLOB object in unix.
The log file is stored in some location on unix file server, prepare clob of that file and store in DB.
Any sample code or link
Thanks
Rajesh (1 Reply)
Discussion started by: rajeshorpu
1 Replies
7. Shell Programming and Scripting
Hi,
Please guide me where i am doing wrong, i am getting
ORA-01756:quoted string not properly terminated when i am trying to insert file into CLOB cloumn of Oracle DB.
Please find below the code where log file variable is myLogFile. Please let me know where i am doing wrong.
... (0 Replies)
Discussion started by: rajeshorpu
0 Replies
8. Programming
Hello Everyone,
I am trying to write a shell script that will read from a file and will call a pl/sql procedure that takes clob as input.
Now as varchar2 has a limit much less than clob so i can't just pass the input as in one variable.(size may be >32K).
This is what i tried. Not posting the... (0 Replies)
Discussion started by: mayukh.banerjee
0 Replies
9. Red Hat
hi every one ,
Wondering if any of you experienced this During "Centos5.6" Boot .. !
1)NOT USING MMCONFIG
2)insmod Error inserting `/lib/raid456.ko` -1 File Exist
Dell PowerEdge T110 with 4sata Controllers with Centos2.6.18-238.9.1.el5xen installed .
/boot on /dev/md0
/ on ... (18 Replies)
Discussion started by: Saed
18 Replies
10. Shell Programming and Scripting
I executed a oracle stored procedure using shell script. How can i get the OUT parameter of the procedure(CLOB) and write it in a file or XML in UNIX environment using shell script? (2 Replies)
Discussion started by: vel4ever
2 Replies
LEARN ABOUT XFREE86
ppmtosixel
ppmtosixel(1) General Commands Manual ppmtosixel(1)
NAME
ppmtosixel - convert a portable pixmap into DEC sixel format
SYNOPSIS
ppmtosixel [-raw] [-margin] [ppmfile]
DESCRIPTION
Reads a portable pixmap as input. Produces sixel commands (SIX) as output. The output is formatted for color printing, e.g. for a DEC
LJ250 color inkjet printer.
If RGB values from the PPM file do not have maxval=100, the RGB values are rescaled. A printer control header and a color assignment table
begin the SIX file. Image data is written in a compressed format by default. A printer control footer ends the image file.
OPTIONS
-raw If specified, each pixel will be explicitly described in the image file. If -raw is not specified, output will default to com-
pressed format in which identical adjacent pixels are replaced by "repeat pixel" commands. A raw file is often an order of magni-
tude larger than a compressed file and prints much slower.
-margin
If -margin is not specified, the image will be start at the left margin (of the window, paper, or whatever). If -margin is speci-
fied, a 1.5 inch left margin will offset the image.
PRINTING
Generally, sixel files must reach the printer unfiltered. Use the lpr -x option or cat filename > /dev/tty0?.
BUGS
Upon rescaling, truncation of the least significant bits of RGB values may result in poor color conversion. If the original PPM maxval was
greater than 100, rescaling also reduces the image depth. While the actual RGB values from the ppm file are more or less retained, the
color palette of the LJ250 may not match the colors on your screen. This seems to be a printer limitation.
SEE ALSO
ppm(5)
AUTHOR
Copyright (C) 1991 by Rick Vinci.
26 April 1991 ppmtosixel(1)