12-09-2010
Retrieving values from the oracle table
Hi,
How to retrieve two different date values(min & max) from the oracle table and assign to two different variables in the shell script to process further.
With Regards
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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)
Discussion started by: handynas
5 Replies
2. UNIX for Advanced & Expert Users
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)
Discussion started by: handynas
4 Replies
3. Shell Programming and Scripting
Hello folks,
Please find the below code:(sample5.sh -> filename)
echo "Selecting dat afrom Cause code"
echo "set appinfo Causecode
$preamble
set serveroutput on size 10000
select * from RMI003_CAUSE_CODE /" | sqlplus -S $username@$hoststring/$password >> test2.dat
When i tried executing... (5 Replies)
Discussion started by: sundar_ravi4
5 Replies
4. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
5. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
6. Shell Programming and Scripting
I have an input file like
RMS_RPT_PERIOD_DIM,Table,NYTD_SLS_DM,GPS_SLS_DM1,NYTD_SLS_GPS_INT,RMS_DM,byreddys,7/31/2009,byreddys,7/31/2009,Y,//depot/eqr/salesgps/trunk/src/db/table,TBL_GPS_CONTACT_DETAILS.sql,1.1,,lakshmi,sql,y... (2 Replies)
Discussion started by: sailaja_80
2 Replies
7. Shell Programming and Scripting
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies
8. Shell Programming and Scripting
Hi,
I am new to Unix/ksh script and will like to check how do I retrieve just the count of '258' in the last line in a text file ?
There will be this "TRL" appended with number of count at the last line in a text file .
TRL0000000258
var=`grep 'TRL' $HOME/folder/test.txt | wc -l`
... (12 Replies)
Discussion started by: snowfrost
12 Replies
9. UNIX and Linux Applications
hi,
i need to copy one table with data into another table,
right now am using
create table table1 as select * from table2
i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies
LEARN ABOUT DEBIAN
pfsview
pfsview(1) General Commands Manual pfsview(1)
NAME
pfsview - Viewer for high-dynamic range images in pfs format
SYNOPSIS
pfsview [--window_min <log_lum>] [--window_max <log_lum>]
DESCRIPTION
pfsview is a QT application for viewing high-dynamic range images. It expects pfs stream on the standard input and displays the frames in
that stream one by one.
pfsv script can be more convienent to use if hdr images are to be displayed without any prior processing.
DYNAMIC RANGE WINDOW
To show high-dynamic range data on a low-dynamic range monitor, pfsview uses concept of a dynamic range window. The dynamic range window is
the highest and lowest value that should be mapped to black and white pixel. Values above or below the window are clipped (see clipping
methods below). The dynamic range window is displayed in pfsview as a blue area on the dynamic range scale (second toolbox from the top).
The window can be moved, shrunk and expended using a mouse or a keyboard.
CLIPPING METHODS
Currently, two clipping methods are available (see View menu):
Simple clipping
The values above and below the dynamic range window are displayed as black or white.
Color-coded clipping
The values above the dynamic range window are displayed as yellow and below the window as green. This is helpful to see which parts
of the image do not fit into the selected dynamic range.
Keep brightness and hue
This method tries to preserve brightness and hue while sacrificing color saturation when the colors exceed the RGB color gamut. Col-
ors are desaturated in the RGB color space towards the neutral color (D65) of the corresponding luminance.
MAPPING METHODS
High-dynamic range data are usually better visualized using non-linear scale, for example a logarithmic or a power function. pfsview offers
several such scales, shown in View menu. Gray-scale values for each mapping method are computed by the formulas:
LINEAR: y = (x-min)/(max-min)
GAMMA: y = [ (x-min)/(max-min) ]^gamma
LOGARITHMIC: y = (log10(x)-log10(min))/(log10(max)-log10(min))
where y is the gray-scale value after mapping, x is an input HDR value, min and max are lower and upper bounds of the dynamic range window.
OPTIONS
--window_min <log_lum>
Lower bound of the values that should be displayed or minimum value of the dynamic range window. The value should be given in log_10
units, for example -1 if the lower bound should be 0.1 (10^-1).
--window_max <log_lum>
Upper bound of the values that should be displayed or minimum value of the dynamic range window. The value should be given in log_10
units, for example -1 if the upper bound should be 0.1 (10^-1).
EXAMPLES
pfsin memorial.hdr | pfsview
See the memorial image.
pfsv memorial.hdr
The same as above, but using the utility script 'pv'.
SEE ALSO
pfsv(1) pfsin(1)
BUGS
Zomming in may sometimes show artifacts.
Please report bugs and comments to Rafal Mantiuk <mantiuk@mpi-sb.mpg.de>.
pfsview(1)