What Is The Purpose Of %type Data Type? Explain With Example.

1.	What Is The Purpose Of %type Data Type? Explain With Example.
Answer» It assigns a variable the same data TYPE USED by the COLUMN, for which the variable is created. For EXAMPLE, dcode := DEPT.detpno%type; The variable dcode is created with the same data type as that of the deptno column of the dept table. It assigns a variable the same data type used by the column, for which the variable is created. For example, dcode := dept.detpno%type; The variable dcode is created with the same data type as that of the deptno column of the dept table.

Answer»

It assigns a variable the same data TYPE USED by the COLUMN, for which the variable is created. For EXAMPLE,
dcode := DEPT.detpno%type;
The variable dcode is created with the same data type as that of the deptno column of the dept table.

It assigns a variable the same data type used by the column, for which the variable is created. For example,
dcode := dept.detpno%type;
The variable dcode is created with the same data type as that of the deptno column of the dept table.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Three Basic Sections Of A Pl/sql Block?
State Some Features Or Programming Constructs Supported By Pl/sql.
Name Few Schema Objects That Can Be Created Using Pl/sql?
State Few Notable Characteristics Of Pl/sql.
What Does The Colon Sign (: ) Implies In The Following Statement? :deficit := Balance – Loan;
What Is The Purpose Of %type Data Type? Explain With Example.
What Is The Purpose Of %rowtype Data Type? Explain With Example.
What Is A Pl/sql Package?
What Are The Pl/sql Cursors?
What Is Returned By The Cursor Attribute Sql%rowcount?

What Is The Purpose Of %type Data Type? Explain With Example.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment