Oracle（一）

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