02-15-2013
This User Gave Thanks to itkamaraj For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How do I dynamically assign the below output to unix shell variables
so I can build a menu in a shell script?
Example:
var1 = 1 var2= SYSTEM
var3 = 2 var4= UNDOTBS1
and so on, then in the shell script I can use the variables to build a menu.
set serveroutput on
declare... (2 Replies)
Discussion started by: djehres
2 Replies
2. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
3. Shell Programming and Scripting
This is for an Oracle journal import. I was using a pl/sql package and oracle API's. Oracle added invoker rights to their API's and now my package won't run. I didn't want to use their API's anyway. The only reason i was using pl/sql and the API's (just a package) was to utilize a cursor. How... (2 Replies)
Discussion started by: lmu
2 Replies
4. Shell Programming and Scripting
While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing.
I recalled I made a coprocess example for folks at... (2 Replies)
Discussion started by: gary_w
2 Replies
5. Shell Programming and Scripting
Hi,
I am new to linux...
How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me.
Ex: SQL> Select * from EMP;
O/P: Emp_No Emp_Name
1 AAA
2 BBB
3 CCC
and I want expected... (5 Replies)
Discussion started by: Sravana Kumar
5 Replies
6. UNIX for Dummies Questions & Answers
Hi,
Could you please help me on this.
I have bulk of queries written in text file. I want to use those queries and want to execute from UNIX.
I don't want to run this file as a sql file as this file will change every week.
I want to run it in my environment as bulk sql statement from text... (1 Reply)
Discussion started by: abhii
1 Replies
7. Shell Programming and Scripting
I have sql query in shell script.
select distinct account_no from adj order by account_no;
This query returns account number daily.Sometimes it may return 90 rows sometime it may return 1 row only and someday it may return 0 rows
I am storing the output of this query in sql_output.txt.
... (5 Replies)
Discussion started by: rafa_fed2
5 Replies
8. Programming
Hi, I have 2 different values in the same column and two different values in other column
Query 1
ins name value
1 Test 12345
1 TestV1 12/10/2014
8 Test 85435
8 TestV1 11/11/2005
9 Test 42232
9 TestV1 19/10/2000
6 Test 54321... (6 Replies)
Discussion started by: faka
6 Replies
9. Shell Programming and Scripting
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies
10. Shell Programming and Scripting
Hi,
I'm trying to asign to ksh varible some values of a sql query. The output query would be:
xxxx 1
yyyy 2
I do:
values=`$PATH_UTI/query_sh "
select think1||'------'||think2 from some_table
where think3 = '$1';
... (2 Replies)
Discussion started by: mierdatuti
2 Replies
LEARN ABOUT DEBIAN
dpkg-www
DPKG-WWW(1) General Commands Manual DPKG-WWW(1)
NAME
dpkg-www - program to remotely open a WWW Debian package browser
SYNOPSIS
dpkg-www [-s|--stdout] [-h|--host host] [query]
DESCRIPTION
dpkg-www is used to remotely control a WEB browser and open a dpkg URL on the local host from an interactive shell or script.
If the command is invoked while running under X-window the script will try to find an installed X browser to open the specified URL. If
not running under X it will try to use a text browser instead.
If Netscape is found and a Netscape instance is already running it will be asked to open the dpkg URL on localhost with the optional query
supplied on the command line. If there is no browser running, it will start automatically a new one.
The functionality provided by this program is identical to running a web browser with the -remote openURL(http://localhost/cgi-bin/dpkg)
argument or opening the same URL from within the browser.
dpkg-www-installer is an helper application which can configured in the WWW browser for web installation. It should never be invoked
directly by the user.
OPTIONS
-s, --stdout
Redirect output to stdout. Requires one of the text browsers (lynx, lynx-ssl or links) installed.
-h, --host host
Send the query to a remote host, where dpkg-www must be installed.
query Specifies an optional package name, an absolute pathname or a query argument which is passed to the dpkg cgi-bin. See dpkg-www(8)
for more information about the use of the cgi.
FILES
/etc/dpkg-www.conf
~/.dpkg-www
Configuration files for dpkg-www. It is not necessary for these files to exist, there are sensible defaults for everything, but you
can specify your preferred www browser with the DPKG_WWW_BROWSER variable, for example: DPKG_WWW_BROWSER=mozilla
EXAMPLES
dpkg-www
This would open a dpkg URL on localhost listing all the installed packages.
dpkg-www bash
This would open a dpkg URL asking info on the bash package.
dpkg-www -h pisolo bash
This would open a dpkg URL asking info on the bash package on host pisolo.
dpkg-www 'dpkg*'
This would open a dpkg URL listing all packages matching dpkg*.
dpkg-www /bin/bash
This would open a dpkg URL asking info on the package(s) owning the file /bin/bash .
dpkg-www depends=svgalib
This would open a dpkg URL listing all packages depending on svgalib.
dpkg-www --stdout depends=awk | grep ^ii
This would list on stdout all packages depending on awk and grep all lines of installed packages.
SEE ALSO
dpkg(8), dpkg-www(8)
AUTHOR
Massimo Dal Zotto <dz@debian.org>.
Bugs should be reported via the normal Debian bug reporting system.
LICENCE
dpkg-www is licensed under the GNU General Public License version 2.
September 1, 2004 DPKG-WWW(1)