yippe. (thanks a ton) . i figured out hw to call a file finally. bt hw do i interpret this data in the fields required by me is the next step. ..
Code:
select account_no into tempdb..sun from ABC
go
i am selecting account_no into tempdb creating sun table and copying data from ABC. (this is working fine, i mean i am able to create the table).
and the isql command i am running the one which u told me:-
Code:
Retrieve_Date()
{
if [[ "${MODE}" = "FULL" ]]
then
(
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b -h0 -i${MYDIR}/abc.sql << FINSQL
go
FINSQL
) > XYZ.txt
fi
I wanted to know how can i get the result of the sql query performed in abc.sql into a variable in my shell script. so that i can use those records. i am checking the database and i am seeing a temp. table being created but unable to get those records in my script. any ideas??
Oracle and Scripting gurus,
I need some help with this script...
I am trying to add the query
SELECT * FROM
ALL_SYNONYMS
WHERE SYNONYM_NAME = 'METADATA'
in the current script....
Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
I have created abc.sh file which will set the environment variables (UNIX env variables as well as ORACLE required variables like ORACLE_SID,ORACLE_HOME etc) and then calls a function file which checks for starts some logs and then it will try to execute the .sql file. The .sh, function file are as... (1 Reply)
Hi all,
In a shell script I need to pass two parameters to a pl/sql script and get the ouput of the pl/sql script and use it in shell script.
For example
Shell script : test.sh
PL/SQL script : get_id.sql parameter1 parameter2
Actually get_id.sql has a select statement something... (1 Reply)
Hello everybody
I need help calling sql file from shell script.
Can anyone help me creating a small shell script which calls an sql file .
The .sql file should contain some select statements like
select emp_no from emp_table;
select emp_id from emp_table;
And the results should be... (6 Replies)
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Dear All,
I want to call an sql script within a unix shell script. I want to pass a parameter into the shell script which should be used as a parameter in teh sql script.
e.g
$ ./shell1.sh 5000129
here 5000129 is a prameter
inside shell script i am calling one sql script
e.g. ... (2 Replies)
Hi
I have a shell script that call a sql file. The sql file will create a spool file.
My requirement is, when ever i get an OS error like file not found. I have to log it in a log file.
Could some who worked in a like scenario help me by giving the code sample.
Many Thanks.. (1 Reply)
Hi,
I am calling a sql file script.sql from shell script and passing few parameters also as shown below:
sqlplus -S id/password @script.sql $param1 $param2
Now,In sql file I have to create a extract text file after querying oracle tables based on the parameters passed(param1,param2) as... (7 Replies)
I have a master shell script which calls some 40 shell scripts. All the shell scripts calls a sql file which executes some sql statements.
I run these scripts in parallel such that it saves me time. When i executed them i saw some strange behavior.
Firstly, I found that some scripts among the 40... (1 Reply)
Hi,
i have one simple PL/SQL Block and i have saved it as .sql file, which i am trying to call from UNIX script.
PL/SQL block structure
CONNECT DB_NAME/PWD@Database
whenever SQLERROR EXIT 1;
Declare
..Variables...
BEGIN
--Code--
exception
END;
exit;
I have save this block as... (3 Replies)
Discussion started by: abhii
3 Replies
LEARN ABOUT DEBIAN
swac-get
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)
05-25-2010
.