Home » SQL & PL/SQL » SQL & PL/SQL » back ground tables
back ground tables [message #209750] Sun, 17 December 2006 09:01 Go to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
when i insert data into loan table,
i want the loan_detail data to b updated from 4 different tables;
i.e in loan_details values from
gen_payroll----pay_month and pay_year
from loans---- loan_amount, installment_no
from o_bal ----opening balance.
i do it in data base after insert trigger of loan table.
Re: back ground tables [message #209760 is a reply to message #209750] Sun, 17 December 2006 11:09 Go to previous message
Littlefoot
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
sispk
I do it in data base after insert trigger of loan table.

OK. Would you mind to share your solution with us and say where is the problem?
Previous Topic: Exclude records from the beginning and the end of a table
Next Topic: Optimization
Goto Forum:
  


Current Time: Fri Jul 21 18:01:31 CDT 2017

Total time taken to generate the page: 0.20485 seconds