ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pritesh saharey <prit...@sqatester.com>
Subject how to create database
Date Mon, 31 Mar 2003 06:01:43 GMT
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@yourchoice.com w/No Ads, 6MB, POP &
more! http://www.everyone.net/selectmail?campaign=tag

Mime
View raw message