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)
hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname'
for example
... (6 Replies)
I need to compare the 2 mysql database tables. there are around 50 tables in each DB.
my idea is
in DB1
extract result select * from table1; to alog file1
in DB2
extract result select * from table1; to alog file2
now compare log file 1 file 2
pls help me out ...
thanks in advance (5 Replies)
Hi,
I've several files with two collumns, where first collumn can be used as index.
filename1
and filename2
how to create a file
I should start with cat all files and extract first collumn to create an index? (4 Replies)
I basically need to do what the title says.
I have my text file.
I'm still pretty new at this.
At the moment I know that:
1. wc -l file.txt
To get the number of lines.
2. ls -lh file.txt
To get the file size.
But I need to divide both numbers. Then I need to save the output in a... (7 Replies)
Hi Team,
I need to create a control file with a pre-defined structure for a given table name. The table is in teradata.
Ex: Table Name: TBL1
Table structure:
create multiset table tbl1, no fallback,
no before journal,
no after journal,
checksum = default,
default mergeblockratio... (7 Replies)
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
table_nme column_nme
DEPT ... (2 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)
Hello,
In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data.
file -i filename.csv - gives... (2 Replies)
Discussion started by: Dharmatheja
2 Replies
LEARN ABOUT DEBIAN
jpegexiforient
JPEGEXIFORIENT(1) User Commands JPEGEXIFORIENT(1)NAME
jpegexiforient - reads or writes the Exif Orientation Tag
SYNOPSIS
jpegexiforient [switches] jpegfile
DESCRIPTION
This is a utility program to get and set the Exif Orientation Tag. It can be used together with jpegtran in scripts for automatic orienta-
tion correction of digital camera pictures.
The Exif orientation value gives the orientation of the camera relative to the scene when the image was captured. The relation of the '0th
row' and '0th column' to visual position is shown as below.
Value | 0th Row | 0th Column
------+-------------+-----------
1 | top | left side
2 | top | right side
3 | bottom | right side
4 | bottom | left side
5 | left side | top
6 | right side | top
7 | right side | bottom
8 | left side | bottom
For convenience, here is what the letter F would look like if it were tagged correctly and displayed by a program that ignores the orienta-
tion tag:
1 2 3 4
888888 888888 88 88
88 88 88 88
8888 8888 8888 8888
88 88 88 88
88 88 888888 888888
5 6 7 8
8888888888 88 88 8888888888
88 88 88 88 88 88 88 88
88 8888888888 8888888888 88
jpegexiforient output the Exif Orientation Tag in a JPEG Exif file. With the options -1 .. -8, it can also be used to set the tag.
OPTIONS
--help display this help and exit
--version
output version information and exit
-n Do not output the trailing newline
-1 .. -8
Set orientation value 1 .. 8
AUTHOR
Guido Vollbeding <guido@jpegclub.org>
SEE ALSO jpegtran(1), exifautotran(1)jpegexiforient February 2005 JPEGEXIFORIENT(1)