Sponsored Content
Full Discussion: sqlplus and shell scripting
Top Forums UNIX for Dummies Questions & Answers sqlplus and shell scripting Post 5451 by LivinFree on Wednesday 15th of August 2001 01:33:47 AM
Old 08-15-2001

Are you running Linux at home, or have access to somewhere that it is? If so, head on over to oracle.com and download yourself a free personal version. Install away, and play!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies

2. Shell Programming and Scripting

connect to sqlplus from shell

I'm writting a shell script and at the begining I login to sqlplus by sqlplus -l user_name/password@instance what I would like is to check if the database is down or not , and if the database has started moved to the next step else sleep for a certain time and then check again . I know how to... (4 Replies)
Discussion started by: aya_r
4 Replies

3. Shell Programming and Scripting

SQLplus in Shell scripts

How to execute a query which is stored in a variable. Say for example : v_source_query=”select count(*) from emp” v_source_value=`sqlplus -S "$DATABASE_LOGIN" << EOF | tr '\n' ' ' set feed off set pagesize 0 set head... (12 Replies)
Discussion started by: trupti_d
12 Replies

4. UNIX for Dummies Questions & Answers

Shell Script And SQLPLUS

i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;) I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is... (6 Replies)
Discussion started by: maco_home
6 Replies

5. Programming

Shell SQLPlus

Hi, I am trying to execute the update statment in shell sqlplus.But nothing prompts.if i do ctrl+c i got the below error. SQL> update table set enabled='N' where type_code='xx'; ^C update table set enabled='N' where type_code='xx' * ERROR at line 1: ORA-01013: user requested... (2 Replies)
Discussion started by: nmahendran
2 Replies

6. Shell Programming and Scripting

SQLPLUS within shell script

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)
Discussion started by: gaurav_1711
4 Replies

7. Shell Programming and Scripting

(solved) Shell scripting to access SQLPLUS using variable

I have shell script which will try to login to SQL Plus and retrieve some data, based on the outcome i will proceed further Below is the content of the file pebblz02% cat test1.ksh #! /bin/ksh dummyvar=`sqlplus -S csm_admin/csm_admin@SIDNAME <<EOF echo hi; exit; EOF` Error message on... (0 Replies)
Discussion started by: kiranlalka
0 Replies

8. Shell Programming and Scripting

sqlplus in shell script

Hi When I use sqlplus in shell script, I get sqlplus: command not found. ORACLE_HOME is not set. How to set ORACLE_HOME in unix? Thanks (3 Replies)
Discussion started by: vinoth_kumar
3 Replies

9. Shell Programming and Scripting

Running sqlplus for 5 DB in a shell

Hi all, on AIX 6.1 I want to run the following but for 5 DB. How should I do that ? Using FOR, WHILE ???? How ? export ORACLE_SID=DB1 sqlplus / as sysdba << EOF whenever sqlerror exit sql.sqlcode; whenever oserror exit FAILURE set define off set head off set feedback off set echo off... (1 Reply)
Discussion started by: big123456
1 Replies

10. Shell Programming and Scripting

Sqlplus shell

friends because when calling a sqlplus from a shell it brings me the following message sqlplus -s $BDDUSER/$BDDPASS@$BDDHOST @$DIR_SQL/prueba.sql echo "bandera 3 " $? STATUS=$? if ;then echo "bandera 4 " $? #log_info "La ejecucion de... (1 Reply)
Discussion started by: tricampeon81
1 Replies
SWAC-GET(1)						      General Commands Manual						       SWAC-GET(1)

NAME
swac-get - audio collections of words (SWAC) manager SYNOPSIS
swac-get [-t] [clear] [update] | [upgrade] | [select <url|packid>] | [deselect <url|packid>] | [list] | [list-sources] | [list-available] | [sql <query>] | [--help] | [--version] DESCRIPTION
Swac-get is a simple command line program which allows to download and install audio collections of words (SWAC) in a SQLite3 database. Audio collections can be imported from the hard drive or directly from the Internet using the HTTP protocol. Swac-get is designed to be used with swac-explore, a GTK+ interface which allows the browsing of the created SQLite3 database. An important set of free audio collec- tions of words (SWAC) is available at: http://swac-collections.org/ For more information, please, visit the Shtooka Project homepage at: http://shtooka.net/ . COMMANDS
clear clear database deselect <url|packid> delete records of the package <url|packid> from the database list list installed packages list-available list available packages list-sources list source repositories sql <query> execute a sql query in the database select <url|packid> insert records of the package <url|packid> in the database ex: swac-get select file:///home/<my directory>/ swac-get select http://packs.shtooka.net/<my package>/ogg/ swac-get select fra-balm-voc select source-delete <url> delete <url> from the repositories list source-deselect <url> deselect <url> from the repositories list source-select <url> add <url> to the repositories list ex: swac-get source-select http://packs.shtooka.net/ swac-get source-select file:///home/<my directory>/ update update the list of available packages upgrade upgrade installed packages OPTIONS
-t, --target <path> set the SQLite3 database path (default path is ~/.swac/swac.db) -v, --version print version information and exit -h, --help print this help and exit EXAMPLES
swac-get source-select http://packs.shtooka.net/ swac-get update swac-get select chi-balm-hsk1 swac-get select fra-balm-voc BUGS
swac-get doesn't care about the version number for the upgrade command. AUTHOR
swac-get and this manual page were written by Nicolas Vion <nico@picapo.net>. mai 25, 2008 SWAC-GET(1)
All times are GMT -4. The time now is 01:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy