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
8 9497Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)
6 14799Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott
3 6225Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
4 8375how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing
1 4070
How many types of tables are there?
What is the difference between distinct and unique in sql?
What is a dirty read sql?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is a dynamic query?
How is a PL/SQL code compiled?
What is a sql profiler?
Can a procedure in a package be overloaded?
What do you know by pl/sql cursors?
What is the source code of a program?
what is msql? : Sql dba
What is a crud api?
What are joins in sql?
how to select unique records from a table? : Sql dba
Why do we create stored procedures & functions in pl/sql and how are they different?