SQL Server ROLLUP The SQL Server ROLLUP is a subclause of the GROUP BY clause which provides a...
Author - shohal
What is DML and DDL trigger in PL/SQL?
DML Trigger: TRIGGERS are stored programs that are fired by Oracle engine automatically when DML...
What is Null Statement ?
Null Statement The null statement is a null keyword followed by a semicolon(;). What is the meaning...
Triggers-SQL Server
Triggers-SQL Server A SQL trigger is a database object which fires when an event (example :...
Oracle Interview Questions
What are the components of logical database structure in Oracle database? Components of logical...
PL/SQL (Procedural Language extensions to the Structured Query...
What is PL/SQL? PL/SQL is an advance version of SQL. PL/SQL stands for procedural(পদ্ধতিগত)language...
What is equi-join, non equi-join, outer join, self join...
This is a short summery of equi-join, non equi-join, outer join, self join, Cartesian-Products .
Difference between variable and constant?
Well, This is a short summery of Variable and constant ,I just Written.
SQL Constraints
What is Constraints ? Constraints is a rule and regulation for entering any data in a table. Every...
What is Oracle / PLSQL Joins?
Well, This is a short summery of Oracle/PLSQL Joins ,I just Written.