Creation of Oracle table through shell scripting


Login or Register to Reply

 
Thread Tools
# 1  
Old 03-06-2015
Question Creation of Oracle table through shell scripting

Hi,

I am trying to create a table through shell scripting . I used a command sqlplus -s to connect to sqlplus and user as sysdba. but there is a problem in it. can anyone please solve this .

#!/bin/bash

$(`sqlplus -s / as sysdba <<eof

create table sample (id,int);
insert into sample values(1,'value');

exit;
eof`)
Unregistered
# 2  
Old 03-06-2015
This room i for registering or account problems...
Please register if you wish to post in our forums, thanks
Thread closed
Login or Register to Reply

|
Thread Tools

More UNIX and Linux Forum Topics You Might Find Helpful
Parameterizing to dynamically generate the extract file from Oracle table using Shell Script hareshvikram Shell Programming and Scripting 0 06-28-2018 05:42 PM
Help Needed: UNIX shell variables to store Oracle table records venkat_reddy Shell Programming and Scripting 2 11-02-2015 05:23 PM
How can i populate the record in to table using shell scripting? ankit.mca.aaidu UNIX for Advanced & Expert Users 1 03-01-2015 08:36 AM
Please help in populating output in table using shell scripting ankit.mca.aaidu Shell Programming and Scripting 5 02-23-2015 03:49 AM
How to update a Oracle table through shell scripting? karthick.cho Shell Programming and Scripting 2 09-12-2013 09:46 PM
How to get the file size and count of a table using shell scripting? pawanmamidi Shell Programming and Scripting 2 01-14-2013 01:18 PM
Shell script to export data from Oracle table . honey26 Shell Programming and Scripting 2 08-13-2011 08:36 PM
Shell script to query Oracle table ken002 Shell Programming and Scripting 2 11-18-2010 01:50 AM
Create a table using shell scripting ultimatix Shell Programming and Scripting 1 10-17-2010 08:39 AM
Help in Shell scripting to modify the User Creation script in oracle database. rparavastu Shell Programming and Scripting 1 01-08-2009 05:07 PM
Shell Scripting with Oracle... B14speedfreak Shell Programming and Scripting 2 03-22-2006 11:04 AM
updating a column in oracle table using shell script sveera Shell Programming and Scripting 3 05-09-2005 01:01 PM
Store return code of shell script in oracle table sveera Shell Programming and Scripting 3 05-04-2005 01:25 PM
update a oracle table using shell script ann_124 Shell Programming and Scripting 2 12-18-2004 06:24 PM