Breaking News: Grepper is joining You.com. Read the official announcement!

dml ddl dcl in sql

sandy_inspires answered on October 4, 2022 Popularity 10/10 Helpfulness 3/10

answer dml ddl dcl in sql

dml ddl dcl in sql

Comment

/*
DDL (Data Definition Language)

    CREATE: This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers).
    DROP: This command is used to delete objects from the database.
    ALTER: This is used to alter the structure of the database.
    TRUNCATE: This is used to remove all records from a table, including all spaces allocated for the records are removed.
    COMMENT: This is used to add comments to the data dictionary.
    RENAME: This is used to rename an object existing in the database.

DQL (Data Query Language):

    SELECT: It is used to retrieve data from the database.

DML(Data Manipulation Language):

    INSERT : It is used to insert data into a table.
    UPDATE: It is used to update existing data within a table.
    DELETE : It is used to delete records from a database table.
    LOCK: Table control concurrency.
    CALL: Call a PL/SQL or JAVA subprogram.
    EXPLAIN PLAN: It describes the access path to data.

DCL (Data Control Language): 

    GRANT: This command gives users access privileges to the database.
    REVOKE: This command withdraws the user’s access privileges given by using the GRANT command.

TCl ( Transactional Control Language)

    COMMIT: Commits a Transaction.
    ROLLBACK: Rollbacks a transaction in case of any error occurs.
    SAVEPOINT:Sets a savepoint within a transaction.
    SET TRANSACTION: Specify characteristics for the transaction.
    */

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: dcl ddl dml sql

Link to this answer
Share Copy Link

Contributed on Oct 04 2022

sandy_inspires

0 Answers Avg Quality 2/10

dml ddl dcl in sql

Contents

More Related Answers

dml ddl dcl in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.