Need help quick!!
From: Flea <nomadeflea_at_yahoo.fr>
Date: 26 Jan 2003 08:37:31 -0800
Message-ID: <24083942.0301260837.513771c1_at_posting.google.com>
, CONSTRAINT PK_CLIENT PRIMARY KEY (CODE_CLIENT) ) ;
Date: 26 Jan 2003 08:37:31 -0800
Message-ID: <24083942.0301260837.513771c1_at_posting.google.com>
Hi,
New to pl/sql, I need some help fast!!
I would like to create a procedure, simply to make an update of a new
client:
I would like to create a new client, adding his name, surname, adresse
and telephone, and to raise exceptions, if I type the wrong data in
the wrong field, for instance:
I have already created my table:
CREATE TABLE CLIENT
(
CODE_CLIENT NUMBER(10) NOT NULL,
NAME VARCHAR2(15) NULL,
SURNAME VARCHAR2(15) NULL, ADRESSE VARCHAR2(30) NULL, TELEPHONE NUMBER(12) NOT NULL
, CONSTRAINT PK_CLIENT PRIMARY KEY (CODE_CLIENT) ) ;
I am just not sure of what
How should my procedure be constructed?
What should I put in?
Please help!
Received on Sun Jan 26 2003 - 17:37:31 CET