Trigger is auto commit .. why do you need commit or rollback inside trigger ?? any use case where commit is required inside trigger?

Helo Bro I am a Forms / Reports developer, and one of my friend referred your channel then i go through the series. i got amazing result and concept is very clear now. thank you for your valuable time. best of luck bro.

helo shiva this is and Thanks for the clear explanation and your tutorial is very good but in this tutoroial there is a problem when second time updating the record then log table getting old record again inserting to after insert need to clear the collection pkg1.lv_log_change.delete; after add this it will working fine.

Waiting for more on this series.

Hi sir, I watch your all sql videos and it is very helpful for me. Thanks a lot for these videos. Can you please make a video on how we can refresh materialized view or a detailed video on materialized view.

Thanks for this, I've been using TSQL for a decade, switched to PLSQL recently and it was shocking how many quality of life features were missing... In TSQL you just write "SELECT * INTO #MyTemporaryTableName FROM [TableName]" and you're done :))

Great explanation!!!

Can you explain about global index vs local index

Can you pls explain about interval partition

Wonderful explanation

Siva wonderful teaching method!!!

i have a doubt but what happen if commit will allowed in trigger and why oracle will restrict commit or rollback.

Clearly explained sir. We expect more content like this. Why you have stopped posting new videos sir?

Dear sir, You taught us Truncate doesn't fires a trigger!

Great explanation

Which are different types of methods in Materialized View? What is Acid?

Great explanation. Very helpful to refresh concept

Siva, thanks for your efforts. One topic you did not cover as you said like we will not skip the collections without Bulk binding and bulk collect, right?

hi sir ... i have question joins and interview questions in joins for beginneers and also expert also can you record the video post the question

Could you please make video on performance tuning in detail

GOOD.. But UNION ALL is not very efficient optimally speaking.. i like the IN solution

ORA-01788: CONNECT BY clause required in this query block 01788. 00000 - "CONNECT BY clause required in this query block" *Cause: *Action:. I am getting this error Can you please help me to resolve this error

Procedure execution are inside the function is possible or not?

Hi Siva, At 11:04 on this video, round(987654321.12579,-9) is 0 but I guess it should be 1 billion. May be a typo at your end

Yes, today I received

Thanks Sir, We are in 2024. Does Oracle has big scope in job.

Super siva simple and clear cut❤

Thanks Dear Bro 🙏🙋‍♂️😍

Recorded morning 6 😮

great video

Thanks Sir 🙏

Hi @Siva Academy. I had these questions in latest interview. please help. 1.How to convert user input 345 to 3,4,5 using procedure 2. How to remove bracket values and return values as los angels only eg: los angels (los) Output: los angels

Very Nice

If we created composite index on three columns and we are we using in where clause only two columns or one column from that index. Will it still do the index scan ?

SIR PLEASE PROVIDE THE DATA SHEET FOR THESE COMMANDS AND TABLES ;

Perfect

very nice and simple explanation.

Start 0:09 - Decode and Case 0:45 - Understand Using Examples 2:00 - Same Thing Using Case Statement 2:45 - To Print Pass or Fail 4:01 - Exactly Same Functionality from Case statement 5:38 - Let us see with one more example 6:40 - Few more differences now 8:26 - Few More Example 9:25 - One more difference

Hi siva, i need ans how to generate date between start and end date using by procedure oracle(we should use parameter)

Start 0:21 - Types of Trigger 0:42 - What is Trigger 2:56 - Trigger Definition 3:42 - Types of Triggers 4:30 - DDL Trigger

Sir, You did greate job.👍

Start 1:19 - Some queries Examples 2:44 - Using Distinct Keyword 2:54 - With Unique Keyword 3:11 - Using Group by 4:11 - Using Union 5:19 - Union with Nulls 6:13 - Using Intersect Operator 6:35 - Using Minus Operator 7:11 - Using Row_Number () 7:55 - Using Rank or DenseRank 8:31 - Two more ways - One is Using RowID - Using Subquery 8:53 - Using RowID with Corelated Subquery 9:11 - Recap all these Queries

Start 0:31 - What is SQL 1:43 - What do you mean by communicating a Database 2:29 - There are Types of Sql 3:24 - DDL 4:40 - Truncate 4:59 - DML 5:36 - DCL 6:16 - TCL 6:49 - DRL 7:53 - Some More Languages 1:19 - Some queries Examples 2:44 - Using Distinct Keyword 2:54 - With Unique Keyword 3:11 - Using Group by 4:11 - Using Union 5:19 - Union with Nulls 6:13 - Using Intersect Operator 6:35 - Using Minus Operator 7:11 - Using Row_Number () 7:55 - Using Rank or DenseRank 8:31 - Two more ways - One is Using RowID - Using Subquery 8:53 - Using RowID with Corelated Subquery 9:11 - Recap all these Queries

Good video. i have an query .if we update the base table and the column is consumed as part of view ,will it also be updated ? .or do we need to refresh the views to see the changes

Hello Siva, I am a great fan of your SQL/PLSQL videos. I have been trying to contact you, but with no luck. Do you have any plans to conduct a complete online course? If so, please let me know. Five others will join me.

Hi bro your videos are all very useful thank you and i have Accenture interview , next week please guide me bro , if any tips please ping me personally

Start 0:09 - How to Get Records without using Unique Keyword 1:19 - Some queries Examples 1:43 - What do you mean by communicating a Database 2:29 - There are Types of Sql 3:24 - DDL 4:40 - Truncate 4:59 - DML 5:36 - DCL 6:16 - TCL 6:49 - DRL 7:53 - Some More Languages 1:19 - Some queries Examples 2:44 - Using Distinct Keyword 2:54 - With Unique Keyword 3:11 - Using Group by 4:11 - Using Union 5:19 - Union with Nulls 6:13 - Using Intersect Operator 6:35 - Using Minus Operator 7:11 - Using Row_Number () 7:55 - Using Rank or DenseRank 8:31 - Two more ways

0:30 - What is SQL 1:43 - What do you mean by communicating a Database 2:39 - There are Types of Sql 3:24 - DDL 4:40 - Truncate 4:59 - DML 5:36 - DCL 6:16 - TCL 6:49 - DRL 7:53 - Some More Languages

Start 0:14 - Rank and Denserank 2:28 - Now we will see how to write a Query

1:06 - NVL 2:02 - In Case both values are NULL 2:46 - NVL 2 4:25 - NULLIF 5:52 - Coalesce