[创建表] MS SQL到oracle [英] [Create table] MS SQL to oracle

问题描述

您好。



请在sql语句下更改为Oracle语法。



谢谢。



---------------------------------- -------------------------------------



CREATE TABLE [dbo]。[E_QUALITY_IF]

（

... //创建一些字段

CONSTRAINT [PK_E_QUALITY_IF] PRIMARY KEY

CLUSTERED

（

[PROD_DT] ASC，[LOG_SEQ] ASC

）

WITH

（

PAD_INDEX = OFF

）

ON [PRIMARY]

）

ON [主要]



------------------ -------------------------------------------------- -



我的尝试：



我直接写了到Oracle表创建语句。



然而，它涉及到Bonnie没有在句子中执行错误的各种约束。

解决方案

< blockquote>首先尝试阅读文档：

Oracle / PLSQL：CREATE TABLE语句 [ ^ ]

Oracle - SQL - 创建表 [ ^ ]

Hello.

Please change under the sql statement to Oracle syntax.

Thank you.

-----------------------------------------------------------------------

CREATE TABLE [dbo].[E_QUALITY_IF]
(
...//create some fields
CONSTRAINT [PK_E_QUALITY_IF] PRIMARY KEY
CLUSTERED
(
[PROD_DT] ASC, [LOG_SEQ] ASC
)
WITH
(
PAD_INDEX = OFF
)
ON [PRIMARY]
)
ON [PRIMARY]

----------------------------------------------------------------------

What I have tried:

I had written directly to the Oracle table creation statements.

However, it involves various constraints on Bonnie did not execute an error in the sentence blossomed.

解决方案

Try reading the documentation first :
Oracle / PLSQL: CREATE TABLE Statement[^]
Oracle - SQL - Create a Table[^]

这篇关于[创建表] MS SQL到oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！