本文共 1644 字，大约阅读时间需要 5 分钟。

Oracle CRM ?????????

1. ?????????

? Oracle CRM ????????????????????????????????????????????????

2. ???????????

????????????????????????????????????????????

CREATE TABLE tmp_cust_city (    customer_id NUMBER(8) NOT NULL,    city_name VARCHAR2(10) NOT NULL,    customer_type CHAR(2) NOT NULL);

3. ???????

3.1 ????

?? WHERE ?????????

UPDATE customers SET city_name = '??'WHERE customer_id < 1000;

3.2 ?????

???????????????????????

UPDATE customers SET city_name = (SELECT b.city_name                 FROM tmp_cust_city b                 WHERE b.customer_id = customers.customer_id)WHERE EXISTS (    SELECT 1     FROM tmp_cust_city b     WHERE b.customer_id = customers.customer_id);

4. ???????

??????????? FOR UPDATE ????

UPDATE customers aSET city_name = (SELECT b.city_name                 FROM tmp_cust_city b                 WHERE b.customer_id = a.customer_id)WHERE EXISTS (    SELECT 1     FROM tmp_cust_city b     WHERE b.customer_id = a.customer_id);

5. PLSQL ???????

?????????????????

CREATE OR REPLACE PROCEDURE update_city(    customer_id IN NUMBER)IS    BEGIN        UPDATE customers         SET city_name = (SELECT b.city_name                         FROM tmp_cust_city b                         WHERE b.customer_id = customer_id)        WHERE customer_id = customer_id;    END;

6. ????????

????????????????????????????

CREATE CONSTRAINT pk_customers ON (customer_id) PRIMARY KEY (customer_id);

7. ????

???????

SELECT * FROM tmp_cust_city WHERE customer_id = 1000;

8. ????

?? ROWNUM ?????????

SELECT b.city_name FROM tmp_cust_city b WHERE b.customer_id = a.customer_idAND ROWNUM = 1;

?????????????? Oracle CRM ????????????????????????