11-19-2009
Thanks Dennis, it worked perfect !!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. Shell Programming and Scripting
I have a script which connects to different database servers using sqlplus. Is there a way by which I can run a shell command on that host from sqlplus?
I know about 'host' command but it runs script on the local machine where the original script is running. Is there a way to run command on the... (9 Replies)
Discussion started by: dkr123
9 Replies
3. UNIX for Dummies Questions & Answers
i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;)
I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is... (6 Replies)
Discussion started by: maco_home
6 Replies
4. Shell Programming and Scripting
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies
5. Shell Programming and Scripting
Hi,
I am writing a script to test database connection. If the first try fails, it will wait for 1 minutes and then try again. The script is as following:
........
for i in $ORACLE_SID
do
$ORACLE_HOME/bin/sqlplus $username/$password@$i <<! >/dev/null
select * from tab;
exit
if ; then... (3 Replies)
Discussion started by: beaniebear
3 Replies
6. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
7. Shell Programming and Scripting
Hi All,
How i will use sqlplus in shell script?
Can any one provide sample code which explain following:
1. Connect to oracle DB
2. Exceute select * from tablename
3. Release connection to the DB
4. Append output in file everytime when query executes.
Thanks in advance (1 Reply)
Discussion started by: poweroflinux
1 Replies
8. Shell Programming and Scripting
sql_rows=`sqlplus -s / <<EOF
set heading off
set pagesize 1000
set tab off
set linesize 120 wrap off
column "Path" format a15
--column "No_Of_files" format a10
select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files
... (7 Replies)
Discussion started by: desibabu
7 Replies
9. Shell Programming and Scripting
Hi
When I use sqlplus in shell script, I get sqlplus: command not found.
ORACLE_HOME is not set. How to set ORACLE_HOME in unix?
Thanks (3 Replies)
Discussion started by: vinoth_kumar
3 Replies
10. Shell Programming and Scripting
Hi All,
Please let me know what i am missing in the following code (part of my script)
Schemas=(AWQM WFCONTROLLER PROVCO PRISM)
for s in "${Schemas}"
do
sch="${s}_$tol"
if || ;then
echo "This is AD or TD region"
sqlplus -s $sch/$tpwd@$ttns <<EOF... (7 Replies)
Discussion started by: pvmanikandan
7 Replies
LEARN ABOUT DEBIAN
openapp
openapp(1) GNUstep System Manual openapp(1)
NAME
openapp - launch applications from the command line
SYNOPSIS
openapp [--find] [--debug [--gdb= debuger]] [ --library-combo=library-combo ] application [arguments...]
DESCRIPTION
The openapp command allows you to launch graphical GNUstep applications from the command line.
application is the complete or relative name of the application program with or without the .app extension, like Ink.app.
arguments are the arguments passed to the application.
openapp first checks whether the application is in the current working directory. If not then searches the GNUstep domains' Applications
folders in the following order: User (i.e. ~/GNUstep/Applications), Local, Network, System. First match wins.
OPTIONS
--find application
will print out the full path of the application executable which would be executed, without actually executing it. It will also list
all paths that are attempted.
--debug application
starts the application in the debugger. By default gdb, but this can be changed with the --gdb= argument or through the GDB shell
variable.
--library-combo=library-combo
Starts the application with the specified library combo. This is a rarely used option in a non-flattened setup. See the library-
combo(7) man-page for more information about the different library combinations.
--help print above usage description.
EXAMPLES
Start Ink.app without additional parameters:
openapp Ink.app
Launch Ink.app and pass it the --debug argument:
openapp --debug Ink.app
To determine which executable is launched by openapp, type:
openapp --find Ink.app
The output of the above command might be something like: /usr/GNUstep/Local/Applications/Ink.app/Ink
ENVIRONMENT
GNUSTEP_CONFIG_FILE
is used to determine where the GNUstep.sh configuration file is located. If the variable is not set openapp tries to locate it in
the folder where openapp was started, then in the user domain, and as a last resort in the system domain (or actually the place you
configured (--with-config-file=) during building).
GDB Sets the debugger to use when --debug is used.
SEE ALSO
debugapp(1), GNUstep(7), gopen(1), library-combo(7), opentool(1)
HISTORY
Work on openapp started October 1997.
openapp was originally written by Ovidiu Predescu <ovidiu@net-community.com> and is now maintained by Nicola Pero <nicola.pero@meta-innova-
tion.com>
AUTHORS
This manual page was first written July 2003 by Martin Brecher <martin@mb-itconsulting.com>.
Updated with notes from Hubert Chathi <uhoreg@debian.org> and Dennis Leeuw <dleeuw@made-it.com>, December 2007 by Dennis Leeuw.
gnustep-make 12/12/2007 openapp(1)