10-31-2017
Oh yes, /nolog will definitely help with that. By the way in our Linux environments it appears we used hide utility that will hide sqlplus arguments.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am executing the following code :-
sqlplus -s ${DATABASE_USER} |&
print -p -- 'set feed off pause off pages 0 head off veri off line 500'
print -p -- 'set term off time off serveroutput on size 1000000'
print -p -- "set sqlprompt ''"
print -p -- "SELECT run_command from... (2 Replies)
Discussion started by: suds19
2 Replies
2. Shell Programming and Scripting
i'm not new to programming, but i AM new to unix scripting. here's my deal.
this works:
#!/bin/ksh
echo "HELLO"
/oracle_home/bin/sqlplus username/password@MYDB<<EOF
SELECT COUNT(*) FROM EMPLOYEES;
EOF
exit
echo "GOODBYE"
this doesn't:
#!/bin/ksh
echo "HELLO"
for x in 1 2... (4 Replies)
Discussion started by: akosz
4 Replies
3. Shell Programming and Scripting
I have korn shell scripts.
I want to pass a variable to a script which will execute a a sql script to read a table that contains env. variables. I want to read and then somehow export at unix level variables
example
for every row selected from the table build export command line
field1... (5 Replies)
Discussion started by: TimHortons
5 Replies
4. Shell Programming and Scripting
Hi,
I am facing the following error in calling the stored procedure from SQLPLUS in unix environment.
SQL> set serveroutput on
SQL> var store number;
SQL> exec test_proc(:store, 200);
BEGIN TEST_PROC(:store, 200); END;
*
ERROR at line 1:
ORA-01858: a non-numeric character was found... (8 Replies)
Discussion started by: pradeep7986
8 Replies
5. Shell Programming and Scripting
I'm calling an embedded sql from my shell script file. This sql does simple task of spooling out the contents of the table (see below my sample code) into a spool file that I specify. So far so good, but the problem is that the output is also displayed on screen which I do NOT want.
How can I... (3 Replies)
Discussion started by: MxC
3 Replies
6. UNIX for Dummies Questions & Answers
I want to execute a shell script from sqlplus prompt and get its output back to sqlplus. Is this possible?
if yes just give me an example for doing that. (2 Replies)
Discussion started by: boopathyvasagam
2 Replies
7. Shell Programming and Scripting
Hello All,
I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below.
cat > $v_Input_File 2>>$v_Log << EOF
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 16';
EXECUTE... (1 Reply)
Discussion started by: vikas_trl
1 Replies
8. Shell Programming and Scripting
Hello All,
I have exactly same issue @vikas_trl had in following link:
https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html
I wonder if he or somebody else could find the issue's cause or the solution.
Any help would... (4 Replies)
Discussion started by: RicardoQ
4 Replies
9. Shell Programming and Scripting
Hi,
I am trying to write a script that calls an Oracle SQL file who in turns call another SQL file. This same SQL file has to be run against the same database but using different username and password at each loop.
The first SQL file is basically a connection test and it is supposed to sort... (2 Replies)
Discussion started by: newbie_01
2 Replies
10. Shell Programming and Scripting
Hi All,
we have requirement, i am created a shell script , inside i am connecting sqlplus and execute the query. below my code for your reference.
get_sqlid ()
{
sqlid=$(
sqlplus -s $PBDW_USERID/$PBDW_PW@$PBDW_SID <<EOF
DEFINE TBLNAME=$1
set feedback off
set serverout on size... (4 Replies)
Discussion started by: KK230689
4 Replies
LEARN ABOUT CENTOS
plymouth
PLYMOUTH(1) User Commands PLYMOUTH(1)
NAME
plymouth - Send commands to plymouthd
SYNOPSIS
plymouth [OPTION...]
plymouth COMMAND [OPTION...]
DESCRIPTION
The plymouth sends commands to a running plymouthd. This is used during the boot process to control the display of the graphical boot
splash.
OPTIONS
The following options are understood. These options are supported for compatibility with the old rhgb-client interface, and have been
replaced by the commands that are described in the next section.
--help
Show summary of options.
--debug
Enable verbose debug logging.
--get-splash-plugin-path
Get directory where splash plugins are installed.
--newroot=[STRING]
Tell plymouthd that the new root filesystem is mounted.
--quit
Tell plymouthd to quit.
--ping
Check if plymouthd is running.
--has-active-vt
Check if plymouthd has an active vt.
--sysinit
Tell plymouthd root filesystem is mounted read-write.
--show-splash
Show the splash screen.
--hide-splash
Hide the splash screen.
--ask-for-password
Ask the user for a password.
--ignore-keystroke=[STRING]
Remove sensitivity to a keystroke.
--update=[STRING]
Tell plymouthd an update about boot progress.
--details
Tell plymouthd there were errors during boot.
--wait
Wait for plymouthd to quit.
COMMANDS
The following commands are understood:
change-mode OPTION
Change the operation mode.
--boot-up
Start the system up
--shutdown
Shutting the system up
--updates
Applying updates
system-update OPTION
Tell plymouthd about boot progress.
--progress=INTEGER
The percentage progress of the updates
update OPTION
Tell plymouthd about boot status changes.
--status=STRING
Tell plymouthd the current boot status
update-root-fs OPTION
Tell plymouthd about root filesystem changes.
--new-root-dir=STRING
Root filesystem is about to change
--read-write
Root filesystem is no longer read-only
show-splash
Tell plymouthd to show splash screen.
hide-splash
Tell plymouthd to hide splash screen.
ask-for-password OPTION
Ask the user for a password.
--command=STRING
Command to send password to via standard input
--prompt=STRING
Message to display when asking for password
--number-of-tries=INTEGER
Number of times to ask before giving up (requires --command)
--dont-pause-progress
Don't pause boot progress bar while asking
ask-question
Ask the user a question.
--command=STRING
Command to send the answer to via standard input
--prompt=STRING
Message to display when asking the question
--dont-pause-progress
Don't pause boot progress bar while asking
display-message OPTION
Display a message.
--text=STRING
The message text
hide-message OPTION
Hide a message.
--text=STRING
The message text
watch-keystroke OPTION
Become sensitive to a keystroke.
--command=STRING
Command to send keystroke to via standard input
--keys=STRING
Keys to become sensitive to
ignore-keystroke OPTION
Remove sensitivity to a keystroke.
--keys=STRING
Keys to remove sensitivitiy from
pause-progress
Pause boot progress bar.
unpause-progress
Unpause boot progress bar.
report-error
Tell plymouthd there were errors during boot.
deactivate
Tell plymouthd to deactivate.
reactivate
Tell plymouthd to reactivate.
quit OPTION
Tell plymouthd to quit.
--retain-splash
Don't explicitly hide boot splash on exit
SEE ALSO
grub(8), plymouth(8), plymouthd(8), http://www.freedesktop.org/wiki/Software/Plymouth
plymouth PLYMOUTH(1)