One question,
How exactly does this relate to Servlets?
Just commenting,
Lambert
>>> [EMAIL PROTECTED] 03/10/2003 16:57:54 >>>
Please use SEQUENCE. You need to have DBA privilege to create this.
Syntax is:
CREATE SEQUENCE seq_name
START WITH 1
INCREMENT BY 1
NOMINVALUE
MAXVALUE 1.000E+27
NOCYCLE
NOCACHE
ORDER
/
In your query, you can get next value like this:
SELECT seq_name.NEXTVAL FROM DUAL;
Or if you need this value to be inserted to your data table...
INSERT INTO data_table (column1, column2) VALUES(seq_name.NEXTVAL,
"some
value");
David
-----Original Message-----
From: shashi kanth goud [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 4:39 AM
To: [EMAIL PROTECTED]
Subject: Re: help regarding oracle
hi everybody,
iam working on oracle 7 . i want to use auto counter field in oracle
can
anyone tell me how to do it????
thanx in advance
Regards
Shashi
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
------------------------------------------------------------------------------
This email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone
else,
unless expressly approved by the sender or an authorized addressee, is
unauthorized.
If you are not the intended recipient, any disclosure, copying,
distribution
or any action omitted or taken in reliance on it, is prohibited and may
be
unlawful. If you believe that you have received this email in error,
please
contact the sender, delete this e-mail and destroy all copies.
==============================================================================
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
***********************************************************************
This transmission contains information which may be confidential and
which may also be privileged. It is intended for the named addressee
only. Unless you are the named addressee, or authorised to receive it
on behalf of the addressee you may not copy or use it, or disclose it
to anyone else. If you have received this transmission in error please
contact the sender. Thank you for your cooperation.
***********************************************************************
For more information about AEA Technology please visit our website at
http://www.aeat.co.uk
AEA Technology plc registered office 329 Harwell, Didcot, Oxfordshire OX11 0QJ.
Registered in England and Wales, number 3095862.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
