|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
sql output from multiple rows and columns as variables in a script
Post 302427412 by lmu on Saturday 5th of June 2010 10:35:42 AM
06-05-2010
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time.
## Accept variable(s) from the command line... (1 Reply)
Discussion started by: jagannatha
1 Replies
2. Shell Programming and Scripting
U have a file
File 1
0.3 0.2 0.4 0.3 0.8 0.11 0.22
0.4 0.23 0.45 0.56 0.78 0.98
0.11 0.32 0.2 0.4 0.45 0.54
0.2 0.33 0.44 0.21 0.22 0.98
0.8 0.2 0.34 0.54 0.98 0.12
0.1 0.22 0.32 0.34 0.89 0.22
File 2
rows columns
3 1
2 3
4 2
5 ... (8 Replies)
Discussion started by: cdfd123
8 Replies
3. Shell Programming and Scripting
Hi All,
I would like to ask help on how can i achieve below output.
Inputfile:
Oct11,apa1-daily,01:25:01
Oct11,apa2-daily,01:45:23
Oct12,apa1-daily,02:30:11
Oct12,apa2-daily,01:55:01
Oct13,apa1-off,01:43:34
Oct13,apa2-off,01:22:04
Desired output:
Clients ... (3 Replies)
Discussion started by: mars101
3 Replies
4. Shell Programming and Scripting
Hi,
How to set as variable from sql output.
Query:
select aa.serial, ao.name from ann_amit aa JOIN ann_object ao on (aa.classid=ao.classid);
I got two values from aa.serial and ao.name, I wanna make two different variable for aa.serial and ao.name.
The value of aa.serial should be in... (2 Replies)
Discussion started by: KarthikPS
2 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have connected to oracle database with sqlplus -s / <<EOF
select ename, age from emp where empid=1234;
EOF
I want to save the values of ename and age in unix shell variables. Any pointers would be welcome..
Thanks in advance!!1
Cheers :):):):) (1 Reply)
Discussion started by: gonchusirsa
1 Replies
6. Shell Programming and Scripting
Hello all, I've got a script that collects data on file systems and prints out specific data about each. I've formatted headers w/ printf like so.
printf "\033
and I had the content of the varibles printed out beneath those columns like so:
printf... (5 Replies)
Discussion started by: awreneau
5 Replies
7. Shell Programming and Scripting
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies
8. Shell Programming and Scripting
Hello,
I would like to ask for help with csh script.
An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that... (7 Replies)
Discussion started by: FMMOLA
7 Replies
9. Shell Programming and Scripting
Hi,
I am trying to transpose rows to columns for thousands of records. The problem is there are records that have the same lines that need to be separated. the input file as below:-
ID 1A02_HUMAN
AC P01892; O19619; P06338; P10313; P30444; P30445; P30446; P30514;
AC Q29680; Q29837;... (2 Replies)
Discussion started by: redse171
2 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT DEBIAN
xfireworks
XFIREWORKS(6) Games Manual XFIREWORKS(6) NAME
XFireworks - Fireworks in the root window on X. SYNOPSIS
xfireworks [ options ] DESCRIPTION
XFireworks makes fireworks in the root window on X. This is imitation of Japanese "Hanabi Taikai". It is very popular event in Japanese summer and performed on some rivers. Sumidagawa River's Hanabi Taikai is very popular. The author has seen Arakawa River's Hanabi Taikai every year. OPTIONS
-h, -help Output help messages. -display [displayname] The name of the X server to use. -bg, -background, -background-color [color name] Background color of the root window. -f, -file [filename] The name of the file to configure fireworks. Default configure file is ./xfireworks.conf -wait [wait time] Wait time for micro seconds. -fine [number] Steps of moving pieces of fireworks for percent. Default value is 100. If this value is small, xfireworks runs quickly and speedy. -gradation [number] Color gradation. Default value is 16. If color gradation is a little, colors are shared, memory of X server and xfireworks are saved, and xfireworks starts up quickly. -direct-draw XFireworks draw fireworks in the root window directly. (Default) -no-direct-draw XFireworks draw fireworks in a pixmap and copy it to the root window as a background pixmap. If xfireworks don't run properly or you want to run XFireworks as a background pixmap, try this option. -probability, -probability-magnification [number] Magnification of probability of performing fireworks for percent. Default value is 100. If this value is small, fireworks is very silent. If this value is large, fireworks is very loud. -size, -size-magnification [number] Magnification of size of pieces for percent. Default value is 100. -air, -air-magnification [number] Magnification of air resistance for percent. Default value is 100. -gravity, -gravity-magnification [number] Magnification of gravity for percent. Default value is 100. -transmission, -transmission-magnification [number] Magnification of velocity transmission for percent. Default value is 100. -after-image, -after-image-magnification [number] Magnification of after images length for percent. Default value is 100. If this value is large, length of after images is very long. -color-length, -color-length-magnification [number] Magnification of color change length for percent. Default value is 100. -next-power, -next-power-magnification [number] Magnification of pieces explosion power for percent. Default value is 100. -next-number, -next-number-magnification [number] Magnification of the number of pieces for percent. Default value is 100. If this value is small, fireworks is very silent. If this value is large, fireworks is very loud. EXAMPLES
If your machine is very slow, try > xfireworks -fine 75 -after-image 75 If your machine has less colors, try > xfireworks -gradation 5 XFireworks use 5x5x5=125 colors. If you have very high spec machine, try > xfireworks -fine 200 -after-image 150 -gradation 64 -wait 10000 If you like simple fireworks (it's Japanese "Wabi Sabi"), try > xfireworks -probability 50 If you like loud fireworks, try > xfireworks -probability 500 -after-image 200 -next-number 120 If xfireworks don't run properly, try > xfireworks -direct-draw or > xfireworks -no-direct-draw SEE ALSO
X(1) FILES
./xfireworks.conf, /usr/lib/games/xfireworks/xfireworks.conf The default file to configure XFireworks. XFireworks search the configuration file in the current directry at first. If not exist, second, XFireworks search "<XRoot>/lib/X11/XFire- works". If not exist, XFireworks use the default data in itself at last. You can get the newest xfireworks.conf from the web page of XFireworks. The newest xfireworks.conf has more kinds of fireworks and is more beautiful. Q AND A
Q. All of fireworks are white. A. Your machine have less colors. Use -gradation option and decrease the number of colors to use. Q. If I use gmc (GNOME file manager), xfireworks runs very slow. A. Try -no-direct-draw option. Q. I want to put fireworks on the root window as a background picture. But, if I stop xfireworks with Ctrl-C, the root window is cleaned. A. Try -no-direct-draw option. If you run xfireworks with -no-direct-draw option, xfireworks don't clean the root window when you stop xfire- works. Q. If I use xfireworks with -fine 500 -after-image 500 options, movements of fireworks are not smoothly. A. Try -no-direct-draw option. If you run xfireworks with -no-direct-draw option, xfireworks draw fireworks on a pixmap and copy it to the root window, and movements of fireworks are smoothly. Q. I want to see more beautiful fireworks! A. Access the XFireworks's web page and download the newest xfireworks.conf. Q. I want to make my original fireworks! A. Edit xfireworks.conf. If you make more beautiful fireworks, please send it to the author. AUTHOR
Programed by SAKAI Hiroaki. E-Mail: sakai@seki.ee.kagu.sut.ac.jp, hsakai@pfu.co.jp Web site: http://www.seki.ee.kagu.sut.ac.jp/~sakai/myfreesoft/index.html Mirror site: http://hp.vector.co.jp/authors/VA014157/myfreesoft/index.html http://www.people.or.jp/~hsakai/myfreesoft/index.html If you want the newest xfireworks.conf, access these web pages. SPECIAL THANKS
Hashimoto Jun for many advices and test on Linux. Simosako Akira for test on Linux and many informations. Koga Kazuhiro for test on Linux. Umehara Taro for test on FreeBSD. Morimi Asuka for many advices. COPYRIGHT
XFireworks Copyright (c) 2000 SAKAI Hiroaki. All Rights Reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2, or (at your option) any later version. X Version 11 Release 6 XFIREWORKS(6)