Db schema level triggers Database Journal | SQLCourse | SQLCourse2 Register Help Remember Me? Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New? Advertiser Disclosure Advanced Search Forum Oracle Forums Oracle Development Db schema level triggers If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: Db schema level triggers Thread Tools Show Printable Version Email this Page… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-02-2022, 05:54 AM #1 timott View Profile View Forum Posts Junior Member Join Date Mar 2022 Posts 1 Db schema level triggers Hi, we are facing a problem with data amount, so it would be a nice solution in testing env just to limit data with db schema level triggers... So querying a table would return only first 100 rows. This is enough with smoke tests. I guess this might be a schema level trigger in test user .... or is this possible ? It would affect to every table automatically which would be nice. Reply With Quote 03-07-2022, 01:48 AM #2 sophia View Profile View Forum Posts Junior Member Join Date Mar 2022 Posts 1 The following statement creates a trigger for the EMP table: CREATE TRIGGER print_salary_changes BEFORE DELETE OR INSERT OR UPDATE ON emp FOR EACH ROW WHEN (new.empno > 0) DECLARE sal_diff number; BEGIN sal_diff := new.sal - old.sal; dbms_output.put('Old salary: ' || ld.sal); dbms_output.put(' New salary: ' || :new.sal); dbms_output.put_line(' Difference ' || sal_diff); END; / If you enter a SQL statement such as UPDATE emp SET sal = sal + 500.00 WHERE deptno = 10 Reply With Quote Quick Navigation Oracle Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML code is On Forum Rules Contact Us DBAsupport.com Home Page Top Click Here to Expand Forum to Full Width Terms of Service | About Us | Privacy Notice | Contact Us | Advertise | Sitemap| California - Do Not Sell My Info Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace. All times are GMT -4. The time now is 11:58 AM.