主页 / dba / 问题 / 124100
Accepted
ConfusedDeer
Asked: 2015-12-19 10:49:43 +0800 CST

在 Oracle SQL Developer 中，如何创建或更新过程并将模式名称设为变量：

  • 772

在 Oracle SQL Developer 中，如何创建或更新过程并将模式名称设为变量：

    define my_schema_name = 'schema_1';  


    CREATE OR REPLACE PROCEDURE my_schema_name.updateDBUSER(
         p_userid IN DBUSER.USER_ID%TYPE,
         p_username IN DBUSER.USERNAME%TYPE)
    IS
    BEGIN

      UPDATE DBUSER SET USERNAME = p_username where USER_ID = p_userid;

      COMMIT;

    END;
oracle oracle-sql-developer

1 个回答

  1. Best Answer
    define my_schema_name = 'SCHEMA_1';

CREATE OR REPLACE PROCEDURE "&my_schema_name".updateDBUSER(
     p_userid IN DBUSER.USER_ID%TYPE,
     p_username IN DBUSER.USERNAME%TYPE)
IS
BEGIN

  UPDATE DBUSER SET USERNAME = p_username where USER_ID = p_userid;

  COMMIT;

END;
    • 5

相关问题