I will explain How to Move Tables, Index Rebuild, Partitions and Subpartitions to Another Tablespace in Oracle in Oracle. 2,008 views last month, 3 views today
Read More »Oracle
How to Kill or Stop Oracle Datapump Import ( KILL IMPDP ) Job
When you start import in Oracle database with impdp command, you may want to kill ( impdp ) or stop these jobs. I will explain the How to Kill or …
Read More »How to Monitor RMAN Backup and Long Operations in Oracle
Hi, If you have big database about more than 1 TB, then your backup and export operations are taking long times. 1,260 views last month, 2 views today
Read More »Oracle SQL Tutorials – Chapter 2 (Part 3 of 3)
OPERATOR PRECEDENCE Let’s list the employees which JOB_ID is SA_REP or AD_PRES , and have salary more than 15000. SELECT first_name,last_name, job_id, salary FROM hr.employees WHERE job_id = 'SA_REP‘ …
Read More »Oracle SQL Tutorials – Chapter 2 (Part 2 of 3)
IS NULL OPERATOR Let’s list the employees that have manager. SELECT first_name,last_name, manager_id FROM hr.employees WHERE manager_id IS not NULL; LOGICAL OPERATORS AND : It returns TRUE if all …
Read More »Oracle SQL Tutorials – Chapter 2 (Part 1 of 3)
CHAPTER 2 WHERE Conditions Comparison operators BETWEEN operator IN operator LIKE operator IS NULL operator Logical operators AND operator OR operator NOT operator ORDER BY operator RESTRICTING ROWS WITH …
Read More »Exadata Database Machine X8-2 Released
Hi, Exadata X8-2 that we’ve been waiting a long time is released eventually. 1,412 views last month, 4 views today
Read More »Oracle SQL Tutorials – Chapter 1 (Part 3 of 3)
ARITHMETIC OPERATORS Arithmetic operations can be used on the data which type is ‘date’ or ‘number’. The priority of the operators is like below ; USAGE OF THE ARITMETHIC …
Read More »Oracle SQL Tutorials – Chapter 1 (Part 2 of 3)
SELECT Statement Selection : SQL statements are being used to returning the selected lines from related tables. Projection : SQL’s projection ability is being used to returning the selected columns …
Read More »Oracle SQL Tutorials – Chapter 1 (Part 1 of 3)
CHAPTER 1 – INTRODUCTION TO SQL Explaining the capabilities of the SELECT statement Writing simple SELECT statements Select columns and aliases Arithmetic operators NULL value Union operator Usage of DISTINCT …
Read More »