Explain the purpose of %type and %rowtype data types with the example?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Is sql a case sensitive language?

0 Answers  


Write a unique difference between a function and a stored procedure.

0 Answers  


How do sql databases work?

0 Answers  


What is field delimiter?

0 Answers  


What is the use of nvl function?

0 Answers  






How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,


check whether all the emp numbers are indeed unique.

6 Answers  


What is %type in sql?

0 Answers  


What is cursor and its types?

0 Answers  


Can we write create command in the plsql block?if possible how?

2 Answers  


What are the various levels of constraints?

0 Answers  


what is a scheduled jobs or what is a scheduled tasks? : Sql dba

0 Answers  


Categories