Sql Interview Questions

Some of the SQL Interview questions, that are frequently asked… Read More »

Sql Command catogories

Procedure is program unit that performs some specific task..Read More »

Sql Divisions or Comand Types

Sql Divisions can be in the following ways… Read More »

Sql Opearators

Sql Divisions can be in the following ways… Read More »

Group by/Order by/Having Clause in Sql

The Usage of Group by/Order by/Having in Sql..Read More »

Built in Functions in Oracle

Some Of the built in functions in Oracle are...Read More »

Frequently Used Data Dictionary Queries

There are some important Queries, everyone should know… Read More »

SQL*Loader Example

Sql*Loader is an Utility of oracle to load data from file to tables...Read More »

PL/SQL Block Architecture

Pl/Sql Block Architecture contains Three parts 1. declare 2. Begin 3. End..Read More »

Scope Of the pl/Sql Variables

Procedure is program unit that performs some specific task..Read More »

PL/SQL Naming Conventions

Procedure is program unit that performs some specific task..Read More »

PL/SQL Procedures

Procedure is program unit that performs some specific task..Read More »

Pl/SQL Packages

PL/SQL Packages is schema object and collection of related data type … Read More »

PL/SQL Exceptions

PL/Sql Exceptions can be of two types 1. compile time 2. Run time… Read More »