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 -> ideas for 'standard table code'

ideas for 'standard table code'

From: Alan Mills <Alan.Mills_at_nospamservices.fujitsu.com>
Date: Wed, 30 Oct 2002 15:53:38 -0000
Message-ID: <apovaf$2gt$1@news.icl.se>


Work is a little light at the moment and so I intend to keep my eye in my producing a routine to build standard code based on existing table definitions in the schema.

I'm sure there are likely many such scripts already but I want to do this myself as an exercise (for the main part).

I'm wondering what standard routines people would find useful, to be autogenerated.

I'm thinking along the following lines but what else would people like to see.

Tables


  1. Function to check record instance based on each unique key defined; and
  2. Function/procedure to retrieve full record based on each unique key defined;

Also, for sequences...

Sequences


  1. Function to retrieve next value for sequence; and
  2. fucntion to retrieve last value for each sequence.
Received on Wed Oct 30 2002 - 09:53:38 CST

Original text of this message

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