Oracle

I will Explain What is an Index ( Advantages and Disadvantages ) in Oracle Database in this Article.  4,032 views last month

I will explain How to Install Enterprise Manager Cloud Control 13c ( EM 13c ) Agents on Microsoft Windows Target Hosts in this article. Let’s review the Install EM Cloud …

Hi, I will explain How to Change Hostname of a Standalone Oracle Restart ( ASM ) in this article.  3,369 views last month

I will explain What is the Oracle Database Auditing in this article.    3,211 views last month

I will explain How to Restore Oracle Database ( Controlfile, Datafile, Archivelog ) via RMAN from Tape Backup in this Article.  3,856 views last month

Hi, I will continue to explain Oracle DataGuard Physical Standby Step by Step Installation in this article.  4,182 views last month

I will explain Oracle DataGuard Physical Standby Step by Step Installation in this article. Let’s review the Oracle DataGuard Physical Standby Installation.  4,120 views last month

CONVERSION FUNCTIONS TO_CHAR (DATE) TO_CHAR(date, ‘format’) It’s case-sensitive and must be written between quotes. It must contain a valid date format. Let’s list the hire dates of employees like below. …

NUMERIC FUNCTIONS ROUND Let’s try some different usages of the ROUND function. SELECT ROUND (45.923), ROUND (45.943, 1), ROUND (45.924, 2), ROUND (44.923, -1), ROUND (55.923, -2) FROM DUAL;   …

Chapter 3 – Single Row Functions Charcter Functions Numeric Functions Date Functions Converting Functions NVL Function Decode Function CASE Statement   SQL FUNCTIONS SQL Functions can be classiifed under 2 …