I-Drop Rule Set ingumqondo oyisisekelo ku-Oracle SQL, osetshenziselwa ukukhohlisa, ukuphatha, nokuhlela amasethi edatha ngaphakathi kwendawo egciniwe. Isiza ekugcineni ubuqotho besakhiwo solwazi lwesizindalwazi ngokuchaza imithetho ethile ebeka ukuthi idatha ingangeniswa kanjani, ithekeliswe, noma isuswe kanjani. Kulesi sihloko, sizocubungula ukubaluleka kwe-Drop Rule Set, ukulandelana kwezenzo ezidingekayo ukuze kusetshenziswe, kanye nekhodi ethile evumela lokho.
Ku-Oracle SQL, Yehlisa Isethi Yomthetho kuyindlela esetshenziswa ukususa umthetho osethiwe kusizindalwazi. Kusebenza kuzo zombili izakhiwo zedatha ezilula neziyinkimbinkimbi, okwenza ukukhohlisa kwedathabheyisi kube lula ukulawuleka. Ithuthukisa ukusebenza kwesizindalwazi ngokususa amasethi emithetho angadingekile noma aphelelwe yisikhathi kanye nokuthuthukisa ukuphathwa kwedatha.
YEHLISA UMTHETHO SET rule_set_name;
Lena i-syntax eyisisekelo ye-Drop Rule Set. I-rule_set_name yigama lomthetho ofisa ukuwuyeka.
Isinyathelo ngesinyathelo ikhodi incazelo
Ukwenza umsebenzi we-Drop Rule Set kulula uma kuqhathaniswa ku-Oracle SQL. Yonke le nqubo ihlanganisa ukucacisa igama lomthetho osethiwe ozosuswa ngokusebenza okuthuthukisiwe "Ye-Drop Rule Set".
YEHLISA UMTHETHO WEKA imithetho_yekhasimende;
Lapha, isimiso somthetho esibizwa ngokuthi 'customer_rules' siyayekwa.
Kubalulekile ukuqaphela ukuthi ngaphambi kokuba isethi yomthetho ihoxiswe, konke ukuncika kuyo kufanele kususwe. Ukwehluleka ukwenza kanjalo kuzoholela ephutheni. Ngemuva kokuqinisekisa ukuthi akukho ukuncika, ungaqhubeka nomsebenzi.
Imitapo yolwazi Ehlobene Nemisebenzi
I-Oracle SQL inikezela ngenqwaba yemitapo yolwazi nemisebenzi engasebenza uma usebenzisa i-Drop Rule Set, njengephakheji ye-DBMS_RULE kanye nenqubo ye-DELETE RULE SET.
Iphakheji ye-DBMS_RULE iwumtapo wezincwadi onamandla onezici eziningi zokukhohlisa nokuphatha amasethi wemithetho. Inikeza onjiniyela izici eziwusizo zokuphatha amasethi wemithetho, ezisiza ekusebenzeni okushelelayo.
Inqubo ye-DELETE RULE SET, ngakolunye uhlangothi, ibandakanyeka enqubweni yokususa yamasethi wemithetho. Kuyinqubo engaphakathi kwe-Oracle SQL esetshenziselwa ukwenza imisebenzi ye-Drop Rule Set.
Ukuqonda ukuthi kwenziwa kanjani ngendlela efanele a Yehlisa Isethi Yomthetho ukusebenza ku-Oracle SQL kungakhuphula kakhulu ukusebenza nokuphathwa kwesizindalwazi. Lo msebenzi uyingxenye eyinhloko yokuphathwa kwedatha, futhi ukwazi ukusetshenziswa kwayo kubalulekile ukuze kugcinwe ubuqotho besakhiwo nokusebenza kahle kwezingosi zolwazi ze-Oracle. Iveza kokubili indlela ephumelelayo yokususa amasethi wemithetho kanye nezindlela zokuthuthukisa ukusebenza kwesizindalwazi, okuyenza ibaluleke kakhulu ekuthuthukisweni kwe-Oracle SQL.
Ukusebenzisa i-Drop Rule Set kungaba lula uma uqonda izinyathelo, imisebenzi, namalabhulali ahililekile kule nqubo. Ukulungisa amaphutha ngokuphumelelayo kokuncika ngaphambi kokusebenza kuwumkhuba obalulekile wokwenza okungenazihibe. Khumbula ukusebenzisa amandla emitapo yolwazi njengephakeji ye-DBMS_RULE kanye nenqubo ethi SUSA RULE SET ukuze kube nokusebenza okuhlanzekile nokusebenza kahle kakhulu. Izinzuzo zokuba yinkosi yalezi zimiso ziyabonakala ekugcineni nasekuthuthukiseni ukusebenza kwesizindalwazi.
