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

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,


What is the use of partition by in sql?

0 Answers  


Can we create table in function?

0 Answers  


is it mandatory to select all the column in a view then what columns should be selected

2 Answers  


What are primary key and foreign key and how they work?

0 Answers  






What are all the common sql functions?

0 Answers  


What do you mean by field in sql?

0 Answers  


What is the importance of sqlcode and sqlerrm?

0 Answers  


Is it possible to access the current value in a session before accessing next value?

1 Answers  


How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,


List different type of expressions with the example.

0 Answers  


What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,


Categories