Sponsored Content
Top Forums Shell Programming and Scripting Oracle 11g script read from file in where clause (RHEL 5.7) Post 302882936 by Yoda on Thursday 9th of January 2014 05:26:46 PM
Old 01-09-2014
You could do something like this:
Code:
args="$( cat aux.txt )"
sqlplus -s user/pass@inst << EOF
select myfield1 from mytable
where myfield2 IN ( $args );
exit
EOF

This User Gave Thanks to Yoda For This Post:
 

2 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies

2. UNIX for Beginners Questions & Answers

ksh scripts migrating(Oracle 11G) from Solaris Sparc 10 to RHEL 7

Hi All, Now we are migrating oracle 11G from Solaris Sparc 10 to RHEL 7. We have 1000+ ksh scripts.. Could you please let em know what would be the best way to use exiting scripts in RHEL with minimal changes,. my concern was "Is it all Solaris command work in RHEL". (3 Replies)
Discussion started by: mssprince
3 Replies
LQR_CARVER_ATTACH(3)					     LqR library API reference					      LQR_CARVER_ATTACH(3)

NAME
lqr_carver_attach - attach an LqrCarver to another LqrCarver SYNOPSIS
#include <lqr.h> LqrRetVal lqr_carver_attach(LqrCarver* carver, LqrCarver* aux); DESCRIPTION
The function lqr_carver_attach is used to attach an LqrCarver object (pointed to by aux) to another one (pointed to by carver). This will have the effect that each operation performed over the carver object will be reflected on aux (they will share the same visibility map). This function must not be used after a visibility map was loaded into the base object (the one pointed to by carver). The object pointed to by aux must have the same original size as the base object. Note that the original size information is reset whenever a flattening operation occurs, or the rescaling direction changes, so that this function should be called befor rescaling occurs. There is no limitation on the number of LqrCarver objects which is possible to attach. Nesting is also possible. It is irrelevant if the aux carver is initialised or not; from the moment of attachment, it will passively undergo all transformations performed over carver. RETURN VALUE
The return value follows the Liquid Rescale library signalling system. LQR_ERROR is returned if the sizes of carver and aux don't match. SEE ALSO
LqrRetVal(3), lqr_carver_list_start(3), lqr_carver_list_current(3), lqr_carver_list_next(3), lqr_carver_list_foreach(3) COPYRIGHT
Copyright (C) 2007-2009 Carlo Baldassi LqR library 0.4.1 API (3:1:3) 10 Maj 2009 LQR_CARVER_ATTACH(3)
All times are GMT -4. The time now is 08:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy