关于plsql的cursor

cursor through_tkt_cursor(through_booking_id varchar2) is
select ttt_booking_id,
ttt_ticket_no,
ttt_location_cd,
ttt_cinema_cd,
ttt_film_cd,
to_char(ttt_show_dt, 'yyyy-mm-dd') ttt_show_dt,
ttt_sho_seq_no,
ttt_showtime,
ttt_through_id,
ttt_through_seq_no,
ttt_through_flg,
ttt_tkt_seq_no,
ttt_section_id,
ttt_row_id,
ttt_column_id,
ttt_price_type,
ttt_price_amt,
ttt_through_price
from GV_TEMP_THROUGH_TKT
where ttt_booking_id = through_booking_id
order by ttt_through_seq_no, ttt_tkt_seq_no;

今天在看其他人写的包 才发现cursor也可以放参数进去的! 
 

 

posted @ 2012-02-10 11:14  lavandachen  阅读(193)  评论(0编辑  收藏  举报