CTE (Common Table Expression) Common Table Expression, also called as CTE in short form, is a...
Author - shohal
Character-Manipulative Functions
Character-Manipulative Functions Character-Manipulative Functions (CONCAT, LENGTH, SUBSTR, INSTR...
Sorting by Multiple Columns
Sorting by Multiple Columns For example, to sort person by their first names in ascending order and...
Sorting by Column Aliase(āĻāĻĻā§āĻŽāĻ¨āĻžāĻŽ)
Sorting by Column Aliase(āĻāĻĻā§āĻŽāĻ¨āĻžāĻŽ) SQL aliases are used to give a table, or a column in a table, a...
Sorting Data Order By Clause in Oracle SQL
ORDER BY keyword is used to sort the result-set in ascending or descending order. ORDER BY Example...
Single Row Functions
Case-manipulation functions Lower, Upper and Initcap are the three Case-manipulation/ Case...
What is normalization in Sql Server
Normalization is the process of organizing data to minimize data redundant(āĻ āĻ¨āĻžāĻŦāĻļā§āĻ¯āĻ(data...
What is subquery in sql server?
A subquery is a query that is nested (āĻŦāĻžāĻ¸āĻž āĻŦāĻžāĻāĻ§ā§)inside a SELECT , INSERT , UPDATE , or DELETE...
What is The %ROWTYPE Attribute in PL/SQL?
The %ROWTYPE attribute provides a record type that represents a row in a database table. The record...
What is system trigger?
System Trigger fires when a system event like database startup, shutdown or DDL operations like...