Friday, 27 June 2014

undefined undefined
There are 4 types of sql functions
1.DML
2.DDL
3.DCL
4.TCL

Now lets see one by one

1.DML

DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.


Examples: SELECT, UPDATE, INSERT statements


Select :- This Sql Statement is used to extract the data from one or combination of tables
Update:- This Sql Statement is used to update the data in a database table.
Delete:- This Sql Statement is used to delete data from the database table.
Insert Into :- This Sql Statement is used to insert data into a database(table)


2.DDL

DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database.


Examples: CREATE, ALTER, DROP statements


Create Table:- This Sql Statements is used to create a Table
Alter Table:- This Sql Statement is used to Alter the table definition like adding any columns or deleting any table column.
Drop table:- This Sql Statement is used to Drop the table.
Create Index:- This Sql Statement is used to Create a Index on a table
Drop Index:- This Sql Statement is used to drop a table from the table


3.DCL

DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.


Examples: GRANT, REVOKE statements
Grant :- This Sql Statement is used to give access rights to the user for the database
Revoke:- This Sql Statement is used to revoke or delete the access rights of some of the users for a given database.


4.TCL

TCL is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.


Examples: COMMIT, ROLLBACK statements


Commit:- This command is used to save the work done by the user.
Rollback:- This command is used to delete the data till the last committed state of the database.

Related Posts:

  • SQL Functions(ddl,dml,dcl & tcl) with Examples There are 4 types of sql functions 1.DML 2.DDL 3.DCL 4.TCL Now lets see one by one 1.DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in databa… Read More
  • Database administration queries Database administration queries Database version informationReturns the Oracle database version. SELECT * FROM v$version; Database default information Some system default information. SELECT username,profile,default_ta… Read More
  • Oracle date and time function related queries Date / Time related queries Get the first day of the month Quickly returns the first day of current month. Instead of current month you want to find first day of month where a date falls, replace SYSDATE with any date colu… Read More
  • Most Important Data dictionary Queries.. Data dictionary queries Check if a table exists in the current database schema A simple query that can be used to check if a table exists before you create it. This way you can make your create table script rerunnable. Just… Read More
  • Normalization In SQL Normalization In SQL,MY SQL and Oracle What is normalization ? Defination : Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process:  1. eliminat… Read More

0 comments:

Post a Comment

Copyright © 2025 ORACLE-FORU - SQL, PL/SQL and ORACLE D2K(FORMS AND REPORTS) collections | Powered by Blogger
Design by N.Design Studio | Blogger Theme by NewBloggerThemes.com