How to use TK-Proof in Oracle

This article explains how to use the Tk-prof utility in Oracle.  TK-Proof in Oracle TK-Prof is a utility by Oracle database to trace the performance of query within PL/SQL block. Steps to use TK-Prof: alter session set tracefile_identifier =’cur_for_loop’; alter session set timed_statistics=true; EXECUTE DBMS_SESSION.SESSION_TRACE_ENABLE(WAITS=>TRUE, BINDS=>TRUE); set serveroutput on; — —————————————————————————— — Populating the data …

How to use TK-Proof in Oracle Read More »

How to use Data Pump in Oracle:

This article explains how to use Data Pump in Oracle to export/import data to/from the Oracle cluster. Data pump is a Utility provided by Oracle to Export(EXPDP)/Import(IMPDP) the data to/from the new/old Oracle cluster started from Oracle 10g(10.1), which are performance-wise better as compared to the original Export(EXP) and Import(IMP) utilities. It supports different modes …

How to use Data Pump in Oracle: Read More »

Create tables and generate data dynamically using DYNAMIC SQL

This article will be helpful for multiple database users like Oracle / PostgreSQL / EPAS (EDB Postgres Advanced Server) users to CREATE random tables, INSERT random data into those tables, and DROP those tables at one go, using few stored procedures and Dynamic SQL within. Oracle Database: — Create N number of tables with X …

Create tables and generate data dynamically using DYNAMIC SQL Read More »

Collections in oracle pl sql with examples

With this article, we will know how to create and use PL/SQL collection and record variables. All these composite variables have elements that we can treat as individual variables. We can pass composite variables to subprograms as a parameter.To create a collection or record variable, first we need to define a collection or record type, …

Collections in oracle pl sql with examples Read More »

Nested SubProcedure

Nested SubProcedure Purpose of Nested SubProcedure/Function: A Nested function/procedure definitions are a form of information hiding and are useful for dividing procedural tasks into subtasks which are only meaningful locally.  This avoids confusion with other parts of the program with functions and variables that are unrelated to those specific parts. After go through the below …

Nested SubProcedure Read More »

SQL Cheat sheet

SQL Cheat sheet: After following this SQL Cheat sheet we will be in a position to understand quickly and use SQL statement as per requirements.  Below are the SQL commands Cheat sheet mentioned which perform different kinds of operations. Various SQL types: DRL, DDL, DML, TCL, DCL  DESCRIPTION select syntax: DRL: DATA RETRIEVAL LANGUAGE COMMANDS …

SQL Cheat sheet Read More »

Twitter
YouTube
Pinterest
LinkedIn