11-06-2012
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
My requirement is :
We are calling an sql statement from a UNIX session, and fetching data into some variables from a table .. now we are unable to access these variables from outside the SQL part. Please let me know how can I achieve this.
Can you please share a code snippet which... (4 Replies)
Discussion started by: venkatesh_sasi
4 Replies
2. Shell Programming and Scripting
Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Discussion started by: Dird
8 Replies
3. Shell Programming and Scripting
Hi,
I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning.
success records to success.log file
failure record to failure.log file.
As of now i am doing like... (1 Reply)
Discussion started by: sailaja_80
1 Replies
4. Shell Programming and Scripting
Hi all,
I have a pipe delimited file - (sample data)
1|1|K|Doe|1234567890|123456789|EXP|99|99|John|Y|Dallas|Texas|Kyle|999
2|1|A|2|01/01/9999|Appl|01/01/9999|vendor|Select||||||
3|1|A|2|01/01/9999|Check|01/01/9999|ksmith|Suggest||||||
4|1|T|Complaint|Mary|01/01/9999|01/01/9999|||||||... (2 Replies)
Discussion started by: sumeet
2 Replies
5. Shell Programming and Scripting
Guys can anyone just tell me whether i can pass a value(from UNIX SCRIPT) as an ARGUMENT in Oracle Query?
e.g.
echo "enter value"
read value
insert into tablename where col=$value /*something like this*/ (1 Reply)
Discussion started by: subodh.thakar
1 Replies
6. Shell Programming and Scripting
Hi,
I am new to perl.How to query oracle database with perl???
Thanks (1 Reply)
Discussion started by: tdev457
1 Replies
7. Shell Programming and Scripting
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies
8. Solaris
Hi
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query
select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p
inner join v$session se on p.addr = se.paddr
inner join
( select... (2 Replies)
Discussion started by: tharmendran
2 Replies
9. Programming
Dear community,
please help with a query on Oracle. I'm using SQLPlus (but with SQLDeveloper is the same) to accamplish a sinple query like:
select count(*) from ARCHIT_D_TB where (TYP_ID=22 OR TYP_ID=23) and SUB_TM like '%SEP%' and CONS=1234This is a very simple query that works perfect until... (5 Replies)
Discussion started by: Lord Spectre
5 Replies
10. Shell Programming and Scripting
Hi Team,
below sql rerturn 20 records, the result set i am going to assign to one variable and it showing count is 1.
and i don't use count() in sql query... based on count, i need to fail the script.
No_of_step=`echo ${g_count} | wc -l`
function gf_count()
{
g_count=`sqlplus -s... (8 Replies)
Discussion started by: bmk123
8 Replies
LEARN ABOUT DEBIAN
ch_lab
CH_LAB(1) BSD General Commands Manual CH_LAB(1)
NAME
ch_lab -- change/copy label files
SYNOPSIS
ch_lab [-S frame spacing] [-start time] [-end time] [-ext file extension] [-extract file] [-extend time] [-f sample frequency]
[-lf sample frequency] [-itype file type] [-key key file] [-lablist list of labels] [-length time] [-map map file]
[-name feature name] [-class class] [-o output file] [-otype file type] [-pad high | low] [-pos list of labels] [-q timestep]
[-range range] [-sed sed file] [fl shift time delta] [-style output stype] [-vocab vocab file] [-verify] [-nopath] [-base] [-combine]
[-divide] [-h] input files ...
DESCRIPTION
ch_lab copies from one or more input label files to an output label file, optionally performing various operations along the way.
The following option flags are recognized:
-h Print a summary of usage to standard output.
-S frame spacing
frame spacing of output
-start time
start time, in seconds, for label extraction
-end time
end time, in seconds, for label extraction
-ext file extension
filename extension to use for multiple output files
-extract file
extract a single file from a list of files
-extend time
extend track file by time seconds beyond label file
-f sample frequency
sample frequency of label file
-lf sample frequency
sample frequency for labels
-itype file type
type of input label file: esps htk ogi
-key key file
key label file
-lablist list
list of labels to be considered as blank
-length time
length of track produced, in seconds
-map map file
label mapping file
-name feature name
eg. Fo Phoneme
-class class
name of class defined in op file
-o output file
output file name
-otype file type
output file type: xmg, ascii, esps, htk
-pad high | low
pad with high or low values
-pos list
list of labels to be regarded as 'pos'
-q timestep
quantize label timings to nearst value
-range range
difference between high and low values
-sed sed file
perform regex editing using sed file
fl shift time delta
shift the times of the labels
-style output style
output style e.g. track
-vocab file
file containing list of words in vocabulary
-verify
check that only labels in vocab file are in label file
-nopath
ignore pathnames when searching label lists
-base
use base filenames for lists of label files
-combine
-divide
SEE ALSO
ch_wave(1) ch_track(1)
Edinburgh Speech Tools April 5, 2001 Edinburgh Speech Tools