What is %type and %rowtype variable in oracle PL/SQL : Interview Question

Опубликовано: 09 Октябрь 2024
на канале: Kishan Mashru
2,710
38

This video tutorial explains the usage of %type variable declaration and %rowtype variable declaration. It also states the advantages of using %type and %rowtype variable declaration. At the end the viewes can easily identify the difference between %type and %rowtype variable declaration

If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below :

char and varchar2 :    • DIFFERENCE BETWEEN CHAR AND VARCHAR2 ...  
replace and translate :    • Difference between Replace and Transl...  
procedure and function :    • Difference between Procedure and Func...  
in and exists :    • IN VS EXISTS VS JOIN, performance  
rank and dense_rank :    • Row Number Vs Rank Vs Dense Rank  
delete and truncate :    • Difference between Delete and Truncat...