Examine the following statement:
SELECT empno_seq.CURRVAL FROM SYS.dual;
Which of the following values is displayed?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- The following command was issued: SELECT emp_id_seq.CURRVAL FROM SYS.dual; Which value is displayed?
- The following statements are executed: create sequence my_seq; select my_seq.nextval from dual; select my_s...
- I have just now created sequence abc and If you immediately run the below select statement , what is the ou...
- What is returned from the query SELECT NVL2(NULL,'V1','V2') from DUAL;
- Which of the following is not a database object?
- What is the output of the below query? select rowid from dual
- select nvl2(exp1,exp2,exp3) from dual. In this if exp1 is null,what will be the output?
- Output of the below two queries will be same.. 1.select nvl('abc','a') from dual; 2.select nvl('abc',0) fro...