Search Results

Yeah.i got it.

I did like this. i have assigned two variables $1 and $2 to do this.

$1 -normal Table name
$2 - Externabl table to be created from normal table with _ext.

so, . ./script abc...

var=$1;
sqlplus -s '/ as sysdba' <<EOF
set feedback off;
select * from $var;
exit;
EOF

The above works. but i want it like this.

. ./script abc -it should create a table as "abc_Ext".
...

Hi,

I am writing a script which creates an external table using a shell script. My requirement is like this.

Usage: . ./r.ksh <table_name> - this should create an external table.
e.g ....