CREATE TABLE booking_chart  ( book_code     NUMBER
                            , firm_code     NUMBER
                            , firm_name     VARCHAR2(300)
                            , source_one    VARCHAR2(200)
                            , to_desti      VARCHAR2(200)
                            , source_two    VARCHAR2(200)
                            , book_date     DATE
                            , serial_no     NUMBER(10)
                            , seat_no       VARCHAR2(100)
                            , total_seats   VARCHAR2(100)
                            , luggage       VARCHAR2(200)
                            , location      VARCHAR2(200)
                            , amount        NUMBER(10,2)
                            , total_amount  NUMBER(10,2)
                            , CONSTRAINT firm_code_fk FOREIGN KEY (firm_code) REFERENCES firm_info (firm_code) ON DELETE CASCADE
                            )

SELECT  book_code, firm_name, source_one, to_desti, source_two, book_date, serial_no, seat_no, total_seats, luggage, location, amount, total_amount
FROM    booking_chart

1  AXEL BLAZE 	NEY YORK 	LONDON 	NEY YORK 	16-Jan-2014	1	10 	60 	YES NEW YORK 1000	23000
1  AXEL BLAZE 	NEY YORK 	LONDON 	NEY YORK 	16-Jan-2014	2	20 	60 	YES NEW YORK 1000	23000
1  AXEL BLAZE 	NEY YORK 	LONDON 	NEY YORK 	16-Jan-2014	3	30 	60 	YES LONDON   3000	23000
1  AXEL BLAZE 	NEY YORK 	LONDON 	NEY YORK 	16-Jan-2014	4	40 	60 	NO  LONDON   3000	23000

FOR i IN first_rec..last_rec
LOOP
    IF :BOOKING_INFO.serial_no IS NOT NULL
	THEN
	    UPDATE    booking_chart
	    SET       book_code			=	:BOOKING_CHART.book_code
		    , firm_code			=	:BOOKING_CHART.firm_code
		    , firm_name			=	:BOOKING_CHART.firm_name
		    , source_one		=	:BOOKING_CHART.source_one
		    , to_desti			=	:BOOKING_CHART.to_desti
		    , source_two		=	:BOOKING_CHART.source_two
		    , book_date			=	:BOOKING_CHART.man_no
		    , serial_no			=	:BOOKING_INFO.serial_no
		    , seat_no			=	:BOOKING_INFO.seat_no
		    , total_seats		=	:BOOKING_INFO.total_seats
		    , luggage			=	:BOOKING_INFO.luggage
		    , location			=	:BOOKING_INFO.location
		    , amount			=	:BOOKING_INFO.amount
		    , total_amount       	=	:BOOKING_CHART.total_amount
	   WHERE      book_code			=	:BOOKING_CHART.book_code
	   [color=red]AND	      serial_no			=       :BOOKING_INFO.serial_no[/color];
	   next_record;
	END IF;
END LOOP;