What is difference between % ROWTYPE and TYPE RECORD ?
% ROWTYPE is to be used whenever query returns a entire row of a table or view. TYPE rec RECORD is to be used whenever query returns columns of differenttable or views and variables. E.g. TYPE r_emp is RECORD (eno emp.empno% type,ename emp ename %type); e_rec emp% ROWTYPE cursor c1 is select empno,deptno from emp; e_rec c1 %ROWTYPE.
Showing Answers 1 - 11 of 11 Answers
- Record mismatch
- Triggering events in Oracle
- Exploratory testing
- Difference between is and as in Oracle
- Array differences
- How to select the correct bug type ?
- Composite and alloy
- Db2 data types
- What is the difference between iebgener,iebcopy and repro
- Difference between divisions and paragraphs?
- What is difference between tcp and udp and which is preferable
- Write a program that calculates and prints the bill ?
- How do you implement SCD type 2 in datastage ?
- Controlled and uncontrolled redundancy
- What is the difference between unearned revenue and unbilled receivables?
- What is the difference between sequence diagram and collaboration diagram?
- What is the difference between disaster recovery at the data link layer and the transport layer?
- C program to compare two text files
- In procedures we can use record type is possible or not?
- What is the difference in C and Java ?