Oracle

Hi, Sometimes you need moving tables and indexes to the new tablespace in Oracle.

I will explain How to Move Tables, Index Rebuild, Partitions and Subpartitions to Another Tablespace in Oracle in Oracle.

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 …

Hi, If you have big database about more than 1 TB, then your backup and export operations are taking long times.

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‘ …

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 …

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 …

Hi, Exadata X8-2 that we’ve been waiting a long time is released eventually.

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 …

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 …