The PROCEDURE_ADD_PRODUCT is defined within a package specifications as follows: The package specification is invalidated. INSERT INTO PLAYER(ID, LAST_NAME, SALARY)Īn outside procedure VALIDATE_PLAYER_STAT is executed from this package.What will happen when this procedure changes?ī. (V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBER) (V_ID IN NUMBER, V_AVG IN NUMBER DEFAULT 4,V_HITS IN NUMBER) PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME
#Ti connect ce where are programs i added update
Which solution should you use to verify that the user is performing an update on the salary column? You will be adding additional coat later but for now you want the current block to fire when updated the salary column. Which kind of packaged variables is V_MAX_TEAM_SALARY?ĬREATE OR REPLACE TRIGGER UPD_TEAM_SALARYĪFTER INSERT OR UPDATE OR DELETE ON PLAYER INSERT INTO PLAYER (ID, LAST_NAME, SALARY) (V_ID IN NUMBER, V_LAST_NAME, VARCHAR2, V_SALARY IN NUMBER) V_ID IN NUMBER, V_AB IN NUMBER DEFAULT4, V_HITS IN NUMBER) PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHAR2,V_SALARY NUMBER) Which data dictionary views give you the names and the source code of all the procedures that you have created? Use the DBMS_DROP packaged routines in the procedure to drop the table. Use the DBMS_SQL packaged routines in the procedure to drop the table.Į. Use the DBMS_DDL packaged routines in the procedure to drop the table.ĭ.
Use the DROP command in the procedure to drop the table.Ĭ. You cannot drop a table from a stored procedure.ī. You need to drop a table from within a stored procedure. Which Oracle supply package allows you to run jobs at user defined times? GRANT EXECUTE, INSERT ON ADD_PLAYER TO PUBLIC Which two actions must you take? (Choose two)ī. You want only your users to insert into this table using the ADD_PLAYER procedure. All users currently have the INSERT privileges on the PLAYER table.
0 kommentar(er)
