3
Reply

What are Stored Procdeures & Explain DDL, DML and DCL commands with examples in SQL Server or Oracle?

RAHUL DEOLE

RAHUL DEOLE

10y
8.5k
0
Reply

    A Set of SQL Statements that is Pre-Compiled and Stored in Database.DML - DATA MANIPULATION LANGUAGE - SELECT, INSERT, DELETE, UPDATEDDL - DATA DEFINITION LANGUAGE - CREATE, DROP, ALTERDCL - DATA CONTROL LANGUAGE - GRANT, REVOKE

    Stored Procedures are a batch of SQL statements that can be executed in a single query.Please refer: http://www.orafaq.com/faq/what_are_the_difference_between_ddl_dml_and_dcl_commands

    A stored procedure is a subroutine use to access a RDBMS from your application. DDL - data definition language - purpose is to modify the schema of the database by adding, changing, or deleting definitions of tables or other objects. Eg; create, drop, alter DML - data manipulation language - purpose is to insert, delete, modify data in the database. Eg: select, insert, update, delete DCL - data control language - purpose is to control access to the database. Eg: grant, revoke