Equivalent of %TYPE and %ROWTYPE in teradata

Analytics
Enthusiast

Equivalent of %TYPE and %ROWTYPE in teradata

Hello All,

In oracle Both %TYPE and %ROWTYPE are used to define variables in
PL/SQL as it is defined within the database. If the datatype or
precision of a column changes, the program automically picks up
the new definition from the database without having to make any
code changes.

whats equivalent of this in Teradata.
3 REPLIES

Re: Equivalent of %TYPE and %ROWTYPE in teradata

I also would like to know regarding this? I need this in reference to Stored Procedure from Oracle to TD
Enthusiast

Re: Equivalent of %TYPE and %ROWTYPE in teradata

Teradata (as of 13.10) has no syntax equivalent to the Oracle %TYPE and %ROWTYPE. Variables of any type may be declared in a procedure, but the exact type must be specifed directly.

Re: Equivalent of %TYPE and %ROWTYPE in teradata

What is the SQLServer Rowtype equivalent in Teradata ?