6/30/12

Variables and Constants in PL/SQL

This is out first of many tutorial in the PL/SQL series. Today we will be discussing about variables and coonstants in PL/SQL. PL/SQL stands for Procedural Language to Structured Query Language. We can use PL/SQL in the Oracle relational databases, in Oracle Server, and in client-side application...

6/26/12

SQL Data Control Language (DCL) Tutorial

After doing tutorials on DML (Data Manipulation Language) and DDL (Data Definition Language), we will be learning about one more language used in SQL called the Data Control Language (DCL). As we saw in our previous tutorials on SQL, that with the help of DDL we can define tables, databases, views...

6/23/12

SQL Data Definition Language (DDL) Tutorial

After writing a post on Data Manipulation Language (DML), here is another tutorial in SQL series on DDL i.e. Data Definition Language. DDL (Data Definition Language) statements are used to build and modify the structure of your tables and other objects in the database. When you execute a DDL...

6/15/12

SQL Tutorial on Data Manipulation Language (DML)

After writing a tutorial on SQL Baiscs, long back, here I am writing again on SQL, but this time on DML i.e. Data Manipulation Language. By the full form of DML we understand that with the help of this we will be able to manipulate data. Now what kind of manipulation can we do might be the...

6/10/12

6/3/12

Creating a Basic JDBC application

Today we will be creating a Basic JDBC application i.e. an application that will be able to retrieve information (student_name, roll_no, class, DOB, etc) from the database. I already gave a tutorial on connecting SQL Server using JDBC-ODBC Bridge. To do the above we will need to make use of the...