Category: Oracle

Oracle PLSQL Interview questions and answers 0

Oracle PL/SQL Interview Questions & Answers – Part I

1. What is the difference between Stored Procedure and Function? Ans. Following are some of the major differences between Stored Procedure and Function a. Stored procedure can call function but function cannot call stored...

Oracle DBMS_SCHEDULER Jobs 0

Oracle DBMS_SCHEDULER Jobs

Oracle 10g has extended the scheduler functionality for DBMS_JOB package by introducing DBMS_SCHEDULER jobs. Since it is a server-based architecture, hence every process will run on server instead of running on client machine. Oracle...

0

Oracle EXISTS vs DISTINCT

Avoid joins that require the DISTINCT qualifier on the SELECT list when you submit queries that are used to determine information at the owner end of a one-to-many relationship (e.g., departments that have employees)....

Oracle Tracing SQL Code by using SQL Trace and TKProf 0

Oracle Tracing SQL Code by using SQL Trace and TKProf

If you are running any query in oracle and you want to know what is running in background then the simplest way is to trace the session. On tracing of session, trace file is...

oracle lock query 0

Oracle Query to Check Lock on Rows and Objects

Locks can occur whenever any session holds exclusive lock on any specific object and another session tries to update the same record.  This lock will get released only when first session completes its work....