SQL

Different SQL data types

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 …

Different SQL data types Read More »

Advantages and disadvantages of SQL

Advantages and disadvantages of SQL?

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: …

Advantages and disadvantages of SQL? Read More »