PL/SQL blocks are of two groups: Named Block Anonymous Block Named Blocks: Named blocks are useful when creating subroutines. The subroutines may be procedures, functions, and even packages also. The subroutines can be stored in the database and referenced by their names later on. Anonymous Blocks: Anonymous PL/SQL blocks do not have names. As a …
Introduction to Blocks in Procedural Language – SQL Read More »
Procedures and Functions are examples of Named blocks in PL/SQL. What is stored procedure? A piece of code stored inside the DBMS Can be called from other procedures, functions, triggers, or standalone SQL allows you to define procedures and functions and store them inside DBMS Advantages of Stored Procedures and Functions: Reusability: do not need …
PL-SQL is an extension of SQL that supports the features of Programming Languages. PL/SQL stands for Procedural Language – Structured Query Language.PL/SQL is supported as internal host language in Oracle Products. Advantages of PL-SQL Acts as a host language for stored procedures and triggers. Provides the ability to add a middle tier business logic to …
Data Definition Language commands are used to create, modify the structure of the database in SQL. The following are the list of Data Definition Language Commands in SQL: CREATE Command ALTER Command DROP Command TRUNCATE Command RENAME Command COMMENT Command CREATE Command: CREATE command is used to create the table in the database. Syntax: CREATE …
Introduction to Data Definition Language (DDL) Commands Read More »
SQL is a database language that has SQL commands to create, manipulate etc the database. All the SQL commands can be broadly classified into following categories: DDL Commands DML Commands DCL Commands TCL Commands DDL(Data Definition Language) Commands: Data Definition Language commands in SQL are used to define the database schema. These commands deal with …