DELCARE TYPE stock_quote_rec IS RECORD (symbol
stock.symbol%TYPE ,bid NUMBER(10,4) ,ask
NUMBER(10,4) ,volume NUMBER NOT NULL:=0 ,exchange VARCHAR2(6)
DEFAULT 'NASDAQ' );
CURSOR
xactions_cur(acct_no IN VARCHAR2) IS SELECT
action,timestamp,holding FROM portfolios WHERE
account_nbr='acct_no' ; xaction_info
xactions_cur%ROWTYPE; variable 有一些PL/SQL指令在使用隐式定义记录时没有使用%ROWTYPE属性,比如游标FOR循环或触发器中的:old和:new记录。
DELCARE
CURSOR xaction_cur IS SELECT
action,timeamp,holding FROM portfolios WHERE
account_nbr='37' ;
BEGIN FOR xaction_rec in
xactions_cur LOOP IF
xactions_rec.holding='ORCL' THEN notify_shareholder; END
IF; END LOOP;