In this topic, you will learn about, What are the different SQL data types? The major data types in PL/SQL include NUMBER, CHAR, VARCHAR2, DATE, and TIMESTAMP. Numeric variables: To define a numeric variable, the programmer appends the variable type NUMBER to the name definition. To Syntax: variable_name number([P,S]) := 0; Character variables: To define …
In this tutorial, you will learn about, What is SQL? What are the advantages and disadvantages of SQL? SQL: It stands for Structured Query Language used to develop, maintain a database. It is a type of procedural language divided into various parts. DDL: It stands for Data Definition Language. DML: It stands for Data Manipulation Language. DCL: …
In this topic, you will learn about, What is joins. Discuss the different types of Joins. Joins: A SQL join clause combines records from two or more tables based on a common field in a relational database. It creates a set that can be saved as a table or used as it is. A JOIN …
What is joins Discuss the different types of Joins Read More »
In this topic, you will learn about, Advantages and disadvantages of a trigger. A trigger in SQL is a sequence of actions that results in a change in the table of a database. It is activated when the contents of the table of a database are modified. Advantages of triggers: It executes randomly. It cannot …
