I have a database created in Oracle using TOAD, I want to know if anyone knows how to make a column(primary key) auto-increase. The column datatype is char and I want to know if its possible to insert values like AB001 and anytime a new record is inserted the last three digits will be increased by one. ie. first reocrds has the id AB001, next record will have ID AB002 and so on.
If this is not possible how can it be done with numeric datatype (remember I'm using Toad), I know is MSSQL there is auto-inrease datatype.