sql plus for oracle . want help on sequence generator


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: sql plus for oracle . want help on sequence generator

  1. #1
    rahul saini Guest

    sql plus for oracle . want help on sequence generator


    how do i implement a sequence generator in oracle ?
    ----------------------------------------
    for validation what should be done :
    a "pre-insert" trigger
    or an "on insert" trigger ?
    -----------------------------------------



  2. #2
    Steve Jackson Guest

    Re: sql plus for oracle . want help on sequence generator

    Validation should be done in pre-insert trigger. If the validation
    fails, you can cancel the update.

    Steve Jackson

    On 14 May 2001 03:44:07 -0700, "rahul saini" <rahulsai@yahoo.com>
    wrote:

    >
    >how do i implement a sequence generator in oracle ?
    >----------------------------------------
    >for validation what should be done :
    > a "pre-insert" trigger
    > or an "on insert" trigger ?
    >-----------------------------------------
    >
    >



    Steve Jackson, Enterprise Section Leader
    stephenjackson@compuserve.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center