Re: newbie oracle functions

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 8 Nov 2006 03:22:40 -0800
Message-ID: <1162984960.447296.269090@b28g2000cwb.googlegroups.com>

sosa48_at_hotmail.com wrote:
> I am fairly new to wrinting functions in oracle and I need help in
> writing a function to increment a column called Num by 5.
> If anyone can please help, I would really appreciate it.
>
> Thanks in advance,
> Jenny

Fortunately, that feature is built into Oracle - this feature is a sequence. Syntax to create the sequence: CREATE SEQUENCE customes_seq_no START WITH 1 INCREMENT BY 5;

See this page for details:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/views.htm#i1007824

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Wed Nov 08 2006 - 05:22:40 CST