OraFAQ Forum: SQL & PL/SQL » generate sequence

Home » SQL & PL/SQL » SQL & PL/SQL » generate sequence

Wed, 15 May 2002 01:15

ranjan kumar dash
Messages: 15
Registered: February 2002

Junior Member

after creating sequence in sql prompt what i should do to generate the serial number in form level.

Wed, 15 May 2002 02:05

sharma
Messages: 10
Registered: February 2002

Junior Member

hi..

xyz:=<sequence_name>.nextval

will give u next generated value of sequence..

cheers
sharma.

Previous Topic:	ORA-01455 Converting column overflows integer datatype
Next Topic:	wild card filtering

Goto Forum:

]

Current Time: Fri Apr 26 17:25:07 CDT 2024