| Other SQL PLSQL Interview Questions |
|| Asked @
|how to Update table Sales_summary with max(sales) data from
table sales_dataTable 1. sales_data table Table 2.
Region sales Region sales
N 500 N 0
N 800 W 0
I want the Sales_summary After Update like this
|can we call a procedure from a function?
|In a package if we have 10 procedures or functions,How to
know which will execute first?
|How to update salary of employees department wise?
|there are .......different types of serializability
|How to recompile a already made trigger?
|Write a query to get last 10 records from the table.
|types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.
|what are Dynamic SQL statements?
|can i give user defined exception in a package
|what is the need of the cursor attribute notfound..(because
using found attribute we can complete the task......found +
negation operator = not found )
|Types of cursors and explanation each of them ?
|For more SQL PLSQL Interview Questions Click Here |