Home » SQL & PL/SQL » SQL & PL/SQL » explain this
explain this [message #223159] Wed, 07 March 2007 15:45 Go to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

please explain this query
select s.currval,s.nextval,s.nextval from dual .
all are returning same values . why?

[Updated on: Wed, 07 March 2007 16:06]

Report message to a moderator

Re: explain this [message #223162 is a reply to message #223159] Wed, 07 March 2007 16:45 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Just read Oracle docs:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/pseudocolumns002.htm

Gints Plivna
http://www.gplivna.eu
Previous Topic: pls help utl_smtp package
Next Topic: Truncate table issue
Goto Forum:
  


Current Time: Sun Dec 04 18:51:48 CST 2016

Total time taken to generate the page: 0.07340 seconds