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
SELECT command is not comes under group of DML.
ReplyDeleteSELECT is a DQL ( Data Query langauge )
Yes i quite agree with you Ravi,select command is neccessary to issue queries on the database.
ReplyDeleteYes SELECT comes under DRL(DQL)....
ReplyDeletevery nice article...
ReplyDeletejust i wanna to know how to manlublate DML in oracle so please someone help me by post URL of such my question????????????????????????
ReplyDeletevry nice.useful one
ReplyDeleteHello very nice website!! Guy .. Beautiful .. Wonderful ..
ReplyDeleteI'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.
. . . . .
Hi there! I know this is kind of off-topic but I needed
ReplyDeleteto 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!
hello
ReplyDeleteThank 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
ReplyDeleteIt is so nice article thank you for sharing this valuable content.
ReplyDeleteworkday online course
workday training online
workday software training
This comment has been removed by the author.
ReplyDeleteVery nice article,Thank you forsharing this unique bloh with us.
ReplyDeletekeep updating more blogs.
Snowflake training
Snowflake Training in Hyderabad
Too Good Article.Keep sharing more info with us.
ReplyDeleteThank you.
Devops Training in Chennai
Nice Blog.. Thanks a lot comodo ssl certificate india
ReplyDelete
ReplyDeleteReally nice and awesome Post.. Like it !!
briansclub
briansclub cvv
wow! it was the nice article.thank you for sharing this.visit: online courses with certificates
ReplyDeleteNew 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.
ReplyDeletegreat post, thanks for sharing wonderful information about DDL, DML and DCL commands, keep posting Salesforce Classes In Pune
ReplyDeleteI 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!
ReplyDeleteExploring 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.
ReplyDeleteUnderstanding 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.
ReplyDeleteA 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.
ReplyDeleteThank you for sharing this useful information. Ui Ux training in chennai
ReplyDeleteLastly, 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.
ReplyDeleteHowever, 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
ReplyDeleteGreat post on Oracle’s DDL, DML, and DCL commands! These concepts are essential for managing databases efficiently, much like Palco Specialties creates well-structured platform units for theater stages. Just as Oracle commands streamline database operations, Palco's platform units offer versatile and stable solutions for stage design. Whether it’s a small production or a large performance, having the right platform units ensures the setup is seamless, just like a smooth database process!
ReplyDeleteGreat and I have a swell give: What Renovations Can You Claim On Tax victorian home renovation
ReplyDeleteGreat insights on Oracle's DDL, DML, and DCL commands! Just like mastering these commands is essential for managing databases, choosing the right fabric is crucial for fashion. For instance, the Florent Lawn Online collection from Al Karim Fabric offers a variety of stylish and comfortable options for those looking to elevate their wardrobe. Their attention to detail and quality is as meticulous as writing perfect SQL commands, ensuring you always look your best!
ReplyDelete