_gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(ga); })();

Types of SQL Statement

On June 16, 2009 / By admin / In Oracle / Reply

What are the types of SQL Statement ?

 

Data Definition Language :
CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

Data Manipulation Language:
INSERT,UPDATE,DELETE,LOCK

TABLE,EXPLAIN PLAN & SELECT.Transactional Control:
COMMIT & ROLLBACKSession Control: ALTERSESSION & SET

ROLESystem Control :
ALTER SYSTEM.

Related posts:

  1. Concurrency What is concurrency?   Cuncurrency is allowing simultaneous access...
  2. After commit statement What will happen after commit statement ?   Cursor...
  3. Types of database triggers  How many types of database triggers can be specified...
  4. Generating an EXPLAIN plan How would you go about generating an EXPLAIN plan?...
  5. Usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE...

Related posts brought to you by Yet Another Related Posts Plugin.

Reply

Spam Protection by WP-SpamFree