02-12-2008
hi
do you want to have those 100 ids only or there could be more than that?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends :)
I am having a small problem and ur help is needed...
I have a long file from which i want to select only some portions after filtering (grep).
My file looks like :
header
xxyy
lmno
xxyy
wxyz
footer
header
abcd
xy
pqrs
footer
.
. (14 Replies)
Discussion started by: vanand420
14 Replies
2. Shell Programming and Scripting
Hi,
I have a shell script that returns 10 records for the column Name and age from a select query. Where when i store those data in retrieve_list.txt file i need to store the data in a particular format like:-
$Jason$30
$Bill$23
$Roshan$25
Here is my script:
1)... (15 Replies)
Discussion started by: sachin.tendulka
15 Replies
3. Shell Programming and Scripting
Hi Friends,
Can u please help mw with the following query .
I need to run a database sql statement to select particular fields from a table.I need to store the retrieved filed values into variables so that i can print it in a specific format. But the particular select query retrieves more... (12 Replies)
Discussion started by: jisha
12 Replies
4. UNIX for Dummies Questions & Answers
Hi all,
Here is my problem. I want to read data from a file and pass the variable to a select query.
I tried but it doesn't seem to work. Please advise. Example below.
FileName='filekey.txt'
while read LINE
do
var=$LINE
print "For File key $var"
${ORACLE_HOME}/bin/sqlplus -s... (1 Reply)
Discussion started by: er_ashu
1 Replies
5. Shell Programming and Scripting
How to redirect postgresql select query to a variable using shell scripts?
I tried to use
psql -c "select ip from servers" db | egrep '+\.+\+\+' | sed 's/^ *\(.*\) *$/\1/'
Output:
10.10.10.180
10.10.10.181
It display ip addresses from the databasem, but how could i redirect the... (3 Replies)
Discussion started by: uativan
3 Replies
6. Shell Programming and Scripting
I have been asked to create a shell script that accepts a number of SQL select queries as input, runs them in sequence, spools the output to an EXCEL workbook, where, each worksheet is an output of a Select statement run above.
The workbook should be in a .XLS format. If a particular select... (2 Replies)
Discussion started by: ShellNovice1
2 Replies
7. Shell Programming and Scripting
hi..
i need to optimize my select query ..
my situation is like this ..
i have 15 lac recors in my table..
the following query takes nine seconds to give the required output..
SELECT max(ah.AUC_AMT),
SUBSTRING_INDEX(GROUP_CONCAT(SUBSTRING_INDEX(ah.AUC_CUS_NAME,'@',1) order by AUC_AMT... (0 Replies)
Discussion started by: senkerth
0 Replies
8. UNIX for Advanced & Expert Users
hi..
i need to optimize my select query ..
my situation is like this ..
i have 15 lac recors in my table..
the following query takes nine seconds to give the required output..
SELECT max(ah.AUC_AMT),
SUBSTRING_INDEX(GROUP_CONCAT(SUBSTRING_INDEX(ah.AUC_CUS_NAME,'@',1) order by AUC_AMT... (1 Reply)
Discussion started by: senkerth
1 Replies
9. Shell Programming and Scripting
Hi,
I have a perl snippet that call a select query with a bind variable,when i compile the script I'm unable to get the query output.
The same query when i fire in sqlplus fetches few rows.
The query takes bit time to fetch results in sqlplus.
my $getaccts = $lda->prepare("select distinct ... (1 Reply)
Discussion started by: rkrish
1 Replies
10. Programming
Hey Guys,
I'm using SQuirreL SQL v3.5 GUI to fetch some data that I need for something I'm working on. I'm also using the IBM Informix Driver (*Version 3.5) to connect to the Database.
What I want to do, if it's even possible, is to show all COLUMNS if they contain the word "Email".
So in... (2 Replies)
Discussion started by: mrm5102
2 Replies
LEARN ABOUT DEBIAN
swfextract
swfextract(1) swftools swfextract(1)
NAME
swfextract - a tool for extracting data out of swf files.
Synopsis
swfextract [options] [file.swf]
DESCRIPTION
swfextracts allows one to extract swf movieclips and objects out of swf files.
SWF files are animation files which can be displayed in Web Browsers using the Flash Plugin.
OPTIONS
-h, --help
Print short help message and exit
-o, --output filename
Write output to file filename
-V, --version
Print version info and exit
-i, --id ids
ids is a range of IDs to extract. E.g. 1-10,14
-j, --jpegs ids
ids is a range of JPEG IDs to extract. E.g. 1-2,3,14-
-p, --pngs ids
ids is a range of PNG IDs to extract. E.g. -10,20-30
-f, --frame frames
frames is a range of frames to extract. E.g. 1-10,20-30,40-
-n, --name name
Set the name of the object to extract to name.
-w, --hollow
Copy empty frames to the output file, too.
-P, --placeobject
Copy original placeobject tag for the given object into the output file (Use with -i). This means that the object is at the same
position in the generated movie as in the original movie.
-j, --jpegs range
Extract jpeg pictures in range
-p, --pngs range
Extract png pictures in range
-m, --mp3
Extract main mp3 stream (There may be substreams in the Movieclips, as well. To extract these, first extract the Movieclips with -i
and then use -m)
AUTHOR
Matthias Kramm <kramm@quiss.org>
swfdump January 2003 swfextract(1)