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

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Pass tablename as a parameter in the Control File -- sqlldr

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Pass parameter into script	alfredo	Shell Programming and Scripting	2	04-08-2008 09:40 PM
Help required to pass the parameter	u263066	Shell Programming and Scripting	4	08-11-2006 01:56 PM
PASS parameter to AWK	unisam	UNIX for Dummies Questions & Answers	2	05-14-2004 09:51 AM
Pass Parameter to Another Script	rvprod	UNIX for Dummies Questions & Answers	4	04-05-2002 12:07 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

06-15-2006

madhunk

Registered User

Join Date: Nov 2005

Posts: 91

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.

Code:

LOAD DATA
append
INTO TABLE TABLE_B
FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' AND '"'
TRAILING NULLCOLS

Rather than hard coding 'TABLE_B', can I pass it as a parameter? I searched the forum and couldn't find any...

I am executing sqlldr from a shell script and passing control file and data file as parameters. Can I add an additional parameter as a table name too?

Thank You

Bookmarks

« ftp mdel help | How to run an SQL script inside a shell »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 12:16 PM.