PL/SQL Placeholders

PL/SQL Placeholders

• Placeholders are can be any of Variables, Constants and Records.
• Oracle defines placeholders to store data temporarily.
• Which are used to manipulate data during the execution of a PL SQL block depending on the kind of data we want to store.
• We can define placeholders with a name and a data type.

Few of the data types used to define placeholders are as given below.
NUMBER (n,m), CHAR (n) , VARCHAR2 (n) , DATE , LONG , LONG RAW, RAW, BLOB, CLOB, NCLOB, BFILE, TIMESTAMP, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH