[ORACLE] CREATE TABLE in bash - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
[ORACLE] CREATE TABLE in bash

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
to create a oracle table in perl script	megh	HP-UX	1	10-11-2008 08:59 PM
How to create IP table at Free BSD	Ashraff Ali	BSD	4	08-15-2008 06:24 PM
Integrating the Oracle Designer Legacy Table API with Oracle JDeveloper 11g ADF Busin	iBot	Oracle Updates (RSS)	0	04-06-2008 05:10 AM
upload oracle table	swapnil286	HP-UX	2	01-04-2007 03:37 AM
create new table/field	Gr4wk	Shell Programming and Scripting	2	05-03-2006 09:07 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

10-28-2008

radek

Registered User

Join Date: Oct 2008

Location: Warsaw, Central Europe

Posts: 3

[ORACLE] CREATE TABLE in bash

Hey,
I want to create a table in bash, my db server is oracle. You can find my script below:

Quote:

current_path=`pwd`
login=user
passwd=passwd
db=db
table=TABLE
file=$current_path"/Fields.dat"
login1=login1
passwd1=passwd1
table1=TABLE1

for i in `cat $file`
do

exec_query=`sqlplus -S "$login/$passwd@$db"<<EOF
DROP TABLE IF EXISITS $table1;
CREATE TABLE $table1 AS SELECT \* FROM $login.$table WHERE $i IN (SELECT $i FROM $login.$table MINUS SELECT $i FROM login1.$table);
exit
EOF`
done

I am very confused. I tried to run this script many times without any luck. Please help!

Bookmarks

« How to awk/sed/grep lines which contains a pattern at a given position | Awk help »

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 09:52 AM.