With this package, a plsql subprogram or block can read from or write to a operating system file.
UTL_FILE uses the oracle directories and not the OS directories. So a logical directory to be …
DBMS_UTILITY is a oracle supplied package which is a collection of many stand alone procedures which are used for various purposes.
DBMS_UTILITY package defines a single record type and few table types.
This package is used for managing lock operation in PLSQL:
A deterministic function must return the same value on two distinct invocations. Condition is if the parameters provided in two invocation are same.
The deterministic clause may appear at most …
Prior 11g, when we create multiple triggers on same event then there were no such sequence of firing these triggers.
CREATE TABLE EMPLOYEES_FOLLOW_TEST
AS
SELECT * FROM EMPLOYEES;
CREATE OR REPLACE…
There are triggers available in database other than DML triggers. They are:
A Trigger
Datetime data type stores the values that consists of both date and time.
Date data type doesn't include time values.
A function is a named PLSQL block that can accept parameters and be invoked.