在SQL编写的过程中要注意,DM是不支持create table xxx( 列1 ,列2…) as select …的模式
要改造成create table xxx as select …as 列1,…as 列2…这样的模式。这个模式无论DM还是Oralce都支持,就不会报错了。
以下语句在Oracle是OK的,在DM不支持
DROP TABLE t1;
CREATE TABLE t1 (id, col1, col2, pad)
AS
SELECT rownum, CASE WHEN rownum>5000 THEN 666 ELSE rownum END, rownum, lpad(’’,100,’’)
FROM dual
CONNECT BY level <= 10000;
连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> DROP TABLE t1;
表已删除。
SQL> CREATE TABLE t1 (id, col1, col2, pad)
2 AS
3 SELECT rownum, CASE WHEN rownum>5000 THEN 666 ELSE rownum END, rownum, lpad(’’,100,’’)
4 FROM dual
5 CONNECT BY level <= 10000;
表已创建。
disql V7.6.0.96-Build(2018.09.19-97292)ENT
Connected to: DM 7.1.6.96
SQL> DROP TABLE t1;
DROP TABLE t1;