Oracle - DDL, DML and DCL commands

1)DDL - Data Definition Language: statements 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

2)DML - Data Manipulation Language: statements 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

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

4)TCL - Transaction Control: statements 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




Related Posts:
- ORA-01439: column to be modified must be empty to change datatype
- ORA-02438: Column check constraint cannot reference other columns
- Oracle: Delete duplicate rows from table
- Oracle 11g: Virtual Column

26 comments:

  1. SELECT command is not comes under group of DML.
    SELECT is a DQL ( Data Query langauge )

    ReplyDelete
  2. Yes i quite agree with you Ravi,select command is neccessary to issue queries on the database.

    ReplyDelete
  3. Yes SELECT comes under DRL(DQL)....

    ReplyDelete
  4. just i wanna to know how to manlublate DML in oracle so please someone help me by post URL of such my question????????????????????????

    ReplyDelete
  5. vry nice.useful one

    ReplyDelete
  6. Hello very nice website!! Guy .. Beautiful .. Wonderful ..
    I'll bookmark your web site and take the feeds also?
    I am glad to seek out a lot of helpful information right here within the post, we'd like work out more techniques in this regard, thanks for sharing.
    . . . . .

    ReplyDelete
  7. Hi there! I know this is kind of off-topic but I needed
    to ask. Does running a well-established website like yours
    take a large amount of work? I am completely new to running a blog but I do write in my journal on a
    daily basis. I'd like to start a blog so I can share my own experience and
    views online. Please let me know if you have any recommendations
    or tips for new aspiring blog owners. Thankyou!

    ReplyDelete
  8. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. data sciences

    ReplyDelete
  9. This comment has been removed by the author.

    ReplyDelete
  10. Very nice article,Thank you forsharing this unique bloh with us.
    keep updating more blogs.

    Snowflake training

    Snowflake Training in Hyderabad

    ReplyDelete
  11. Too Good Article.Keep sharing more info with us.
    Thank you.

    Devops Training in Chennai

    ReplyDelete
  12. wow! it was the nice article.thank you for sharing this.visit: online courses with certificates

    ReplyDelete
  13. New Addington is a town located in South London, England. Its population was 10,801 in 2011. This is the most promising town. If you are living there then you know there are many New Addington minicabs and taxi service, but our minicabs and taxi service is at top.

    ReplyDelete
  14. great post, thanks for sharing wonderful information about DDL, DML and DCL commands, keep posting Salesforce Classes In Pune

    ReplyDelete
  15. I found this blog post on Oracle's DDL, DML, and DCL commands extremely informative and helpful! The detailed explanation of these commands has given me a better understanding of how to manipulate and manage data in Oracle databases. The examples provided were especially useful in illustrating the practical applications of each command. Additionally, I appreciate the clear and concise language used throughout the article. This resource will undoubtedly assist anyone looking to enhance their knowledge of Oracle's command set. By the way, if you ever need assistance with your assignments, you can always find reliable help to pay someone to do my assignment online. Keep up the great work!

    ReplyDelete
  16. Exploring Oracle development is a fantastic journey to enhance technical skills. However, relying on external sources like to pay someone to do my homework hinders genuine growth. Embracing challenges and learning step by step fosters a deeper understanding. Let's commit to personal development and make the most out of Oracle's potential.

    ReplyDelete
  17. Understanding Oracle's DDL, DML, and DCL commands is crucial in the world of data management, especially for businesses like fortune real estate DDL commands help define data structures, DML manages data manipulation, and DCL ensures proper access control. For a company dealing with vast property databases, mastering these commands can ensure data integrity, efficient property listings, and secure access, ultimately enhancing the performance of their real estate operations.

    ReplyDelete
  18. A logo is an important part of any business, and London businesses are no exception. A good logo should be eye-catching and recognizable, and it should reflect the values of the business. When choosing a London logo design company, it is important to choose one that understands the London market and can create a logo that will appeal to Londoners.

    ReplyDelete
  19. Lastly, Lewes Taxi provides a seamless and hassle-free booking process. They offer multiple booking options, ranging from online reservations to a dedicated phone line. Whether you prefer to plan in advance or require immediate transportation, their user-friendly process allows you to effortlessly schedule your rides according to your needs.

    ReplyDelete
  20. However, if these are on top of your checklist, then it might be a good idea to consider social media automation for your e-commerce business. Here are a few more reasons why you should use social media automation:Online thesis writer

    ReplyDelete