how geerate a number ac001,bc001,dc002,ac002,bc002 etc....
913349May 20 2013 — edited May 20 2013Dear All,
i am using 11.1.2.1.0 version,
i have master table having two column like file id, file type(values ac,bc,dc) , i made the file type as list of values and detail table having file no, file name
my question is if select file type ac and create a new record in detail table ,after saving the record file no should generate like this ac001,similarly if i select bc and if i create detail it should come like this bc001
here i created three sequence for ac, bc and dc then how i will get number like ac001 based on list of values i m not getting idea please help me.
Thanks
Damby