SQL Terms : keyword, Clause and Statement

If your are a SQL learner then there are some terms you have to know. I see, event the experienced SQL professional do mistakes about the terms. This page tell you several terms of SQL, that you must have to know. This page discuss about the terms keyword, clause and statement. Moreover, you can differentate among keyword, clause and statement. After reading this page you basic must be strong. Now, read the following things...

Clause

Some part of the SQL statement is known as Clause. Generally, each clause is written one line. But there is no hard rule like that.

Example of Clause: A clause may like the following

SELECT studentID, Department

Keyword

An individual SQL element is known as SQL keyword. Many books and people often say that all the letters of keyword will be capitalized. But it doesn't have any impact on SQL query. You may you lower case letter to write keywords.

Examples of keyword: SELECT, FROM etc. are keywords.

Statement

A statement is the combination of two or more clauses. Statement has the full meaning. By using statement all types of query are retrieved form Oracle database. Statement always ends with one semicolon.

Example of statement:: One example of statement is given below:

SELECT studentID, Department
FROM students;

Summary of this page

  • Keyword is an individual SQL element.
  • Clause is a part of SQL statement.
  • Statement is the combination of 2 or more clauses.
  • Example:
         SELECT studentID, department
         FROM students;

Here,

Keyword   : SELECT, FROM
Clause    : SELECT studentID, department
Statement : SELECT studentID, department 
            FROM students;


For more tutorials, visit ORACLE INDEX

 
 

© Written by rancidTaste

If you are enjoyed this post, please consider to give a thumbs up and leave a comment. You may Subscribe to rancidTaste's RSS feed to get new pages which will be delivered to your feed reader. You can also read more hubs by rancidTaste.

JOIN HUBPAGES & ENJOY WORLD'S BEST WRITINGS

More by this Author


Comments

No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working