Friday, December 29, 2017

PL/SQL %TYPE and %ROWTYPE – Usage, Differences, and Examples Explained

  • %TYPE is used to declare a variable that is of the same type as a specified table’s column.
     
        example: Emp_number emp.empno%type;
  • %ROWTYPE is used to declare a record (the variable that represents the entire row of a table).
         example: Emp_record emp%rowtype;

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.

No comments:

Post a Comment