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?
Use case study databases for the following queries.
```
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
```
Computer Science & Information Technology
You might also like to view...
The ____ function determines the lowest number in a range.
A. MAX B. AVERAGE C. SUM D. MIN
Computer Science & Information Technology
_____ is designed to exchange and transport data.?
A. ?Extensible Markup Language (XML) B. ?JavaScript C. ?Unified Modeling Language (UML) D. ?Practical Extraction and Report Language (PERL)
Computer Science & Information Technology