数据湖探索 DLI-创建DLI表关联Oracle:语法格式

时间:2024-07-01 21:07:21

语法格式

1
2
3
4
5
6
7
8
9
CREATE TABLE [IF NOT EXISTS] TABLE_NAME
  USING ORACLE OPTIONS (
  'url'='xx',
  'driver'='DRIVER_NAME',
  'dbtable'='db_in_oracle.table_in_oracle',
  'user' = 'xxx',
  'password' = 'xxx',
  'resource' = 'obs://rest-authinfo/tools/oracle/driver/ojdbc6.jar' 
);
support.huaweicloud.com/sqlreference-dli/dli_08_0461.html