Oracle PL SQL interview question | Creating Same Type of trigger on same table

Oracle PL SQL interview question Creating Same Type of trigger on same table
---------------------------------------------------------------------------------------------------------------------------

This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 10 years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

---------------------------------------------------------------------------------------------------------------------------

[Adbhutashole]

Sir Please upload your biography. We want to know about you. Because on whole YouTube channels, we didn't get any teacher like you....You are the only single person who have cleared our years and years doubts in a single minute . 🙏🏻💐

[aniketjagdale]

Hello Siva sir thanks for such a good explanation. Please can you make videos on local and global index partitions.

[dilippatel]

Hello Siva sir, I am curious if you can add a section on packages, public and private procedures and access permissions, like Authid current_user, global variables, overloaded procedures, maximum number of indexes on tables, performance tuning, oracle hints

[mahendrasinghthakur]

Hi sir, my question is why you should not use trigger for application projects?

[rudraparab]

Sir, the "follows" keyword can be used only with triggers or can be used with other db objects as well

[shyamthopte]

Please make the videos of interview questions videos and answer ... Please tell me the one table I have created multiple trigeer but suppose one trioger got error so other trigger will execute...?

[riyazbabu]

Hi Siva .
Today I have faced interview question like..
How can we use commit Inside the trigger without using pragram autonomous transaction?

[computerlearningbyargusaca]

🙏🙏You are just 👍👍amazing .. 😍😍 very nice video

[ravindrareddy]

Thank you, can you please tell me which scenario have used in real time?

[sarojkumargiri]

Q2 Sir supposed I want to change data type in existing table varchar2 to number data type but this table available in prod already character data is available in same column. Is it possible ?

[sarojkumargiri]

Supposed I have one table column is id, name, DOB, age. I want to insert data into 3 column id, name, dob but I need to update age in same table through trigger is it possible?

[ravibathula]

sir please do videos on unix, oracle dba, etl also

[shaikrasheed]

Sir please make etl with informatica interview point videos

[navpreet]

Hi Sir,
can you pls clarify my doubt.
Suppose there is an before row level update trigger(inserting record in any table) applied on table, then when we make an update in original table, then before executing the update on original table, the trigger will execute and what will happened if the update statement fails(event for which trigger is created)as data are already inserted in other table as part of trigger?

[shaikrasheed]

Sir what is difference between declarative constraints vs triggers??

[shashank]

Nice video bro... So means n no. Of times same types of trigger we can create on a table or there is any limit?
And if create constraint and trigger on same table then what's the order of execution
Like
Before statement level
Before row level
Constraint
After row level
After statement level
? Pls explain
And also explain about cascadding trigger?

[Adbhutashole]

Dear Shiva Sir, thanks for uploading the video of the most awaited topic.
Sir I am still waiting for the video of "scenario based real use of GTT and PTT)..
I have faced This question 7 times out of 10.. I was able to tell the interviewer, what both is but not able to discribe them where I used them in my SCM Project.
So please upload this video .Or I can attend live session.

Thanks & regards
Ujjwal