本人对SQL语句不太熟悉,现有
CREATE TABLE [dbo].[tab_query_log](
[query_id] [nchar](25) NOT NULL,
[query_person] [nchar](20) NOT NULL,
[query_time] [datetime] NOT NULL,
[query_keys] [nchar](60) NOT NULL,
[item] [nchar](60) NULL,
[item_sub] [nchar](60) NULL,
[url] [nchar](512) NULL,
CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED
(
[query_time] DESC,
[query_id] ASC,
[query_person] ASC,
[query_keys] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
把它转换成Oracle语句怎么写?希望能把Oracle代码写下来谢谢
------解决方案--------------------
CREATE TABLE tab_query_log(
query_id nvarchar2(25) NOT NULL,
query_person nvarchar2(20) NOT NULL,
query_time DATE NOT NULL,
query_keys nvarchar2(60) NOT NULL,
item nvarchar2(60) NULL,
item_sub nvarchar2(60) NULL,
url nvarchar2(512) NULL,
CONSTRAINT PK_Table_1 PRIMARY KEY
(
query_time ,
query_id ,
query_person ,
query_keys
)
);