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


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

Post New Answer

More SQL PLSQL Interview Questions

How would you convert date into julian date format?

0 Answers  


i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,


I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,


What is a sql profiler?

0 Answers  


Is sql injection illegal?

0 Answers  






how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  


how to convert character strings to dates? : Sql dba

0 Answers  


What is clustered and non-clustered indexes?

4 Answers   Microsoft,


How to find 3rd highest salary of an employee from the employee table in sql?

0 Answers  


How can I speed up sql query?

0 Answers  


What is the use of <> sql?

0 Answers  


How to call a javascript function from pl sql?

0 Answers  


Categories