How to create own exceptions in PL/SQL

1.	How to create own exceptions in PL/SQL
Answer» The LARGE OBJECT Data Types are pointers to large objects that are stored separately from other data items, like text, graphic images, video clips, etc. The following are the data types: BFILE: Store large binary objects in operating system files OUTSIDE the DATABASE. The size is system-dependent and exceed 4 GB. BLOB: Store large binary objects in the database. The size is 8 to 128 TB. CLOB: Store large blocks of character data in the database. The size is 8 to 128 TB. NCLOB: Store large blocks of NCHAR data in the database. The size is 8 to 128 TB.

Answer»

The LARGE OBJECT Data Types are pointers to large objects that are stored separately from other data items, like text, graphic images, video clips, etc. The following are the data types:

BFILE: Store large binary objects in operating system files OUTSIDE the DATABASE. The size is system-dependent and exceed 4 GB.
BLOB: Store large binary objects in the database. The size is 8 to 128 TB.
CLOB: Store large blocks of character data in the database. The size is 8 to 128 TB.
NCLOB: Store large blocks of NCHAR data in the database. The size is 8 to 128 TB.

Discussion

No Comment Found

Related InterviewSolutions

What are the programming constructs supported by PL/SQL?
Why do we use VSIZE() function in PL/SQL?
How to pad a string with zeros on the right in PL/SQL?
What are the types of Strings in PL/SQL?
Does VARRAY exist in PL/SQL?
What are the guidelines to be used before creating a PL/SQL Package?
What is the use of WHEN clause in PL/SQL?
How to create a user-defined SUBTYPE in PL/SQL?
Can a %ROWCOUNT attribute returns the total number of rows returned by the FETCH command?
Why do we use the TIMESTAMP datatype in PL/SQL?

How to create own exceptions in PL/SQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment