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

*

Human Verification: In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.


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

Please click below to support us on Facebook!

Send this to a friend

▷ Other ReviewsVehicles▷ Show Cars▷ Motorbikes▷ Scooters▷ Bicycles▷ Rims & Tires▷ Luxury BoatsFashion▷ Sunglasses▷ Luxury Watches▷ Luxury Purses▷ Jeans Wear▷ High Heels▷ Kinis Swimwear▷ Perfumes▷ Jewellery▷ Cosmetics▷ Shaving Helpers▷ Fashion HatsFooding▷ Chef Club▷ Fooding Helpers▷ Coktails & LiquorsSports▷ Sport Shoes▷ Fitness & Detox▷ Golf Gear▷ Racquets▷ Hiking & Trek Gear▷ Diving Equipment▷ Ski Gear▷ Snowboards▷ Surf Boards▷ Rollers & SkatesEntertainment▷ DIY Guides▷ Zik Instruments▷ Published Books▷ Music Albums▷ Cine Movies▷ Trading Helpers▷ Make Money▷ Fishing Equipment▷ Paintball Supplies▷ Trading Card Games▷ Telescopes▷ Knives▷ VapesHigh Tech▷ Flat Screens▷ Tech Devices▷ Camera Lenses▷ Audio HiFi▷ Printers▷ USB Devices▷ PC Hardware▷ Network Gear▷ Cloud Servers▷ Software Helpers▷ Programmer Helpers▷ Mobile Apps▷ Hearing AidsHome▷ Home Furniture▷ Home Appliances▷ Tools Workshop▷ Beddings▷ Floor Layings▷ Barbecues▷ Aquarium Gear▷ Safe Boxes▷ Office Supplies▷ Security Locks▷ Cleaning ProductsKids▷ Baby Strollers▷ Child Car Seats▷ Remote ControlledTravel▷ Luggages & Bags▷ Airlines Seats▷ Hotel Rooms▷ Fun Trips▷ Cruise Ships▷ Mexico Tours