Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you write a subquery?

517


Explain what is an index?

584


What's the difference between inner join and left join?

511


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

669


How can we optimize a sql query?

571






Can a table contain multiple foreign key’s?

570


what is rdbms? : Sql dba

575


What is basic structure of pl sql?

496


Explain the components of sql?

587


What is exception? What are the types of exceptions?

554


What is numeric function sql?

540


Which one is better subquery or joins?

553


what are the advantages and disadvantages of views in a database? : Sql dba

529


How do I send sql query results to excel?

577


Which certification is best for sql?

534