Want To Search Something Else? Just Google It !

Wednesday, September 28, 2011

SQL DDL, DML, DCL and TCL Commands

DDL

Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:
  • CREATE - to create objects in the database
  • ALTER - alters the structure of the database
  • DROP - delete objects from the database
  • TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
  • COMMENT - add comments to the data dictionary
  • RENAME - rename an object

DML

Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:
  • SELECT - retrieve data from the a database
  • INSERT - insert data into a table
  • UPDATE - updates existing data within a table
  • DELETE - deletes all records from a table, the space for the records remain
  • MERGE - UPSERT operation (insert or update)
  • CALL - call a PL/SQL or Java subprogram
  • EXPLAIN PLAN - explain access path to data
  • LOCK TABLE - control concurrency

DCL

Data Control Language (DCL) statements. Some examples:
  • GRANT - gives user's access privileges to database
  • REVOKE - withdraw access privileges given with the GRANT command

TCL

Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.
  • COMMIT - save work done
  • SAVEPOINT - identify a point in a transaction to which you can later roll back
  • ROLLBACK - restore database to original since the last COMMIT
  • SET TRANSACTION - Change transaction options like isolation level and what rollback segment to use

17 comments:

  1. Hello,
    good collection of questions thank you for sharing. Click here to know more about SQL Interview Questions - Preparing for SQL interview

    ReplyDelete
  2. Wow it is really wonderful and awesome thus it is veWow, it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot.Devops Training in Bangalore

    ReplyDelete
  3. This is the exact information I am been searching for, Thanks for sharing the required infos with the clear update and required points. To appreciate this I like to share some useful information.python training institutes in Bangalore

    ReplyDelete
  4. I have to voice my passion for your kindness giving support to those people that should have guidance on this important matter.pega training institutes in bangalore

    ReplyDelete
  5. I really enjoy reading this article.Hope that you would do great in upcoming time.A perfect post.Thanks for sharing.best SAP S/4 HANA Simple Logistics Training in bangalore

    ReplyDelete
  6. I must appreciate you for providing such a valuable content for us. This is one amazing piece of article.Helped a lot in increasing my knowledge.best SAP S/4 HANA Simple Finance Training in bangalore

    ReplyDelete
  7. Thanks For sharing a nice post about Salesforce CRM Training Course.It is very helpful and Salesforce CRM useful for us.best SAP BASIS training in bangalore

    ReplyDelete
  8. Excellent information with unique content and it is very useful to know about the Salesforce CRM.sap sd training in bangalore

    ReplyDelete
  9. It has been great for me to read such great information about Salesforce CRM.sap mm training in bangalore

    ReplyDelete
  10. Excellent information with unique content and it is very useful to know about the information.sap finance training

    ReplyDelete
  11. It is really explainable very well and i got more information from your site.Very much useful for me to understand many concepts and helped me a lot.oracle apps technical training institutes in bangalore

    ReplyDelete
  12. Congratulations! This is the great things. Thanks to giving the time to share such a nice information.oracle sql training institutes in bangalore

    ReplyDelete
  13. The Information which you provided is very much useful for Agile Training Learners. Thank You for Sharing Valuable Information.oracle dba training institutes in bangalore

    ReplyDelete
  14. Thanks for the information...
    SAP MM Training in Bangalore | SAP MM Course | SAP MM Training Institutes - RIA Institute of Technology - Best SAP MM Training in Bangalore, Learn from best SAP MM
    Training Institutes in Bangalore with certified experts & get 100% assistance.

    ReplyDelete