Mindsforest

Home / SQL tutorial

Showing posts with label SQL tutorial. Show all posts

DATE Functions in SQL / PL/SQL

select to_char(sysdate,'MON YY')FROM DUAL; SELECT LAST_DAY(SYSDATE) FROM DUAL; SELECT next_DAY(SYSDATE,'SUN') FROM DUAL...

ORACLE/PLSQL: TO_DATE FUNCTION This Oracle tutorial explains how to use the Oracle/PLSQL TO_DATE function with syntax and examples. ...

SQL SERVER: COALESCE FUNCTION This SQL Server tutorial explains how to use the COALESCE function in SQL Server (Transact-SQL) with s...

This Oracle tutorial explains how to use the Oracle/PLSQL SIGN function with syntax and examples. DESCRIPTION The Oracle/PLSQL SI...

SQL SERVER: REPLACE FUNCTION This SQL Server tutorial explains how to use the REPLACE function in SQL Server (Transact-SQL) with syn...

You can rename a table or a column temporarily by giving another name known as alias. The use of table aliases means to rename a table i...

The SQL NULL is the term used to represent a missing value. A NULL value in a table is a value in a field that appears to be blank. A ...