RE: Procedure for updating nulls [message #40343] |
Mon, 30 September 2002 10:02 |
premila
Messages: 10 Registered: September 2002
|
Junior Member |
|
|
i am performing data cleaning on a large badly designed database and many of records are null in some tables.
For example i have a table Customers which has the following fields
Create table Customers
(CustomerID varchar2(5),
CONSTRAINT customers_pk primary key(CustomerID),
CompanyName varchar2(40)CONSTRAINT cust_company_nn NOT NULL,
ContactName varchar2(30)CONSTRAINT cust_contactname_nn NOT NULL,
Address varchar2(60),
City varchar2(15) CONSTRAINT city_nn NOT NULL,
Region varchar2(15)CONSTRAINT region_nn NOT NULL,
Country Char(15)CONSTRAINT country_nn NOT NULL
);
it has some records where region, country and contactname are null. how do i write a procedure to update this table at once rather than updating a record a time using update statement.
Premila
|
|
|
|