create table booking_detail
(
booking_id varchar2(10) primary key,
room_id varchar2(10),
cust_id varchar2(10) references customer_detail(cust_id),
checkin_date date,
checkout_date date,
total_amount int
);
--- This is my booking table and how can i write query for it ?
--- How can i use "EXTRACT()" function to retrieve it.