Category - Database

SQL

Character Functions in Oracle

These functions are going to be working on string expressions and integer values. Oracle supports the following character functions, let us learn one after the...

SQL

Numeric Functions in Oracle

Numeric Functions are going to be work on only numeric values that is an integers and decimals. Oracle supports following numeric functions which we will learn...

SQL

Functions in Oracle

function is a block of code that performs a specific task and gives single result to the user. All databases are supporting two types of functions, those are...

SQL

Creating Alias Names in SQL

Alias Name is nothing but duplicate or temporary or alternative name for a table or columns. In SQL, user can create two types of aliases in database...