java2db

SQL & PL/SQL

Structured Query Language allows end users to manipulate information of the table.To use SQL
you not to require any programming experience. SQL is a standard language common to all relational databases .
SQL is database language used for storing and retrieving data from the database.
Most Relational Database Management Systems provide extension to SQL to make it easier
for application developer.
Structured Query Language (SQL)
  How to create a table using SQL .
  Insert record in table using sql .
  Alter table to add and drop the column or columns .
  Sql ALTER to modify and rename the table column .
  Update column values of a table with sql .
  Use of WHERE clause in sql .
  SELECT statement to get records from the table in sql .
  Delete a record from the table with sql .
  Sql INNER JOIN on tables with an example .
  Sql LEFT OUTER JOIN on tables with an example .
  Sql RIGHT OUTER JOIN on tables with an example .
  Sql FULL OUTER JOIN on tables with an example .
  Sql PRIMARY KEY constraint on table column .
  Sql UNIQUE constraint on table column .
  Sql NOT NULL constraint on table column .
  Sql CHECK constraint on table column .
  Sql FOREIGN KEY constraint on table column .

pl/sql

Procedural Language/Structured Query Language(PL/SQL)
  PL/SQL variables .
  PL/SQL Operators .
  PL/SQL Sequential control flow statements .
  PL/SQL Loop control flow statements .
  PL/SQL Collections .
  PL/SQL Object oriented concepts .
  PL/SQL Procedures .
  PL/SQL Functions .
  PL/SQL Triggers .

^ <