Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?
- 7 Answers
- 19692 Views
- PreVator, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
ROWTYPE is declared at the record level and the TYPE is
declared for the coloumn level.
| Is This Answer Correct ? | 24 Yes | 1 No |
Answer / madhuri
%type and %rowtype provides data independence,reduces
maintainance cost and allows programs to adapt as the
database changes due to new business requirements.
%rowtype is used to declare a record with the same types as
found in the specified database table,view or a cursor.
%type is used to declare a field with the same type as found
in the specified table's column.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / sunil
ROWTYPE is declared at the record level and the TYPE is
declared for the coloumn level.
| Is This Answer Correct ? | 8 Yes | 0 No |
%Type is used to change the size of any datatype but only
for one record.
%Rowtype is used to declare a recoed that represents a
particular row of a table.
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / savani rakshit
%row type is used to focus on particular record.
row%type is used to focus on single row
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / kirankumar.vangeti
%ROWTYPE is used to declare a record with the same types as
found in the specified database table, view or cursor
%TYPE is used to declare a field with the same type as that
of a specified table's column.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / ajeet
%type is use to declare the data type of single column and % row type is use for more then one table ,in simple words with the help of % row type we can easily declare the data type of any table in database.
| Is This Answer Correct ? | 2 Yes | 0 No |
Can sql developer connect to db2?
how would you get the current date in mysql? : Sql dba
Mention what plvcmt and plvrb does in pl/sql?
How do you create an update query?
Is sql workbench free?
what are %TYPE and %ROWTYPE? what is the difference?
7 Answers ICICI, Saama Tech, Sail,
how to select unique records from a table? : Sql dba
what is bcp? When does it used? : Sql dba
What is an Exception ? What are types of Exception ?
What is Difference Between Unique and Primary Key Constraints?
types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.
Can there be more than one function with a similar name in a pl/sql block?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
