insert next number of primary key
Hi
I have the table students that containing the columns stud_id number as primary key,stud_no as number, and stud_name as varchar2 datatype
I need a pl/sql code used with form builder that automatically insert the next number of primary key
when I want to insert a new record
e.g if the sql>select count(*) from students;
the result= 11 means there is 11 students
the code so enters 12 as new stud_id number then I will complete the record manually.
I will begin from number one
thanks
Windows OS
oracle 10g database
oracle form builder 6i builder