Oracle Live SQL - Script: Que

Statement 1

create table hotel_reservation(Booking_id int(10), booking_start_date date, booking_end_date date, room_type varchar2(50), room_rent number(10))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 2

create table hotel_reservation  
(Booking_id int(10),  
booking_start_date date,  
booking_end_date date,  
room_type varchar2(50),  
room_rent number(10))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 3

create table hotel_reservation  
(Booking_id int(10),  
booking_start_date date,  
booking_end_date date,  
room_type varchar2(50),  
room_rent number(10))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 4

create table hotel_reservation  
(Booking_id int(10),  
booking_start_date number,  
booking_end_date number,  
room_type varchar2(50),  
room_rent number(10))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 5

create table hotel_reservation  
(Booking_id int(10),  
booking_start_date number,  
booking_end_date number,  
room_type varchar2(50),  
room_rent number(10))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 6

create table hotel_reservation  
( 
Booking_id int(10),  
booking_start_date date,  
booking_end_date date,  
room_type varchar2(50),  
room_rent number(10) 
)

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 7

create table hotelreservation  
( 
Booking_id int(10),  
booking_start_date date,  
booking_end_date date,  
room_type varchar2(50),  
room_rent number(10) 
)

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 8

create table stu(std number(10))

Table created.

Statement 9

create table hotel_reservation  
( 
booking_id int(10),  
booking_start_date date,  
booking_end_date date,  
room_type varchar2(50),  
room_rent number(10) 
)

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 10

create table hotel_reservation (booking_id int(20), booking_start_date date, booking_end_date date, room_type varchar2(50), room_rent int(20))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 11

create table hotel_reservation(booking_id int(20), booking_start_date number(20), booking_end_date number(20), room_type varchar2(50), room_rent int(20))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 12

create table hotel_reservation(booking_id number(20),booking_start_date number(20),booking_end_date number(20),room_type varchar2(50),room_rent number(20))

Table created.

Statement 13

drop table hotel_reservation

Table dropped.

Statement 14

create table hotel_reservation(booking_id number(20),booking_start_date date,booking_end_date date,room_type varchar2(50),room_rent number(20))

Table created.

Statement 15

insert into hotel_reservation(1, to_date('dd-mm-yyyy','10-5-2022'), to_date('dd-mm-yyyy','12-5-2022'), 'Double', 12000)

ORA-00928: missing SELECT keyword

More Details: https://docs.oracle.com/error-help/db/ora-00928

Statement 16

insert into hotel_reservation values(1, to_date('dd-mm-yyyy','10-5-2022'), to_date('dd-mm-yyyy','12-5-2022'), 'Double', 12000)

ORA-01821: date format not recognized ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01821

Statement 17

insert into hotel_reservation values(1, to_date('dd-mm-yyyy','10-05-2022'), to_date('dd-mm-yyyy','12-05-2022'), 'Double', 12000)

ORA-01821: date format not recognized ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01821

Statement 18

insert into hotel_reservation values(1, TO_DATE('10/05/2022', 'dd/mm/yyy'), TO_DATE('12/05/2022', 'dd/mm/yyy'), 'Double', 12000)

ORA-01830: date format picture ends before converting entire input string ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01830

Statement 19

insert into hotel_reservation values(1, TO_DATE('10-05-2022', 'dd-mm-yyyy'), TO_DATE('12-05-2022', 'dd-mm-yyyy'), 'Double', 12000)

1 row(s) inserted.

Statement 20

insert into hotel_reservation values(2, TO_DATE('21-07-2022', 'dd-mm-yyyy'), TO_DATE('25-07-2022', 'dd-mm-yyyy'), 'Single', 5000)

1 row(s) inserted.

Statement 21

insert into hotel_reservation values(3, TO_DATE('01-02-2022', 'dd-mm-yyyy'), TO_DATE('02-02-2022', 'dd-mm-yyyy'), 'Luxury', 30000)

1 row(s) inserted.

Statement 22

insert into hotel_reservation values(4, TO_DATE('30-06-2022', 'dd-mm-yyyy'), TO_DATE('01-07-2022', 'dd-mm-yyyy'), 'Double', 10000)

1 row(s) inserted.

Statement 23

insert into hotel_reservation values(5, TO_DATE('15-10-2022', 'dd-mm-yyyy'), TO_DATE('15-10-2022', 'dd-mm-yyyy'), 'Quad', 11000)

1 row(s) inserted.

Statement 24

select * from hotel_reservation


BOOKING_ID BOOKING_START_DATE BOOKING_END_DATE ROOM_TYPE ROOM_RENT
1 10-MAY-22 12-MAY-22 Double 12000
2 21-JUL-22 25-JUL-22 Single 5000
3 01-FEB-22 02-FEB-22 Luxury 30000
4 30-JUN-22 01-JUL-22 Double 10000
5 15-OCT-22 15-OCT-22 Quad 11000

5 rows selected.

BOOKING_ID	BOOKING_START_DATE	BOOKING_END_DATE	ROOM_TYPE	ROOM_RENT
1	10-MAY-22	12-MAY-22	Double	12000
2	21-JUL-22	25-JUL-22	Single	5000
3	01-FEB-22	02-FEB-22	Luxury	30000
4	30-JUN-22	01-JUL-22	Double	10000
5	15-OCT-22	15-OCT-22	Quad	11000

Statement 25

DECLARE 
 book_id hotel_reservation.booking_id%type; 
 book_sdate hotel_reservation.booking_start_date%type := TO_DATE('10-05-2022', 'dd-mm-yyyy'); 
 book_edate hotel_reservation.booking_end_date%type := TO_DATE('15-10-2022', 'dd-mm-yyyy'); 
 r_type hotel_reservation.room_type%type; 
 r_rent hotel_reservation.room_rent%type; 
  
BEGIN 
 Select booking_id,booking_start_date,booking_end_date,room_type,room_rent INTO book_id, book_sdate, book_edate,r_type,r_rent FROM hotel_reservation WHERE booking_start_date = book_sdate or booking_end_date = book_edate; 
  
 dbms_output.put_line('hotel_reservation ' || book_id || book_sdate || book_edate || r_type || r_rent); 
  
END;

ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 9
ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01422

Statement 26

Select booking_id,booking_start_date,booking_end_date,room_type,room_rent INTO book_id, book_sdate, book_edate,r_type,r_rent FROM hotel_reservation WHERE booking_start_date = book_sdate

ORA-00904: "BOOK_SDATE": invalid identifier

More Details: https://docs.oracle.com/error-help/db/ora-00904

Statement 27

DECLARE 
 book_id hotel_reservation.booking_id%type; 
 book_sdate hotel_reservation.booking_start_date%type := TO_DATE('10-05-2022', 'dd-mm-yyyy'); 
 book_edate hotel_reservation.booking_end_date%type := TO_DATE('15-10-2022', 'dd-mm-yyyy'); 
 r_type hotel_reservation.room_type%type; 
 r_rent hotel_reservation.room_rent%type; 
  
BEGIN 
 Select booking_id,booking_start_date,booking_end_date,room_type,room_rent INTO book_id, book_sdate, book_edate,r_type,r_rent FROM hotel_reservation WHERE booking_start_date = book_sdate; 
  
 dbms_output.put_line('hotel_reservation ' || book_id || book_sdate || book_edate || r_type || r_rent); 
  
END;

Statement processed.
hotel_reservation 110-MAY-2212-MAY-22Double12000

Statement 28

DECLARE 
 book_id hotel_reservation.booking_id%type; 
 book_sdate hotel_reservation.booking_start_date%type := TO_DATE('10-05-2022', 'dd-mm-yyyy'); 
 book_edate hotel_reservation.booking_end_date%type := TO_DATE('15-10-2022', 'dd-mm-yyyy'); 
 r_type hotel_reservation.room_type%type; 
 r_rent hotel_reservation.room_rent%type; 
  
BEGIN 
 Select booking_id,booking_start_date,booking_end_date,room_type,room_rent INTO book_id, book_sdate, book_edate,r_type,r_rent FROM hotel_reservation WHERE booking_start_date = book_sdate; 
  
 dbms_output.put_line('hotel_reservation ' || book_id ||  ' ' || book_sdate || ' ' || book_edate || ' ' || r_type || ' ' || r_rent); 
  
END;

Statement processed.
hotel_reservation 1 10-MAY-22 12-MAY-22 Double 12000

Statement 29

DECLARE 
 book_id hotel_reservation.booking_id%type; 
 book_sdate hotel_reservation.booking_start_date%type := TO_DATE('10-05-2022', 'dd-mm-yyyy'); 
 book_edate hotel_reservation.booking_end_date%type := TO_DATE('15-10-2022', 'dd-mm-yyyy'); 
 r_type hotel_reservation.room_type%type; 
 r_rent hotel_reservation.room_rent%type; 
  
BEGIN 
 Select booking_id,booking_start_date,booking_end_date,room_type,room_rent INTO book_id, book_sdate, book_edate,r_type,r_rent FROM hotel_reservation WHERE booking_start_date = book_sdate 
 (Select booking_id,booking_start_date,booking_end_date,room_type,room_rent INTO book_id, book_sdate, book_edate,r_type,r_rent FROM hotel_reservation WHERE booking_end_date = book_edate); 
  
 dbms_output.put_line('hotel_reservation ' || book_id ||  ' ' || book_sdate || ' ' || book_edate || ' ' || r_type || ' ' || r_rent); 
  
END;

ORA-06550: line 10, column 3:
PL/SQL: ORA-00936: missing expression

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 30

DECLARE 
 book_id hotel_reservation.booking_id%type; 
 book_sdate hotel_reservation.booking_start_date%type := TO_DATE('10-05-2022', 'dd-mm-yyyy'); 
 book_edate hotel_reservation.booking_end_date%type := TO_DATE('15-10-2022', 'dd-mm-yyyy'); 
 r_type hotel_reservation.room_type%type; 
 r_rent hotel_reservation.room_rent%type; 
  
BEGIN 
 Select booking_id,booking_start_date,booking_end_date,room_type,room_rent INTO book_id, book_sdate, book_edate,r_type,r_rent FROM hotel_reservation WHERE booking_start_date = book_sdate in 
 (Select booking_id,booking_start_date,booking_end_date,room_type,room_rent INTO book_id, book_sdate, book_edate,r_type,r_rent FROM hotel_reservation WHERE booking_end_date = book_edate); 
  
 dbms_output.put_line('hotel_reservation ' || book_id ||  ' ' || book_sdate || ' ' || book_edate || ' ' || r_type || ' ' || r_rent); 
  
END;

ORA-06550: line 9, column 188:
PL/SQL: ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 31

DECLARE 
 book_id hotel_reservation.booking_id%type; 
 book_sdate hotel_reservation.booking_start_date%type := TO_DATE('10-05-2022', 'dd-mm-yyyy'); 
 book_edate hotel_reservation.booking_end_date%type := TO_DATE('15-10-2022', 'dd-mm-yyyy'); 
 r_type hotel_reservation.room_type%type; 
 r_rent hotel_reservation.room_rent%type; 
  
BEGIN 
 Select booking_id,booking_start_date,booking_end_date,room_type,room_rent INTO book_id, book_sdate, book_edate,r_type,r_rent FROM hotel_reservation WHERE booking_start_date = book_sdate; 
  
 dbms_output.put_line('hotel_reservation ' || book_id ||  ' ' || book_sdate || ' ' || book_edate || ' ' || r_type || ' ' || r_rent); 
  
END;

Statement processed.
hotel_reservation 1 10-MAY-22 12-MAY-22 Double 12000

Que - 2

Additional Information