I will Explain What is an Index ( Advantages and Disadvantages ) in Oracle Database in this Article. 4,032 views last month
Read More »Oracle
How to Install Enterprise Manager Cloud Control 13c ( EM 13c ) Agents on Microsoft Windows Target Hosts
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 …
Read More »How to Change Hostname of a Standalone Oracle Restart ( ASM )
Hi, I will explain How to Change Hostname of a Standalone Oracle Restart ( ASM ) in this article. 3,369 views last month
Read More »What is the Database Auditing in Oracle
I will explain What is the Oracle Database Auditing in this article. 3,211 views last month
Read More »How to Restore Oracle Database ( Controlfile, Datafile, Archivelog ) via RMAN from Tape Backup
I will explain How to Restore Oracle Database ( Controlfile, Datafile, Archivelog ) via RMAN from Tape Backup in this Article. 3,856 views last month
Read More »Oracle DataGuard Physical Standby Installation Step by Step Using RMAN -2
Hi, I will continue to explain Oracle DataGuard Physical Standby Step by Step Installation in this article. 4,182 views last month
Read More »Oracle DataGuard Physical Standby Installation Step by Step Using RMAN -1
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
Read More »Oracle SQL Tutorials – Chapter 3 (Part 3 of 3)
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. …
Read More »Oracle SQL Tutorials – Chapter 3 (Part 2 of 3)
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; …
Read More »Oracle SQL Tutorials – Chapter 3 (Part 1 of 3)
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 …
Read More »