what are %TYPE and %ROWTYPE? what is the difference?
Answer Posted / vikneswaran
%type is used to declare variable for one column in the table
%type is used to declare variable for entire table
Is This Answer Correct ? | 7 Yes | 14 No |
Post New Answer View All Answers
List different type of expressions with the example.
Write the alter statement to enable all the triggers on the t.students table.
explain about mysql and its features. : Sql dba
What is cursor and its types?
What is the use of partition by in sql?
Is time a data type in sql?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Why sql query is slow?
How to create your own reports in sql developer?
Can instead of triggers be used to fire once for each statement on a view?
what is meant by urlencode and urldocode? : Sql dba
what are the differences between char and nchar? : Sql dba
what is union? : Sql dba
How to create a menu in sqlplus or pl/sql?
how to convert character strings to dates? : Sql dba