Statement st1=con.createStatement(); String sql="insert into employee values(emp_seq.nextval,'"+ename+"','"+eadd+"','"+ephone+"','"+email+"','"+department+"',"+Integer.parseInt(ebpay)+",20,0)";
-- hello sir,
This is the code i have in which i enter all d values except EID which is generated sequentially. But what i need is, the EID sequence number must be generated according to the department, i.e if department is CSE, the EID series must start with 10KT1 , and if the department is IT the eid sequence must start with 12GT1...
Thanq in advance..