Home » RDBMS Server » Server Administration » appending 2 digits from year to sequence number.....
appending 2 digits from year to sequence number..... [message #371642] Sat, 18 November 2000 12:03
R . Pope
Messages: 1
Registered: November 2000
Junior Member
Hi All,

Is there a way to append the last two digits of the current year (YY) to the front of a sequence generate column, and store this column in a table. This sequence number is used by a before insert trigger?

Thanks for any Help......

Report message to a moderator

Previous Topic: Top x records
Next Topic: anchored definition in type declaration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 22:15:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.