View RSS Feed

Java Database

Sql

Rate this Entry
by , 03-09-2012 at 07:21 PM (692 Views)
Databases are accessed by usage of a standard language SQL. It is used for the manipulation and also to access the data, in following.
  • MySQL
  • DB2
  • Access
  • Oracle
  • SQL Server
  • Sybase


The SQL language consist of these language elements:

  • Clauses: Clauses are considered to be the constituent components of queries and statements.
  • Expressions: They can produce tabular data or scalar values which comprises of columns & rows.
  • Predicates: conditions are specified which can be evaluated to SQL
  • Queries: data is retrieved based on criteria.
  • Statements:. Hold a permanent effect at data. It controls connections, transactions, program flow and sessions.

Submit "Sql" to Facebook Submit "Sql" to Digg Submit "Sql" to del.icio.us Submit "Sql" to StumbleUpon Submit "Sql" to Google

Tags: sql Add / Edit Tags
Categories
SQL

Comments