sql interview question

How to find long running SQL query in Oracle

March 8, 2023 by admin

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 …

SQL Interview Questions and Answers

December 27, 2022 by admin

SQL Interview Questions and Answers Question: What is recursive stored procedure in Oracle PL/SQL ? Answer: Recursive PL/SQL stored procedure in Oracle means a stored procedure which calls by itself until it reaches some boundary condition. Example: create or replace procedure fact ( x in number, f out number ) as Begin if x = …