CREATE TABLE ORGANIZATION_DETAILS
(ORG_KEY NUMBER,
ORG_NAME VARCHAR2(20)
)
Table created.
INSERT INTO ORGANIZATION_DETAILS VALUES
(1,'ORG_A'
)
1 row(s) inserted.
INSERT INTO ORGANIZATION_DETAILS VALUES
(2,'ORG_B'
)
1 row(s) inserted.
INSERT INTO ORGANIZATION_DETAILS VALUES
(3,'ORG_C'
)
1 row(s) inserted.
SELECT * FROM ORGANIZATION_DETAILS
ORG_KEY | ORG_NAME | 1 | ORG_A | 2 | ORG_B | 3 | ORG_C |
---|
CREATE OR REPLACE PROCEDURE PROC_UPDATE_ORG_DETAILS(
in_org_key NUMBER,
in_new_org_name VARCHAR2)
AS
BEGIN
UPDATE ORGANIZATION_DETAILS
SET ORG_NAME = in_new_org_name
WHERE ORG_KEY = in_org_key;
COMMIT;
END;
Procedure created.
EXEC PROC_UPDATE_ORG_DETAILS(1,'NEW_ORG_A')
Statement processed.
select * from organization_details
ORG_KEY | ORG_NAME | 1 | new_org_a | 2 | ORG_B | 3 | ORG_C |
---|