Hi,
I have a shell script where I log on to sqlplus like this
log()
{
sqlplus -s scott/tiger <<!
select count(*) from EMP;
!
}
log
Here I have hardcoded/used the username : scott and password : tiger directly to log on to SQLPLUS. If i have my log in information in my profile file... (2 Replies)
Hi All,
I need to select one column from a table based upon the passed in parameter.
I tried this:
sqlplus -silent $MISP_USER << EOF
set feedback off;
set verify off;
set sqlprompt ""
SELECT mail_flag
FROM dailyjobs
WHERE job_name = '$1';
exit 0
EOF
exit... (1 Reply)
Howdy People :),
I'm a newbie & its my first question here. I've started learning Unix Bourne Shell scripting recently and struggling already :p Can someone PLEASE help me with the following problem. Somehow my script is not working.
Display an initial prompt of the form:
Welcome to... (1 Reply)
I am new in unix..
I am running a sql loader script where I have to specify the data file path but the file name contains spaces in it
so giving error multiple arguments
I have tried it with "" and '' but does n't work the command is :
$ORACLE_HOME/bin/sqlldr... (1 Reply)
Hi, hope everyone are fine. Please find my issue below, and I request your help in the same
In a configuration file, i have a variable defined as below
TEST = 'One','Two','Three'
I am trying to pass this variable in to a sql script which is define in a pl/sql block
as follows,
In the... (1 Reply)
Hi, can anyone help me with this script please. I need the oracle command to go into the unix batch file.
#!/bin/sh
# A menu driven Shell script which has following options
# for acmtoron@>
#
#
# Exit
# As per option do the job
#----
while :
do
clear
echo " A C M LOG MONITORING... (0 Replies)
Hi,
I have basic knowledge on how to write pl/sql code inside shell script.
I am looking for more advance thing. Is there any book for that which can just talk about how to write more advance plsql code inside shell script.
Please help
Thanks!!!!!! (1 Reply)
Please tell me how to convert below program from shell script to perl. Same commands need to use in shutdown, just need program help for startup.
export ORACLE_BASE=/home/oracle1
lsnrctl start lndb1
sqlplus '/ as sysdba'
startup; (2 Replies)
Hi Gurus,
I am new to this unix world...I need your help to walk through.
I want to learn shell scripting..... The shell script which can be able to use with oracle pl/sql...
So please suggest me which shell is good.
Which Unix/Linux version is good for this to Install to get practice the... (8 Replies)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
LEARN ABOUT DEBIAN
wmanager
WMANAGER(1) BSD General Commands Manual WMANAGER(1)NAME
wmanager -- choose a window manager and launch it
SYNOPSIS
wmanager [OPTIONS ...]
DESCRIPTION
The wmanager program displays a choice of the window managers listed in the ~/.wmanagerrc file. When one is picked, the related command is
written to standard output, intended to be used by shell scripts. If the program is exited without choosing a window manager, ``-1'' is
written to standard output.
-fg COLOR
Set the foreground color.
-bg COLOR
Set the background color.
-bg2 COLOR
Set the widget background color
-di[splay] host:n.n
Set the X display.
-dn[d], -nod[nd]
Enable/disable drag & drop, probably does nothing.
-g[eometry] WxH+X+Y
Set the window size and location.
-i[conic]
Start as iconified.
-k[bd], -nok[bd]
Enable/disable keyboard support.
-na[me] CLASSNAME
Set the X window class.
-s[cheme] SCHEME
Unknown, probably does nothing useful.
-ti[tle] WINDOWTITLE
Set the window title.
-to[oltips], -not[ooltips]
Enable/disable tooltips, probably does nothing.
EXAMPLE
To start using wmanager, create a ~/.wmanagerrc file - generally with wmanagerrc-update(1) - and add something like the following at the end
of your ~/.xsession file:
WM="$(wmanager -geometry +570+585)"
...
exec $WM
See also wmanager-loop(1) for a nicer way to start wmanager.
SEE ALSO wmanager(1), wmanager-loop(1), wmanagerrc-update(1), X(7x)HISTORY
The wmanager program was written by Meik Tessmer in 1999. This manual page was originally written in perldoc format by Tommi Virtanen in
2000, and converted to mdoc format by Peter Pentchev in 2008.
AUTHORS
The wmanager program - Meik Tessmer <fuller@daemogorgon.net>.
The manual page - Tommi Virtanen <tv@debian.org> and Peter Pentchev <roam@ringlet.net>.
BSD May 22, 2008 BSD