Benefits of %TYPE and %ROWTYPE in Oracle PL/SQL Anonymous Block. Hello Everyone, Today I will discuss about %TYPE and %ROWTYPE in Oracle. In my previous blog I already discussed about uses of cursors in Anonymous PL/SQL block. I suggest you to please go through below blog for your reference so that you can easily understand %TYPE and %ROWTYPE in PL/SQL anonymous block. https://dikshaoracletraining.blogspot.com/2020/10/cursor-and-types-of-cursor-in-oracle.html Let’s Start with both attribute %TYPE and %ROWTYPE then we will write some Anonymous PL/SQL block by using %TYPE and % ROWTYPE and see its advantage. %TYPE : %TYPE is mainly used to defined the data type of variable as the column name data type specified for a table. If table column has data type varchar2 (50) then %type variable automatically take the data type that is varchar2 (50) no need to define data type while writing PL/SQL block as we simply want to know the table name which can be used in both
Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.