SQL server-> Oracle query

[sunshine9]

Hello,
I'm trying to create a database and table in oracle that is identical to one i have in sql srvr2000. I am not familiar at all with oracle. Can someone pls tell me how to convert this into oracle sql?

CREATE DATABASE mydb
ON PRIMARY
(
NAME = mydb,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\mydb.mdf',
SIZE = 10MB,
FILEGROWTH = 25%
)
GO

BEGIN TRANSACTION

use mydb
GO

/* define the table */
CREATE TABLE dbo.mytable
(
a nvarchar(256) NULL,
mydate datetime NULL,
f numeric(18, 0) NULL,
) ON [PRIMARY]

commit

thanks in advance..

 

[ThomVF]

1. Do you have ORACLE installed and do you have at least a dummy/initial database?

2. If you do, do you have a user account?

3. If so, log into that account, create a script with this command in it:

CREATE TABLE mytable
(a varchar2(256),
mydate date NULL,
f number(18)
);

Every account has a default tablespace. This table will go there unless you add this to the script:

...
TABLESPACE <tablespace name>
;

That will get you started with a table using default storage parameters. You can really tune the table storage characteristics in ORACLE if necessary.

Good Luck.
&quot;Helping others to help themselves...&quot;
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com