Hello Folks,
I have to create logic to generate 15 character alphanumeric id in this format during INSERT SQL:
For example first inseted row will have ID as OFFR11021600001,next can be OFFR13021600002 .
Hi,
Please refer the below link on generating the Sequential numbers Teradata.
You can concatenate the static text 'OFFR' & date along with that.
Thanks Guys!!!!!