hi ,
i want to know how to automatically generate a roll no from the oracle table(roll no,name, etc ..) ,when i am filling a form(a roll no is already assigned) . also the steps required to connect to oracle database using jdbc & jsp .
-
automatically generation the roll number (3 messages)
- Posted by: anuj singh
- Posted on: May 24 2001 16:00 EDT
Threaded Messages (3)
- automatically generation the roll number by Deepak Yinti on May 24 2001 16:21 EDT
- automatically generation the roll number by sukhbir bhavra on May 25 2001 01:39 EDT
- automatically generation the roll number by kiran killedar on May 25 2001 07:45 EDT
-
automatically generation the roll number[ Go to top ]
- Posted by: Deepak Yinti
- Posted on: May 24 2001 16:21 EDT
- in response to anuj singh
Do you need to generate sequence number for the oracle ...explain clearly what type of roll number do you want.Regarding JDBC connection go to any tutorial u will get the code to connect to the database..if still not able to do it..then let me know ..I will send you the code -
automatically generation the roll number[ Go to top ]
- Posted by: sukhbir bhavra
- Posted on: May 25 2001 01:39 EDT
- in response to anuj singh
hi, please try to use sequences in oracle and in the insert statement you have to use sequencename.nextval to generate the next number.
bye -
automatically generation the roll number[ Go to top ]
- Posted by: kiran killedar
- Posted on: May 25 2001 07:45 EDT
- in response to sukhbir bhavra
U can create a sequence & on the trigger on insert in that use the sequence & update the roll number field.
cheer's
bye
-kiran