Inserting DATA to table A , after data is inserted into other table B using trigger in Oracle 9i

we have a table A which we have to uplaod daily then after inserting into A we have to move data from table A to Table B (in agregaated form),this we do manualy..Cant we have trigger which calls a procedure and populate Table B automaticaly when ever data comes in table A.

Thanks

Answers


This is a simple example which does almost exactly what you want, http://searchoracle.techtarget.com/answer/Calling-a-stored-procedure-from-a-trigger


Need Your Help

Form submit button remains disabled when using Back button in Firefox

jquery firefox back-button submit-button

I'm using some jquery to disable a form submit button after it's been clicked to prevent accidental repeated clicking. This works fine in all browsers except Firefox. In Firefox if the user uses ...

Set image transparency with VBA in Excel

excel image vba excel-vba

Is there a way to apply some transparency to an image using a VBA script? I have recorded a "macro" and it seems that artistic effects aren't recorded. I have found how to make it for shapes, but n...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.