Create a sequence to add room IDs and then insert a new room into LOCATION table using the newly created sequence. What is the CURRVAL after the new row is inserted?

Question

Use case study databases for the following queries.

Answer 1

```
SQL> CREATE SEQUENCE LOCATION_ROOMID_SEQ
2 START WITH 22
3 MAXVALUE 99
4 NOCACHE;

SEQUENCE CREATED.

SQL> INSERT INTO LOCATION
2 VALUES (LOCATION_ROOMID_SEQ.NEXTVAL, 'NEHRU', 311, 50, 'C');

1 ROW CREATED.

SQL> SELECT LOCATION_ROOMID_SEQ.CURRVAL
2 FROM DUAL;

CURRVAL
----------
22
```