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: 20890
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: Sat Dec 03 13:45:58 CST 2016

Total time taken to generate the page: 0.21363 seconds