Skip to content

Opening book details…

Can I read Anchored Datatype in PL/SQL Explained on EtoBox?

Anchored Datatype in PL/SQL Explained by kunche gangadhara rao is a document available to read on EtoBox.

What is Anchored Datatype in PL/SQL Explained about?

Anchored data types in PL/SQL are data types that are assigned to a variable based on a database object. The syntax uses the variable name and the %type attribute of a previously declared variable or database column. An example declares a variable v_fname with the same data type as the first_name column in a Students table. A SELECT statement fetches the first name where stu_id=1 and stores it in v_fname. Anchored data types allow variables to take on the data type of an underlying database object.

Author
kunche gangadhara rao
Language
EN