What trigger means?
How to avoid duplicate records in a query?
Can one improve the performance of sql*loader? : aql loader
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is string join?
Can we write ddl statements in functions?
how to fetch common records from two tables? : Sql dba
What is a native sql query?
can we use out parameter in a function?Give an example.
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is sql not null constraint?
What is difference between Procedures and Functions ?
how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900