08-24-2012
Hi,
if the SQL dialect is Oracle SQL*Plus, a possible solution is in the last post to the following orafaq thread:
OraFAQ Forum: Unix » Passing String Arguments to SQL*Plus from a Unix Shell
Alternatively, you could think about building the .sql script on the fly every run, by using shell commands to create the SQL command string and echoing it into the .sql file.
See ya
fra
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time.
## Accept variable(s) from the command line... (1 Reply)
Discussion started by: jagannatha
1 Replies
2. Programming
Is there anyway to spool my select statement into spool files of max 10000 records each?
eg I have a select statement that will return 45000 records.
A normal spool command will output the 45000 into just one spool file.
How can I make sqlplus do this?
00001 - 10000 records --- spool... (3 Replies)
Discussion started by: Leion
3 Replies
3. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
4. Shell Programming and Scripting
How do we pass multiple arguments into awk :
name=john
age=12
now i have to pass both age and name into awk.. how to do it?
like : awk -v var=... (4 Replies)
Discussion started by: abhinav192
4 Replies
5. Shell Programming and Scripting
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
Discussion started by: dazdseg
3 Replies
6. Programming
Below i have the sample code. i need to pass the entire query from file or as parameter and read the results and write into a output file.
here the number of columns are unknown. some times it may be 2,3 or entire columns from the table.
read all the column results and write into a comma... (0 Replies)
Discussion started by: laknar
0 Replies
7. Shell Programming and Scripting
Hi, hope everyone are fine. Please find my issue below, and I request your help in the same
In a configuration file, i have a variable defined as below
TEST = 'One','Two','Three'
I am trying to pass this variable in to a sql script which is define in a pl/sql block
as follows,
In the... (1 Reply)
Discussion started by: ramakanth_burra
1 Replies
8. Shell Programming and Scripting
Hi Gurus,
I have a request which needs to pass string into sql.
dummy code as below:
sqlplus -s user/password@instance << EOF >>output.txt
set echo off head off feed off pagesize 0 trimspool on linesize 1000 colsep ,
select emp_no, emp_name from emp
where emp_no in ('a', 'b', 'c');
exit;... (4 Replies)
Discussion started by: ken6503
4 Replies
9. Shell Programming and Scripting
Hi All,
In this path /home/all_files
we have follwing files and direcotries
proc_edf_sot.sql
proc_ssc_sot.sql
func_dfg_sot.sql
sot
unic
cmr
sdc
under sot directory we have other directories
sql
pas
ref
under sql directory we have
sql_sot
sql_mat (6 Replies)
Discussion started by: ROCK_PLSQL
6 Replies
10. Shell Programming and Scripting
This script is running some exe file we are passing three argumnet below custome key word
Want to update script based on input files every time it will take argument from input file
below is the input files should take this input put it into the script.
k.ksh
cd /u/kali/temp
... (8 Replies)
Discussion started by: Kalia
8 Replies
LEARN ABOUT DEBIAN
make-sqldeveloper-package
MAKE-SQLDEVELOPER-PACKAGE(1) Oracle SQL Developer Debian package builder MAKE-SQLDEVELOPER-PACKAGE(1)
NAME
make-sqldeveloper-package - Oracle SQL Developer Debian package builder
SYNOPSIS
make-sqldeveloper-package [options] <file>
DESCRIPTION
make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer.
The Oracle SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with
the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility
to use the resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on
when downloading the source.
This utility will require you to download the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technet-
work/developer-tools/sql-developer/> to create the Debian package from.
OPTIONS
-b|--build-dir <dir>
base directory to build package (autogenerated)
-e|--email <email>
local maintainer email (use DEBEMAIL or auto-generate)
-i|--install
install the generated package - needs root privilege (no)
-k|--keep-dir
keep the build directory (no)
-l|--revision <number>
local revision to append to package version (1)
-m|--maintainer <name>
local maintainer name (use DEBFULLNAME or leave empty)
-r|--root-command <command>
command to gain root privilege for package build (fakeroot)
-u|--upstream-version <version>
force the upstream version (autodetected)
-h|--help
display the help screen
-v|--version
show the program version
<file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/>
AUTHOR
make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>.
This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others).
GNU
2012-11-13 MAKE-SQLDEVELOPER-PACKAGE(1)