DROP TRIGGER business_rule;
DELETE TRIGGER business_rule;
REMOVE TRIGGER business_rule;
ALTER TRIGGER business_rule;
DELETE FROM USER_TRIGGER WHERE TRIGGER_NAME= 'BUSINESS_RULE';
When the NEW_PRODUCT_VIEW is dropped.
When rows of the product table are updated through SQI Plus.
When the internal logic of the QUERY_PRODUCT procedure is modified.
When a new column that can contain null values is added to the product table.
When a new procedure s created that updates rows in the product table directly.
VARCHER2.
BOOLEAN.
OUT.
IN.
Statement-level trigger on the EMP table.
For each row trigger on the EMP table.
Statement-level trigger on the AUDIT_TABLE table.
For each row statement level trigger on the EMP table.
For each row trigger on the AUDIT_TABLE table.
When the procedure contains no SQL statements.
When the procedure contains no PL/SQL commands.
When the procedure needs to be used by many client applications accessing several remote databases.
When the procedure needs to be used by many users accessing the same schema objects on a local database.
EXECUTE ADD_PLAYER (10,a);
ADD_PLAYER (10,a);
RUN ADD_PLAYER (10,a);
START ADD_PLAYER (10,a);
CREATE OR REPLACE PROCEDURE calc (p_no IN NUMBER) RETURN tax IS V_sal NUMBER; Tax NUMBER; BEGIN SELECT sal INTO v_sal FROM emp WHERE EMPNO=p_no; Tax:=v_sal * 0. 05; END;
CREATE OR REPLACE FUNCTION calctax(p_no NUMBER) RETURN NUMBER IS V_sal NUMBER; BEGIN SELECT sal INTO v_sal FROM emp WHERE empno =p_no; RETURN(v_sal* 0. 05); END;
CRETAE OR REPLACE FUNCTION calctax(p_no NUMBER) RETURN NUMBER IS V_sal NUMBER; Tax NUMBER; BEGIN SELECT sal INTO v_sal FROM emp WHERE empno =p_no; Tax:=v_sal * 0. 05; END;
CREATE OR REPLACE FUNCTION calctax(p_no NUMBER)IS V_sal NUMBER; Tax NUMBER; BEGIN SELECT sal INTO v_sal FROM emp WHERE empno =p_no; Tax :=v_sal * 0. 05; RETURN(tax); END;
Only local or packaged sub programs can be overloaded.
Overloading allows different functions with the same name that differ only in their return types.
Overloading allows different subprograms with the same number, type and order of the parameter.
Overloading allows different subprograms with the same name and same number or type of the parameters.
Overloading allows different subprograms with the same name but different in either number or type or order of parameter.
1
10
None
Value equal to the number of rows in the emp table
GRANT SELECT ON ADD_PLAYER TO PUBLIC;
GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;
GRANT INSERT ON PLAYER TO PUBLIC;
GRANT EXECUTE, INSERT ON ADD_PLAYER TO PUBLIC;
REVOKE INSERT ON PLAYER FROM PUBLIC;
ROW_UPDATE('SALARY')
UPDATING('SALARY')
CHANGING('SALARY')
COLUMN_UPDATE('SALARY')
The value of DISCOUNT_RATE always remain 0. 00 in a session.
The value of DISCOUNT_RATE is set to 0. 10 each time the package are invoked in a session.
The value of DISCOUNT_RATE is set to 1 each time the procedure DISPLAY_PRICE is invoked.
The value of DISCOUNT_RATE is set to 0. 10 when the package is invoked for first time in a session.
Only varrays must start with the subscript 1.
Only varrays can be used as column types in database tables.
Both associative arrays and varrays must start with the subscript 1.
Both associative arrays and varrays can be used as column types in database tables.
Row
Statement
ORACLE FORM trigger
Before
In the package body
In a database trigger
In the package specification
In each procedure's DECLARE section, using the exact same name in each
The rows are selected and ordered.
The validity of the SQL statement is established.
An area of memory is established to process the SQL statement.
The SQL statement is run and the number of rows processed is returned.
The area of memory established to process the SQL statement is released.
Querying with the SELECT * notation
Declaring variables with the %TYPE attribute
Specifying schema names when referencing objects
Declaring records by using the %ROWTYPE attribute
Specifying package.procedure notation while executing procedures
Packages can be nested.
You can pass parameters to packages.
A package is loaded into memory each time it is invoked.
The contents of packages can be shared by many applications.
You can achieve information hiding by making package constructs private.
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.