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 9008 5418
How do you retrieve the last N records from a table?10 13626
Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)6 11159
Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott3 4036
what is the Default Libraries for Oracle Report 6i
If the base table structure is changed what will happen to join index????2 4872
Hi 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 d4 5826
what is the different between unique+not null & primary key,4 5289
how 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 testing1 2636
how many tables will create when we create table, what are they? : Sql dba
How delete all data from all tables in sql?
what are all different types of collation sensitivity? : Sql dba
Why use truncate instead of delete?
Which is faster subquery or join?
what are null values? : Sql dba
what is timestamp in mysql? : Sql dba
Can a table contain multiple foreign key’s?
does sql support programming? : Sql dba
what is text? : Sql dba
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What does truncate mean in sql?
What is column?
Can we create view in stored procedure?
What does select top 1 do in sql?