If sqlplus can't be found then ${ORACLE_HOME}/bin is not in your path. If that is not in your path then you probably didn't prepare your environment properly by invoking /usr/local/bin/oraenv.
You can also use a named pipe to log in to the database as follows:
Code:
mknod /tmp/loginfile.sql p
print "connect un/pw" > /tmp/loginfile.sql & <== login credentials in a sql script temporarily
sqlplus -s /nolog <<EOF > youroutputfile
@/tmp/loginfile.sql
...
EOF
You must provide login credentials in order to query the database. Your DBA can configure accounts that allow you to not specify any username or password as you have been given examples for. If your DBA defines accounts using OPS$ prefix, then you can log in as follows:
Code:
sqlplus -s / <<EOF >yourloginfile.sql <== login credentials tied to your os login
...
EOF
I cannot figure out how to run a SQL script, or just a sqlplus query, from a shell script (bash or ksh). Basically, I need to su - oracle from root and run a query, then test the exit status. (3 Replies)
Hi ALL,
I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know.
select query returns multiple values( say select name from emp)
Thanks in advance
LM (1 Reply)
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
query sql using shell script, is it possible?
my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script?
thanks in advance! (2 Replies)
I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Hi all,
My reqirenet goes like this.
Need to execute one select statement within the script and send a mail to the users with the number of records fecthed from the query.
Please help..
Thanks. (3 Replies)
Hi,
I have one SQL file prepared in UNIX and one script that is executing that.
In SQL i have Update and create queries.
I want to introduce conditions in SQL file (in UNIX) that if either of the create or update query failes whole transaction should be rollback.
I just have 1 create... (2 Replies)
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Hello~
I have a requirement to write a shell script which will connect to the oracle database and run a select count(*) query on a table.
The script should succeed only when the count returns a number greater than zero. If the count returns zero, the script should fail.
Can someone please... (3 Replies)
Discussion started by: Naren.N
3 Replies
LEARN ABOUT SUSE
sound-juicer
sound-juicer(1) General Commands Manual sound-juicer(1)NAME
sound-juicer - GNOME-desktop CD ripper and player using GStreamer
SYNOPSIS
sound-juicer [option...]
DESCRIPTION
sound-juicer is a CD ripper and player for GNOME which aims to have a simple, clean, easy to use interface. sound-juicer supports encoding
to several popular audio formats such as Ogg Vorbis and FLAC, additional formats can be added through GStreamer plugins.
For additional documentation on interactive use of sound-juicer select the Help menu option. The menus allow access to features not avail-
able through command-line options.
OPTIONS -a, --auto-start
Start extracting immediately
-p, --play
Start playing immediately
-d, --device=DEVICE
What CD device to read
--display=DISPLAY
X display to use
-?, --help
Show help options
--help-all
Show all help options
--help-gst
Show GStreamer Options
--help-gtk
Show GTK+ Options
--help-bonobo-activation
Show Bonobo Activation options
--help-gnome
Show GNOME options
--help-gnome-session
Show session management options
--help-gnome-ui
Show GNOME GUI options
AUTHOR
sound-juicer was written by Ross Burton <ross@burtonini.com>. This manual page was written by Sven Arvidsson <sa@whiz.se>, for the Debian
GNU/Linux system (but may be used by others).
SEE ALSO
The online documentation available through the program's Help menu.
GNOME 2006-11-26 sound-juicer(1)