Thanks a lot for your efforts to prepare and share interviewquestions related videos. Could you please make a video on below 2 questions 1- difference between dba_, all_ , user_ meta data tables 2- Suppose 1 after update row level trigger and statement level trigger is there on a table. If update is there with false condition where 1 =2 then what will happen to both the triggers
@SivaAcademy Жыл бұрын
Thank you, sure please stay tuned, will cover in upcoming videos
@madhu5253 Жыл бұрын
Very well explained explained.. thanks 🙏 please do a video on merge and hash join..
@SivaAcademy Жыл бұрын
Welcome, sure, please stay tuned, will cover in upcoming videos
@life_style819 Жыл бұрын
Can you tell us one project for PLSQL DEVELOPER. Actually in industry how is working with the help of like package, procedure, trigger, function, collection, query.
@SivaAcademy Жыл бұрын
Sure, please stay tuned will cover in upcoming videos
@daljeetsingh5192 Жыл бұрын
With d1 as( Select sum (sal) itsal where dept='it' from t1), D2 as (Select sum (sal) hrsal where dept='hr' from t1), D3 as (Select sum (sal) othrsal where dept not in ('it', 'hr') from t1) Select * from d1, D2, d3
@daljeetsingh5192 Жыл бұрын
Sir please suggest which approach is better in performance point of view
@SivaAcademy Жыл бұрын
Which ever the option fetches the data with minimal table read is the best option