Oracle

I will Explain What is an Index ( Advantages and Disadvantages ) in Oracle Database in this Article.  3,562 views last month,  6 views today

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.  2,920 views last month,  3 views today

I will explain What is the Oracle Database Auditing in this article.    2,707 views last month,  1 views today

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

Hi, I will continue to explain Oracle DataGuard Physical Standby Step by Step Installation in this article.  3,759 views last month,  2 views today

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

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 …