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
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 »Online Table Redefinition and Partitioning using DBMS_REDEFINITION in Oracle
Hi, I will explain Online Table Partitioning using the DBMS_REDEFINITION in Oracle database in this article.
Read More »Partitioning Types ( Range , List, Hash, Interval .. ) in Oracle Database
Hi, I will explain Partitioning Types in Oracle Database in this article.
Read More »Partitioning in Oracle Database
Hi, I will explain you a beautiful technology such as Partitioning that exists in almost all Database management systems In this article.
Read More »Data Redaction ( dbms_redact ) in Oracle Database -2
Hi, I will continue to explain Data Redaction in Oracle Database in this article.
Read More »Data Redaction ( dbms_redact ) in Oracle Database -1
Hi, I will explain Data Redaction in Oracle Database in this article.
Read More »Transparent Data Encryption ( TDE ) in Oracle
Hi, I will explain what is the Transparent Data Encryption in Oracle in this article.
Read More »Oracle ORAchk | Database Health Check with Orachk
I will explain how to perform Database Health Check with Oracle ORAchk in this article. Let’s review the ORAchk – Database Health Check
Read More »Oracle OSWatcher Usage and OSWatcher Performance Reports ( OSWatcher logs for particular time )
I will explain Oracle OSWatcher Usage and its Performance Reports in this article.Let’s review the Oracle OSWatcher Performance Reports
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial