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)
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)
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)
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)
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)
Hi
I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional.
Can anybody help me with this.
Thanks
Gaurav (4 Replies)
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)
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)
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
shell
Shell(3) LessTif Manuals Shell(3)NAME
Shell - Shell widget from X Toolkit
SYNOPSIS
#include <X11/Shell.h>
DESCRIPTION
Shell is a widget which is defined in the X Toolkit. We document its existence here for completeness. Please refer to the X Window System
documentation for the real information regarding this widget.
X RESOURCES
Name Class Type Default Access
--------------------------------------------------------------------------------
XtNx XtCPosition Position NULL CSG
XtNy XtCPosition Position NULL CSG
XtNdepth XtCDepth Int NULL CSG
XtNcolormap XtCColormap Colormap NULL CSG
XtNancestorSensitive XtCSensitive Boolean NULL CSG
XtNallowShellResize XtCAllowShellResize Boolean NULL CSG
XtNgeometry XtCGeometry String (null) CSG
XtNcreatePopupChildProc XtCCreatePopupChildProc Function NULL CSG
XtNsaveUnder XtCSaveUnder Boolean NULL CSG
XtNpopupCallback XtCCallback Callback NULL CSG
XtNpopdownCallback XtCCallback Callback NULL CSG
XtNoverrideRedirect XtCOverrideRedirect Boolean NULL CSG
XtNvisual XtCVisual Visual NULL CSG
XtNx
XtNy
XtNdepth
XtNcolormap
XtNancestorSensitive
XtNallowShellResize
XtNgeometry
XtNcreatePopupChildProc
XtNsaveUnder
XtNpopupCallback
XtNpopdownCallback
XtNoverrideRedirect
XtNvisual
CLASS HIERARCHY Object(3)Rect(3)UnNamedObj(3)Core(3)Composite(3)Shell(3)CALLBACKS CONVENIENCE FUNCTIONS SEE ALSO LessTif Project October 1998 Shell(3)