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