posted 20 years ago
Hi all,
This is an SOS.
I am writing a trigger on table CUSTOMER whoch has a column ACCOUNTNUMBER.
I want to write a trigger such that if the ACCOUNTNUMBER is already present in he tbale, i want to append 'A' to the accountnumber and then insert it.
for eg: ACCOUNTNUMBER 123 already exists iin the table
when i try to insert again , in trigger shud make it as '123A'
again itf i try to insert it shud increment the alphabet and insert it as '123B'. till 'Z'.
How can i go about doing this..
pls help me sson as i have a deadline to meet. and i am new to oracle...
Thanx in advance
Chhaya