关于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也可以放参数进去的！ 
 

 

转载于:https://www.cnblogs.com/lavandachen/articles/2345029.html