Ma'lumotlar bazasida triggerlar mbbtda ma`lumotlar bilan ishlashda triggerlarni ishlatish


Download 1.37 Mb.
bet2/4
Sana12.11.2021
Hajmi1.37 Mb.
1   2   3   4

Trigger toifalari

Triggerning ob`yektga ta`siri

  • 1 misol:
  • SQL> INSERT INTO dept (deptno, dname, loc)
  • 2 VALUES (50, 'EDUCATION', 'NEW YORK');
  • Trigger tanasidagi hodisa bir marta bajariladi.
  • SQL> UPDATE emp
  • 2 SET sal = sal * 1.1
  • 3 WHERE deptno = 30;
  • 2 misol:
  • Trigger tanasidagi har bir satr uchun bir marta bajariladi.
  • DEPTNO
  • 10
  • 20
  • 30
  • 40
  • DNAME
  • ACCOUNTING
  • RESEARCH
  • SALES
  • OPERATIONS
  • LOC
  • NEW YORK
  • DALLAS
  • CHICAGO
  • BOSTON
  • DEPT ob`yekti
  • BEFORE
  • BEFORE
  • AFTER
  • AFTER

Download 1.37 Mb.

Do'stlaringiz bilan baham:
1   2   3   4




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2020
ma'muriyatiga murojaat qiling