定义存储过程如下:

定义存储过程如下:

 

CREATE OR REPLACE PROCEDURE INSERT_TEAM

 

(V_ID in NUMBER,V_CITY in VARCHER2 DEFAULT ‘AUSTIN’, V_NAME

 

in VARCHER2)

 

IS

 

BEGIN

 

INSERT INTO TEAM (id, city,name)

 

VALUES (v_id,v_city,v_name);

 

COMMIT;

 

END;

 

以下哪些PL/SQL语句能够正确调用该过程?(选择1项)

 

A. EXECUTE INSERT_TEAM;

 

B. EXECUTE INSERT_TEAM (V_NAME=.>”LONG HORNS”);

 

C. V_CITY=>”AUSTIN”;

 

D. EXECUTE INSERT_TEAM (3,”AUSTIN”,”LONG HORNS”)

 

解答:D

posted @ 2018-08-29 11:14  borter  阅读(1588)  评论(0编辑  收藏  举报