Cngine

数据库设计：CREATE  TABLE  ADVERTISE_CATEGORY(       CATEGORY_ID       NUMBER PRIMARY KEY,  --节点ID         CATEGORY_NAME     VARCHAR2(500),       --节点名字         PARENT_ID         NUMBER                   

解决办法：以sysdba的身份登录，然后在sql plus 上执行   alter user quota unlimited on users;

declare cursor myCursor is select * from 表名;myRow myCursor%rowtype;begin open myCursor; loop fetch myCursor into myRow; exit when myCursor%notfound; --要执行的