| how to create database | how to create database 2003-03-31 - By Pritesh saharey
Hi all,
I would like to know how can i create a databse using sql task as like to
create database as well its tables ,iam able to create tables for my data base
but was unable to create database
as sql tage allows insert statments but not create statments,like this
<sql
driver="org.database.jdbcDriver"
url="jdbc:database-url"
userid="sa"
password="pass"
src="data.sql"
rdbms="oracle"
version="8.1."
>
insert
into table some_table
values(1,2,3,4);
truncate table some_other_table;
</sql>
Now if i want to create database like "Create Database ABC" and then want to
run my .sql script of create tables how can i do that.
pls can anybody help me out
pritesh
_____________________________________________________________
Join SQAtester.com Community ---> http://www.sqatester.com/testersarea/joinus
.htm
_____________________________________________________________
Select your own custom email address for FREE! Get you@(protected) w/No Ads,
6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag
|
|
 |
