Scalar Attribute in PLSQL
If you want declare a variable and it’s data type is same as one column’s data type in one some table then you use scalar attribute. The above data…
Showing posts with the label DatabaseShow all
Data Type in PL/SQL
To design a programme using a language the minimum requirement is a variable and variable minimum requirement is data type. PL/SQL provides two ty…
Wildcard Operator
Wildcard Operator/Like Operator: The like operator is used to compare a value to similar values using wildcard operators. It always use Like oper…
Comments Line in PL/SQL
The PL/SQL supports single line and multi-line comments. All characters available inside any comment are ignored by PL/SQL compiler. The PL/SQL sing…
Identifiers in PL/SQL
PL/SQL identifiers are constants, variables, exceptions, procedures, cursors, and reserved words. The identifiers consist of a letter optionally fo…
Overview – PL/SQL
PL/SQL is pronounced as a language but it is not a language typically rather than it is a mechanism or technology implemented on Oracle server to ma…
Data Control Language (DCL) in SQL
ORACLE not only provides several diff. objects for customized database management but also it supports user concept or schema concept to protect th…
Transaction Control Language(TCL) in SQL
Whenever DML operation is main in an oracle table, the transaction never be saved unless or until save command is issued or a discard is issued. TC…
Data Manipulated Language in SQL
DML is also known as RML, which is Responsible to manipulated language, the records of table and statements are given below Insert, update, delet…
Constraints in SQL
“ Constraint is rule or restriction imposed and individual column to above data enter “ Oracle provide the following constraint to do so 1. …
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's.
