Oracle || PL/SQL Triggers Part-1 by Dinesh

DURGASOFT is INDIA’s No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP…
courses from Hyderabad & Bangalore -India with Real Time Experts.
Mail us your requirements to durgasoftonlinetraining@gmail.com
so that our Supporting Team will arrange Demo Sessions.
Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696.
http://durgasoft.com
http://durgasoftonlinetraining.com
https://www.facebook.com/durgasoftware
http://durgajobs.com
https://www.facebook.com/durgajobsinfo……

Comments

karthick harikrishan says:

sir,plz give me the link for part 2 trigger

manjunath reddy says:

sir Give me the link for part2 trigger

Nishant choudhary says:

Sir plz give me link of part 2 of trigger

Revati Raut says:

plz upload part 2 trigger … its very good explanation

Saicharan Yarraguntla says:

okkokaka mukka rendu sarlu enduku ayya babu cheppi burra tintav vallemaina school poragalla a=enti

sirigiri s says:

Great Explanation.Good…..

Sachin Sharma says:

Please refer link for trigger part 2 video

mehade Hasan says:

sir where is ratan sir???
where is jsp by ratan sir????

Jessinth Priyadarshan says:

where is part 2 sir?

gagan jangid says:

Dear sir.. You Explanation is very nice.. But there are too many errors in subtitles.. Please check and update for the sake of viewers …

rahul kute says:

sir your explaination is too good… can you pls upload the trigger part 2

nagushanu says:

Clear explanation sir Many Thanks to You!!!!

Sameer Ahmad says:

Hello Dinesh Sir, your Part-I of Trigger made us understand the concept of trigger, but the example done my Mr. Basha in Trigger Part-II is not understood to me. Kindly help me & let me know where am I making mistake ……

create or replace trigger trig1 after insert or update on students
begin
update students set
total = m1+m2+m3,
pct = (m1+m2+m3)/3,
grade = case when m1>=33 and m2>=33 and m3>=33 and (m1+m2+m3)/3 >=70 and (m1+m2+m3)/3 < =100 then 'D', when m1>=33 and m2>=33 and m3>=33 and (m1+m2+m3)/3 >=60 and (m1+m2+m3)/3 < =70 then 'F', when m1>=33 and m2>=33 and m3>=33 and (m1+m2+m3)/3 >=50 and (m1+m2+m3)/3 < =60 then 'S', when m1>=33 and m2>=33 and m3>=33 and (m1+m2+m3)/3 >=33 and (m1+m2+m3)/3 <=50 then 'T', else 'X' end; end; TRIGGER TRIG1 compiled Errors: check compiler log Error(2,1): PL/SQL: SQL Statement ignored Error(5,101): PL/SQL: ORA-00905: missing keyword

Shahina H says:

Hi, where can I find part2 of triggers and subsequent parts by Mr. Dinesh. I am not able to find in ur channel as well

koothan Mr says:

Dinesh sir, Trigger part 1 is awesome explanation and need trigger part 2 video to learn types & etc.. . Kindly update the video so that we can continue trigger.

Rajeshkumar Chhatar says:

Thank You very much Sir!! For such a big and complex topics covers in simply ways.

 Write a comment

*

Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!