lightdb获取建表ddl

select dbms_metadata.get_ddl('table', 'act_hi_identitylink','etfpub');

CREATE  TABLE etfpub.act_hi_identitylink (
  id_ character varying(64) NOT NULL,
  group_id_ character varying(255) NULL,
  type_ character varying(255) NULL,
  user_id_ character varying(255) NULL,
  task_id_ character varying(64) NULL,
  proc_inst_id_ character varying(64) NULL
) TABLESPACE pg_default;

该特性不要求当前数据库或实例运行在oracle模式下。

http://www.light-pg.com/docs/lightdb/13.8-22.3/orafce.html