Oracle（一）
时间：2021-07-01 10:21:17
帮助过：15人阅读
TABLE "
PUBLIC"."XXX"(
"ID" VARCHAR (
32)
NOT NULL ,
"NAME" VARCHAR (
200),
"PID" VARCHAR (
32),
"IF_DELETED" INTEGER,
"CREATE_TIME" DATETIME) WITHOUT OIDS
TABLESPACE "SYSTEM";
COMMENT ON TABLE "
PUBLIC"."XXX"
IS ‘xx表‘;
解决方案：
SELECT * FROM XXX WHERE IF_DELETED = 0 START WITH ID = ‘2‘ CONNECT BY PID = PRIOR ID
Oracle（一）
标签：ora sys varchar span com pid 迭代 nec null
