Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?
- 7 Answers
- 19479 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 |
How bulk collect improves performance?
What does the hierarchical profiler does?
Can you join views in sql?
What is cartesian join in sql?
What operating systems are supported by oracle sql developer?
How can we implement rollback or commit statement in a trigger?
how to shutdown mysql server? : Sql dba
What port does sql server use?
How to Execute a Package in PL/SQL.?
How to start the command-line sql*plus?
What is scope of pl sql developer in future?
What are the advantages of sql? Explain
-
Oracle (3259) - 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)
