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 9492Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)
6 14798Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott
3 6222Hi 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 8374how 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 4067
What types of commands can be executed in sql*plus?
How does one load ebcdic data? : aql loader
explain the difference between bool, tinyint and bit. : Sql dba
How to run sql statements with oracle sql developer?
What is a recursive stored procedure?
What is left join in postgresql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is trigger in pl sql?
Explain select statements in sql?
What is pivot query?
How to fetch alternate records from a table?
What is sql entity?
What is pls integer?
What is a unique key?
tell us something about heap tables. : Sql dba