Forums: SQL PL/SQL

As all you know, relational tables are, well, tabular—that is, they are presented in a column-value pair. Consider the case of a table named EMP . ...

INSERT is the one of the most widely used DML Statements in Oracle (or in any Database). There are different ways of inserting into One table in...

DELETE is another widely used DML in SQL . It is used to delete the records with some values specified in the query. Hope this article will be useful...

MERGE statements was introduced in Oracle 9i . This command was beneficial for the ETL (Extraction, Transformation, and Loading) part of any Business...

ORA-02292 Error or ORA-02449 Error Now, I see many people facing the ORA-02292 error and frantically look for help, when it's really such a simple...

Summary of Predefined PL/SQL Exceptions An internal exception is raised automatically if your PL/SQL program violates an Oracle rule or exceeds a...

CASE and DECODE are the two widely used constructs in the SQL . And both have the functionality of an IF-THEN-ELSE statement to return some specified...

SQL Plus is the de facto tool to manipulate sql code for the Oracle Database. SQL Plus was initially known as UFI for User Friendly Interface which...

Many a times we face a situation wherein a particular row or rows from a table are locked by some application/users and it causes our queries to not...

Nested Tables and Varrays -------------------------------------------------------------------------------- Modified 28-MAY-2009 Type...

USE EXISTS IN PLACE OF DISTINCT visit for more information "allmyneed.blogspot . com" The DISTINCT combination of deptno and dname columns have...

Convert decimal to hexadecimal There are several ways to convert decimal number to hexadecimals. Like using function, using complex sql...

Oracle Date Functions I wanted to compile a list of all possible DATE functions in oracle. I am listing a few common ones to begin with, and I...

SQL Commands Basics This document contains absolute SQL Basics for the beginners (like me!). SQL stands for Structured Query Language. SQL is a...

PL/SQL allows developers to define their own exceptions.User can define the error/exception programically based on the business rule. This is usually...

Predefined exceptions in PL/SQL Predefined exceptions in PL/SQL are declared globally in a package called STANDARD, defining the PL/SQL...

JOINS are used in SQL to combine rows fom Multiple table to reqtrieve the required information.There are basically two types of joins Equi joins and...

UPDATE is another widely used DML in SQL . It is used to update the records with some values specified in the query. There are different scenarios...

PL/SQL Package Example The following package demonstrates all the features required in a proposed web-based database solution. The purpose of...