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 -> generate unique sequence number

generate unique sequence number

From: <jtrxt_at_my-dejanews.com>
Date: Wed, 29 Jul 1998 22:12:13 GMT
Message-ID: <6po6nu$qe6$1@nnrp1.dejanews.com>


I'm trying to automatically generate a unique sequence number using forms 4.5.

Under the text items property I've set the default value to :sequence.column_name.nextval.

Next, I believe I create a trigger with the built-in generate_sequence_number.

I'm doing something wrong. Can anyone provide detailed step-by-step directions?

TIA -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 17:12:13 CDT

Original text of this message

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