Answer / tharanath.n

NextVal is pseudo column, which gives you the unique number
in the sequence.
nextval increment the sequence and return new value.
currval can only be accessed in given session after at least
one nextval has been issued.

Answer / sreekanth

To get the next value of a sequence, we use nextval.


NextVal is pseudo column, which gives you the AVAILABLE
number in the sequence.
Remember the nextval value also depends on the cache you
have given, while creating the sequence.
If you want current value of a sequence you can use CurVal.
In a session you cannot use current value without getting
next value.
In 11g the you can use the nextval without using the query.
ie
select seq_name.nextval into ln_seqnextval from dual;
can be replaced by
ln_seqnextval := seq_name.nextval;

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers   jusco,

---

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

0 Answers  

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---

What background process refreshes materialized views?

1 Answers  

---

What is the sql query to find the employee who has Nth maximum salary?

2 Answers  

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

0 Answers  

---

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers   Cap Gemini,

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

0 Answers  

---

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

What is auto invoicing? : oracle accounts receivable

0 Answers  

---

whats the difference between join command and Cartesian product using example?

1 Answers  

---