PLSQL program to check whether a date falls on weekend

Write a PLSQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY. Here is a PLSQL program to check whether a date falls on a weekend (Saturday or Sunday): DECLARE input_date DATE; day_of_week VARCHAR2(10); BEGIN — Ask the user to input a date input_date := &input_date;— Use the TO_CHAR function to …

Read more

How to find long running SQL query in Oracle

How to find long running SQL query in Oracle

How to find long running SQL query in Oracle: There are several ways to find long-running SQL queries in Oracle: Using the V$SQL view: The V$SQL view provides information on all SQL statements that have been executed in the database. By querying this view, you can find the SQL statements that have taken the longest …

Read more