Category: 12c SQL

Concatenating two values in SQL Statement

In this post, we are going to learn about concat() and concat operaotor. Concat() CONCAT returns char1 concatenated with char2. Both char1 and char2 can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2,...

Order by clause in SQL statement

Order By clause: Order by can be used to display the results in ascending or descending order. Use the ORDER BY clause to order the rows selected by a query. Sorting by position is...

Index in Oracle SQL and Types of indexes

An index is an optional structure, associated with a table or table cluster, that can sometimes speed data access. By creating an index on one or more columns of a table, you gain the...

View sequence and Synonym in SQL

Other schema objects in SQL: There are various schema other schema objects available in database apart from tables. They are 1 view 2 Sequence 3 Index 4 Synonym View in Oracle SQL A View...

SET operators in SQL

Using the SET Operators Set operators combine the results of two component queries into a single result. Queries containing set operators are called compound queries. There are four types of set operators, they are...

Data Manipulation Language in SQL

Data manipulation language (DML) Data manipulation language (DML) statements to access and manipulate data in existing schema objects. These statements do not implicitly commit the current transaction. Some of the important data manipulation language...

Subqueries in Oracle SQL

Subqueries (also known as inner queries or nested queries) is a tool for performing operations in multiple steps. For example, if you wanted to take the sums of several columns, then average all of...

SQL group by statement

Grouping data is one of the most important tasks in SQL. The SQL GROUP BY Statement in SQL is used to arrange identical data into groups with the help of the group functions. i.e...

Group functions in SQL statement

Group functions in SQL address the summary information such as average, count etc., for a group of rows. This post is all about how to group a set of rows in a table into...

Explicit Datatype Conversion in SQL statement

Explicit Datatype Conversion in SQL statements like TO_CHAR, TO_DATE, TO_NUMBER Explicit means that you must specify how the data type should be converted. If you don’t specify how SQL Server should convert the data...