tag:blogger.com,1999:blog-5993094254562794074.post1438974041947129272..comments2023-09-07T05:41:03.882-07:00Comments on Dive in Oracle Database with Arun Kaushik : What is Mutation & How to avoid MutationAnonymoushttp://www.blogger.com/profile/16116298660170592398noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-5993094254562794074.post-36162102997508179232016-04-23T05:31:51.217-07:002016-04-23T05:31:51.217-07:00Could you please explain why we cant use TCL insid...Could you please explain why we cant use TCL inside the trigger?<br />i have searched from many site, but still not getting sufficient answer.Anonymoushttps://www.blogger.com/profile/17871090199519128666noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-90961619019995224252015-11-04T02:15:22.584-08:002015-11-04T02:15:22.584-08:00Super boss. Good Explanation.Super boss. Good Explanation.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-55223550538531411272014-06-21T08:16:20.315-07:002014-06-21T08:16:20.315-07:00without using oracle sequence, can we insert incre...without using oracle sequence, can we insert incremental sequence number into same table id column using Autonomous transaction?Anonymoushttps://www.blogger.com/profile/10427742799122472061noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-35638112147458951462014-04-11T03:17:24.622-07:002014-04-11T03:17:24.622-07:00Nice bro awesome explainationNice bro awesome explainationAnonymoushttps://www.blogger.com/profile/01558666031101729309noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-4317817782581229782014-03-07T08:53:33.986-08:002014-03-07T08:53:33.986-08:00if you have rows in a table that are dependent on ...if you have rows in a table that are dependent on other rows (sums/discounts/etc ) the row-level triggers can write the keys to a pl/sql table and then the after-statement triggers can read those keys, perform the calculations and re-update. http://www.oracle-base.com/articles/11g/trigger-enhancements-11gr1.phpEd Crottyhttps://www.blogger.com/profile/10103923868669472908noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-34239833125764184722014-01-29T20:59:11.748-08:002014-01-29T20:59:11.748-08:00Really the mutating error concept becomes very ea...Really the mutating error concept becomes very easy to understand after reading your post... Thanks a lot..Can u pls explain about the performace tuning concepts also...Rajesh Modihttps://www.blogger.com/profile/18205197061589195436noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-4414090584129642962013-08-28T01:54:26.813-07:002013-08-28T01:54:26.813-07:00Thanks Kapil ...Thanks Kapil ...Anonymoushttps://www.blogger.com/profile/16116298660170592398noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-38981728057469317732013-08-26T21:17:31.857-07:002013-08-26T21:17:31.857-07:00I like the way you explain the concept. Thank you ...I like the way you explain the concept. Thank you very much!!!Anonymoushttps://www.blogger.com/profile/07093711615566952995noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-57404910037643546212013-06-10T20:45:54.687-07:002013-06-10T20:45:54.687-07:00Thanks Nandkishor .. This is what i like to do, kn...Thanks Nandkishor .. This is what i like to do, knowledge sharing .. when ever i get time .. Anonymoushttps://www.blogger.com/profile/16116298660170592398noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-46037724515806819112013-06-10T01:02:16.695-07:002013-06-10T01:02:16.695-07:00too good piece of information, I had come to know ...too good piece of information, I had come to know about your site from my friend sajid, bangalore,i have read atleast 11 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards, <a href="//oracletechniques89.blogspot.com/2013/04/single-row-function-in-sql.html" rel="nofollow"> Single Row Function in sql</a><br /><br /><br />Anonymoushttps://www.blogger.com/profile/17313661190126567875noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-11353289469608759072013-03-09T09:42:18.725-08:002013-03-09T09:42:18.725-08:00Can You please explain what is the requirement , i...Can You please explain what is the requirement , in which you want to insert rows in the same table before or after for a row level trigger.<br /><br />Anonymoushttps://www.blogger.com/profile/16116298660170592398noreply@blogger.comtag:blogger.com,1999:blog-5993094254562794074.post-3874494434574955012013-03-09T09:23:18.202-08:002013-03-09T09:23:18.202-08:00Dear,
I want to create trigger after or before in...Dear,<br /><br />I want to create trigger after or before insert for each row and in this trigger insert statement on the same table , not just select.Anonymousnoreply@blogger.com