也就是相当于SQL Server吓得这么一段sql语句,在oracle下应该如何改写?if exists (select * from sysobjects where id = object_id(N'[dbo].[dwqkk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[dwqkk]
GOCREATE TABLE [dbo].[dwqkk] (
[dwdm] [varchar] (10) NOT NULL ,
[dwmc] [varchar] (26) NULL ,
[dht] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
drop table [dbo].[dwqkk]
GOCREATE TABLE [dbo].[dwqkk] (
[dwdm] [varchar] (10) NOT NULL ,
[dwmc] [varchar] (26) NULL ,
[dht] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
使用varchar2------------------------
| |
| 相逢何必曾相识 |
| |
------------------------
手工可以根据自己的需要来建库,但很繁琐的!
CREATE or replace TABLE [dbo].[dwqkk] (
[dwdm] [varchar2] (10) NOT NULL ,
[dwmc] [varchar2] (26) NULL ,
[dht] [blob] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]