Teradata Forums / Analytical Applications / Teradata / Equivalent of %TYPE and %ROWTYPE in teradata / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 02:03:18 GMT20Equivalent of %TYPE and %ROWTYPE in teradatahttp://www.teradata.com/teradataforum/Topic10568-5-1.aspxHello All,In oracle Both %TYPE and %ROWTYPE are used to define variables inPL/SQL as it is defined within the database. If the datatype orprecision of a column changes, the program automically picks upthe new definition from the database without having to make anycode changes.whats equivalent of this in Teradata.Wed, 13 Feb 2008 02:16:34 GMTraj1983