Hi It may be a basic question.. but I am unable to find any answer for this..
I have a table Employee which have a column Emp_id,Emp_name and salary where Emp_id is primary key.
My Problem is My Emp_id should be like <CompanyName><SequenceNo> (eg. 'JAVA1','JAVA2','JAVA3') like this.
How to create this sequence?
Thanks & Regards,
Raj
I have a table Employee which have a column Emp_id,Emp_name and salary where Emp_id is primary key.
My Problem is My Emp_id should be like <CompanyName><SequenceNo> (eg. 'JAVA1','JAVA2','JAVA3') like this.
How to create this sequence?
Thanks & Regards,
Raj