Not exactly as you have asked but that doesn't sound like your problem. Here is one method:
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:
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:
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 SUNOS
gnome-sound-properties
gnome-sound-properties(1) User Commands gnome-sound-properties(1)NAME
gnome-sound-properties - enable sound, and associate sounds with events
SYNOPSIS
gnome-sound-properties [gnome-std-options]
DESCRIPTION
The Sound preference tool enables you to control when the GNOME sound server starts. You can also specify which sounds to play when partic-
ular events occur.
OPTIONS
The following options are supported:
gnome-std-optionStandard options available for use with most GNOME applications. See gnome-std-options(5) for more information.
EXAMPLES
Example 1: Launching the Sound preference tool
example% gnome-sound-properties
EXIT STATUS
The following exit values are returned:
0 Application exited successfully
>0 Application exited with failure
FILES
The following files are used by this application:
/usr/bin/gnome-sound-proExecutable for the Sound preferences tool.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+------------------------------+
|Availability |SUNWgnome-desktop-preferences |
+-----------------------------+------------------------------+
|Interface stability |External |
+-----------------------------+------------------------------+
SEE ALSO
Preference Tools Manual
Latest version of the GNOME Desktop User Guide for your platform.
libesd(3), gnome-control-center(1), gnome-std-options(5)NOTES
Written by Glynn Foster, Sun Microsystems Inc., 2003.
SunOS 5.10 2 Oct 2003 gnome-sound-properties(1)