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
```
You might also like to view...
You use the ____ method to convert a string to uppercase.
A. ConvToUpper B. strUpper C. ToUpper D. ConvUpper
What is described by a runtime complexity of O(1)?
a. Algorithm efficiency is independent of the problem size, and is the fastest b. There is a limit on performance c. Memory use is inefficient d. Constant 1 needs to be removed
Give a command for viewing the size of your home directory?Give a command for displaying the sizes of all the files in your home directory
What will be an ideal response?
Sharing photos on the Web can be done privately or publicly, depending on your goal.
Answer the following statement true (T) or false (F)