GajaKesari Posted September 23, 2014 Report Posted September 23, 2014 is there a way to write sql statement to pull records automatically whenever data is inserted
pythonic Posted September 23, 2014 Report Posted September 23, 2014 Read about database triggers man...you can create post insert trigger...kani naku pull records ante ento ardham kala...aa records data file lo rayala?
pythonic Posted September 23, 2014 Report Posted September 23, 2014 Nee qn sariga avvaledu man....so after insert...select statement ki inserted records ravadam leda....unless you enabled auto commit...you have explicitly do an commit after insert man...or on closing the connection they will be committed...
GajaKesari Posted September 23, 2014 Author Report Posted September 23, 2014 new records insert ayyaka veer table ki move cheyyali
ChampakDas Posted September 23, 2014 Report Posted September 23, 2014 triggers petu table ki AFTER INSERTED
GajaKesari Posted September 23, 2014 Author Report Posted September 23, 2014 triggers petu table ki AFTER INSERTED K
GajaKesari Posted September 23, 2014 Author Report Posted September 23, 2014 triggers petu table ki AFTER INSERTED K
mustang302 Posted September 23, 2014 Report Posted September 23, 2014 automatic annav kadha...so triggers best..!!
GajaKesari Posted September 23, 2014 Author Report Posted September 23, 2014 Naa question tappu trigger undi but it should only get new records which were inserted
mustang302 Posted September 23, 2014 Report Posted September 23, 2014 vuncle..nee question ento baga think chaesi crystal clear ga pos chai malli..!! 1
mettastar Posted September 23, 2014 Report Posted September 23, 2014 Andaru cheppinattu first Database Triggers gurinchi chaduvu.. solution neke telusthundhi
GajaKesari Posted September 23, 2014 Author Report Posted September 23, 2014 k naa question enti antey naa process every 30 minutes ki run avuthu untundii(i will trigger using tibco) whenever there are new records in that table only aa new records ni vere table loki move cheyyali
Recommended Posts