Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to user sequence numbers uniquely
Hi I can create sequence numbers for a table. But i want to create a sequence
number which is unique on a daily basis. Suppose i am assiging a customer
mr.xyz an id then the sequence number should be generated as xyz090398 ie it
should have todays date,month and year . Can some one help me generating this
kind of sequencenumber.If you are able to give sample code it will be nice of
you Thanks in advance. Maadhavan
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 03 1998 - 10:41:15 CDT