create or replace
PROCEDURE TEST(V_STATE IN NUMBER,V_CAR_NUMBER IN VARCHAR2,V_CARD_NUMBER IN VARCHAR2)
AS
BEGIN
UPDATE
CARS
SET
CASE V_STATE
WHEN 1 THEN
STATE = 0;
WHEN 0 THEN
STATE = 1
END CASE
WHERE
CAR_ID =
(SELECT CAR_ID FROM CARS WHERE CAR_NUMBER= V_CAR_NUMBER);UPDATE
DRIVERS
SET
CASE V_STATE:
WHEN 1 THEN
STATE = 0
WHEN 0 THEN
STATE = 1
END CASE
WHERE
DRIVER_ID =
(SELECT DRIVER_ID FROM DRIVERS WHERE CARD_NUMBER=V_CARD_NUMBER);
INSERT INTO CONTACTS
VALUES(
LPAD(CONTACT_ID_SEQ.NEXTVAL,8,'0'),
(SELECT CAR_ID FROM CARS WHERE CAR_NUMBER= V_CAR_NUMBER),
(SELECT DRIVER_ID FROM DRIVERS WHERE CARD_NUMBER=V_CARD_NUMBER)
);
END;
PROCEDURE TEST(V_STATE IN NUMBER,V_CAR_NUMBER IN VARCHAR2,V_CARD_NUMBER IN VARCHAR2)
AS
BEGIN
UPDATE
CARS
SET
CASE V_STATE
WHEN 1 THEN
STATE = 0;
WHEN 0 THEN
STATE = 1
END CASE
WHERE
CAR_ID =
(SELECT CAR_ID FROM CARS WHERE CAR_NUMBER= V_CAR_NUMBER);UPDATE
DRIVERS
SET
CASE V_STATE:
WHEN 1 THEN
STATE = 0
WHEN 0 THEN
STATE = 1
END CASE
WHERE
DRIVER_ID =
(SELECT DRIVER_ID FROM DRIVERS WHERE CARD_NUMBER=V_CARD_NUMBER);
INSERT INTO CONTACTS
VALUES(
LPAD(CONTACT_ID_SEQ.NEXTVAL,8,'0'),
(SELECT CAR_ID FROM CARS WHERE CAR_NUMBER= V_CAR_NUMBER),
(SELECT DRIVER_ID FROM DRIVERS WHERE CARD_NUMBER=V_CARD_NUMBER)
);
END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货