Solved

_seq.nextval from dual

Posted on 2004-10-14
3
2,089 Views
Last Modified: 2013-12-01
hi!

can anyone explain the following second sql statement?


      private PreparedStatement selectSequencePs;      
      
      private String selectSequence = "select assess_test_id_seq.nextval from dual";

thanks,
0
Comment
Question by:dkim18
3 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 100 total points
ID: 12316382
It is a sequence. It is used for generating values. Here you can read all about it (the registration is free):
http://www.oracle.com/pls/tahiti/tahiti.tabbed?section=74579
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now