Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to user sequence numbers uniquely

How to user sequence numbers uniquely

From: <maadhav_at_yahoo.com>
Date: Thu, 03 Sep 1998 15:41:15 GMT
Message-ID: <6smdat$lmg$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US