How to pass parameter from file to sqlplus in UNIX?


 
Thread Tools Search this Thread
Top Forums Programming How to pass parameter from file to sqlplus in UNIX?
# 8  
Old 11-05-2014
Build the sql file from your script:
Code:
d=`paste -sd, file.txt`
echo "select * from acct_table where acct in ( $d );" >file.sql
echo exit >>file.sql
sqlplus -s username/password@servername @file.sql >>file.out

Hope this helps.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How pass the input parameter to a file in the script ?

OS version: RHEL 6.7 myTextFile.txt file is referred within Script1.sh script, I only execute Script1.sh and I want the input variable to be passed inside myTextFile.txt . Any idea how I can do this ? $ cat script1.sh cat myTextFile.txt $ cat myTextFile.txt $1 Requirement1.... (4 Replies)
Discussion started by: kraljic
4 Replies

2. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (3 Replies)
Discussion started by: Debalina Roy
3 Replies

3. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (2 Replies)
Discussion started by: Debalina Roy
2 Replies

4. UNIX for Dummies Questions & Answers

SQLPLUS Password Parameter file being used when logging in

Good day to everyone. This is my first time posting and just barely above basic Unix training. I think i have search thoroughly to ensure my question hasn't already been posted. But on the off chance the answer has been posted, please be nice as I am not 100% sure I know what I am looking for. I... (1 Reply)
Discussion started by: Mrjester
1 Replies

5. UNIX for Dummies Questions & Answers

Passing a Unix parameter to SQLPlus login command

hi All, i m trying to pass a user choice paramter from unix to sqlplus connect command here i want the user to enter the username and password he wants to connect in sql plus through read in unix and then automatically connect to that instance. sqlplus -s $1/$2 where $ 1 and $2 will b... (2 Replies)
Discussion started by: Jcpratap
2 Replies

6. Shell Programming and Scripting

Pass value from file to parameter

Hi Guys, I have a file in the format Parmater=value. I want to read the value and pass it to corresponding Variable. The Parameter file is as follows Number=23 Text1=mango Text2=yup 'Number' value needs to be read and passed to ID variable. Also, 'Text1' value needs to be passed to... (9 Replies)
Discussion started by: mac4rfree
9 Replies

7. Shell Programming and Scripting

How to pass parameter from sqlplus(procedure completed) to your shell script

if then # mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com echo "FILE does not exist" exit 1 fi echo "FILE EXIST" size=-1 set $(du /export/home/oracle/nas/scott21.dmp.gz) while do echo "Inside the loop" size=$1 set $(du... (1 Reply)
Discussion started by: sanora600
1 Replies

8. Shell Programming and Scripting

To pass the .sql file as a paramter to sqlplus through shell programming

Hi, Currently i have a .sql file 1.sql. I need to pass that as a parameter through a shell script to the sqlplus inside the same shell script. How I should I do.can anyone help me pls. I have an req where I need to send the .sql file and the place where the script has to create a .csv... (9 Replies)
Discussion started by: Hemamalini
9 Replies

9. Shell Programming and Scripting

Pass tablename as a parameter in the Control File -- sqlldr

Just wanted to know if there is a way to pass the table name as a parameter in the control file. I have two tables...Table A and Table B. LOAD DATA append INTO TABLE TABLE_B FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' AND '"' TRAILING NULLCOLS Rather than hard coding... (1 Reply)
Discussion started by: madhunk
1 Replies

10. UNIX for Advanced & Expert Users

How to pass unix variable to SQLPLUS

hi fellows, can any body tell me how to pass unix variables to oracle code is... #! /bin/ksh echo ENTER DATE VALUE's read START_DATE END_DATE sqlplus xyx/abc@oracle select * from table1 where coloumn1 between $START_DATE and $END_DATE; is this is correct way........... Thanks in... (1 Reply)
Discussion started by: chiru
1 Replies
Login or Register to Ask a Question
QPtrListIterator(3qt)													     QPtrListIterator(3qt)

NAME
QPtrListIterator - Iterator for QPtrList collections SYNOPSIS
#include <qptrlist.h> Inherited by QObjectListIterator and QStrListIterator. Public Members QPtrListIterator ( const QPtrList<type> & list ) ~QPtrListIterator () uint count () const bool isEmpty () const bool atFirst () const bool atLast () const type * toFirst () type * toLast () operator type * () const type * operator* () type * current () const type * operator() () type * operator++ () type * operator+= ( uint jump ) type * operator-- () type * operator-= ( uint jump ) QPtrListIterator<type> & operator= ( const QPtrListIterator<type> & it ) DESCRIPTION
The QPtrListIterator class provides an iterator for QPtrList collections. Define a template instance QPtrListIterator<X> to create a list iterator that operates on QPtrList<X> (list of X*). The following example is similar to the example in the QPtrList class documentation, but it uses QPtrListIterator. The class Employee is defined there. QPtrList<Employee> list; list.append( new Employee("John", "Doe", 50000) ); list.append( new Employee("Jane", "Williams", 80000) ); list.append( new Employee("Tom", "Jones", 60000) ); QPtrListIterator<Employee> it( list ); Employee *employee; while ( (employee = it.current()) != 0 ) { ++it; cout << employee->surname().latin1() << ", " << employee->forename().latin1() << " earns " << employee->salary() << endl; } The output is Doe, John earns 50000 Williams, Jane earns 80000 Jones, Tom earns 60000 Using a list iterator is a more robust way of traversing the list than using the QPtrList member functions first(), next(), current(), etc., as many iterators can traverse the same list independently. An iterator has its own current list item and can get the next and previous list items. It doesn't modify the list in any way. When an item is removed from the list, all iterators that point to that item are updated to point to QPtrList::current() instead to avoid dangling references. See also QPtrList, Collection Classes, and Non-GUI Classes. MEMBER FUNCTION DOCUMENTATION
QPtrListIterator::QPtrListIterator ( const QPtrList<type> & list ) Constructs an iterator for list. The current iterator item is set to point on the first item in the list. QPtrListIterator::~QPtrListIterator () Destroys the iterator. bool QPtrListIterator::atFirst () const Returns TRUE if the current iterator item is the first list item; otherwise returns FALSE. See also toFirst() and atLast(). bool QPtrListIterator::atLast () const Returns TRUE if the current iterator item is the last list item; otherwise returns FALSE. See also toLast() and atFirst(). uint QPtrListIterator::count () const Returns the number of items in the list this iterator operates on. See also isEmpty(). Example: customlayout/card.cpp. type * QPtrListIterator::current () const Returns a pointer to the current iterator item. If the iterator is positioned before the first item in the list or after the last item in the list, 0 is returned. Examples: bool QPtrListIterator::isEmpty () const Returns TRUE if the list is empty; otherwise returns FALSE. See also count(). QPtrListIterator::operator type * () const Cast operator. Returns a pointer to the current iterator item. Same as current(). type * QPtrListIterator::operator() () Makes the succeeding item current and returns the original current item. If the current iterator item was the last item in the list or if it was 0, 0 is returned. type * QPtrListIterator::operator* () Asterisk operator. Returns a pointer to the current iterator item. Same as current(). type * QPtrListIterator::operator++ () Prefix ++ makes the succeeding item current and returns the new current item. If the current iterator item was the last item in the list or if it was 0, 0 is returned. type * QPtrListIterator::operator+= ( uint jump ) Sets the current item to the item jump positions after the current item and returns a pointer to that item. If that item is beyond the last item or if the list is empty, it sets the current item to 0 and returns 0 type * QPtrListIterator::operator-- () Prefix - makes the preceding item current and returns the new current item. If the current iterator item was the first item in the list or if it was 0, 0 is returned. type * QPtrListIterator::operator-= ( uint jump ) Returns the item jump positions before the current item or 0 if it is beyond the first item. Makes this the current item. QPtrListIterator<;type> & QPtrListIterator::operator= ( const QPtrListIterator<type> & it ) Assignment. Makes a copy of the iterator it and returns a reference to this iterator. type * QPtrListIterator::toFirst () Sets the current iterator item to point to the first list item and returns a pointer to the item. Sets the current item to 0 and returns 0 if the list is empty. See also toLast() and atFirst(). type * QPtrListIterator::toLast () Sets the current iterator item to point to the last list item and returns a pointer to the item. Sets the current item to 0 and returns 0 if the list is empty. See also toFirst() and atLast(). SEE ALSO
http://doc.trolltech.com/qptrlistiterator.html http://www.trolltech.com/faq/tech.html COPYRIGHT
Copyright 1992-2007 Trolltech ASA, http://www.trolltech.com. See the license file included in the distribution for a complete license statement. AUTHOR
Generated automatically from the source code. BUGS
If you find a bug in Qt, please report it as described in http://doc.trolltech.com/bughowto.html. Good bug reports help us to help you. Thank you. The definitive Qt documentation is provided in HTML format; it is located at $QTDIR/doc/html and can be read using Qt Assistant or with a web browser. This man page is provided as a convenience for those users who prefer man pages, although this format is not officially supported by Trolltech. If you find errors in this manual page, please report them to qt-bugs@trolltech.com. Please include the name of the manual page (qptrlistiterator.3qt) and the Qt version (3.3.8). Trolltech AS 2 February 2007 QPtrListIterator(3qt)