Backup Table in SQL
Backup Table in SQL, as the name suggests, is the copy of an existing table whose backup we need to take . Constraints on the original table are not copied in the Backup table...
Tagged: SQL Tutorial
Order By Clause in SQL
Order By Clause in SQL is used to sort the resultset in ascending or descending order. Key – Points : By default it sorts the result in Ascending order. Asc Keyword is used for...
Anonymous PL/SQL Block
Definition : The PL/SQL block that has no name is called Anonymous PL/SQL Block. Structure : Since the Anonymous Blocks have no names , therefore the header section is completely missing. They only consist...
Null Functions
Null Functions : Null Functions are used to handle Null values . Following different kinds of Null Functions are available in Oracle. 1. NVL Function : NVL stands for Null Value. This Function is...