Need BIG HELP! Convert Oracle table code to SQl...

[GoSooJJ]

hi all~
This is JJ Kang.
I'm currently working on some web application and I need big help from you. One of my project is convert Oracle create table code to SQL code. Since I'm very new in both (Oracle and SQL) area, I have no clue. Because I'm ColdFusion Developer.
If any of you can help me here, that will be great.

Here is one of sample Oracle code
=================================

DROP TABLE CGLOBAL CASCADE CONSTRAINTS ;

CREATE TABLE CGLOBAL (
CFID CHAR (20),
DATA LONG,
LVISIT DATE)
TABLESPACE USERS
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 106496
NEXT 57344
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;

DROP TABLE SNAP$_TBL_ACTUALINVLOG CASCADE CONSTRAINTS ;

CREATE TABLE SNAP$_TBL_ACTUALINVLOG (
AL_KEY NUMBER NOT NULL,
AL_ITEM_ID NUMBER,
AL_DESC VARCHAR2 (255),
AL_CHANGE NUMBER,
AL_EMP_ID VARCHAR2 (10),
AL_DATEENTER DATE,
AL_TRANNUM NUMBER,
PRIMARY KEY ( AL_KEY )
USING INDEX
TABLESPACE SYSTEM PCTFREE 10
STORAGE ( INITIAL 16K NEXT 744K PCTINCREASE 50 ))
TABLESPACE A4
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 516096
NEXT 204800
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;

================================
Please help me here... Thx...
JJ

 

[MikeLacey]

JJ,

Sorry to sound daft but I'm not sure what you're after here. The code you've posted looks like valid SQL to me -- what am I misunderstanding? Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.

 

[carp]

Thanks, Mike. I thought maybe I had missed something!

 

[GoSooJJ]

Thank you Mike.
As I said before, I'm new to both SQL and Oracle. Please forgive me here... I should search more about SQL commands and then post a message...
Again, thx for advise...
JJ ^.~