Table and its count

Table and its count - Oracle

To get the number of rows in all tables in Oracle database, use this query.

SELECT table_name,num_rows FROM all_tables WHERE owner = 'SCHEMA';

Comments

Identify the duplicates in MySQL

To identify the duplicate entries in MySQL, use below query. SELECT COUNT(*) as repetitions, group_concat(id, ' (', startTime, ', ', endTime, ') ' SEPARATOR ' | ') as row_data FROM GROUP BY startTime, endTime HAVING repetitions > 1 FYI, id, startTime and endTime columns should be changed based on your table schema. you can change the output format here like alias and the separator.

Exclude or Include table(s) during creating backup from MySQL

To exclude tables when you are creating database backup from MySQL, execute below query. mysqldump -u root -p<Password> DATABASENAME --ignore-table= DATABASENAME.TABLENAME > BACKUPFILENAME.sql To include tables when you are creating database backup from MySQL, execute below query. mysqldump -u root -p<Password> DATABASENAME TABLENAME1 TABLENAME2 > BACKUPFILENAME.sql Take note that there is no whitespace between -p and the password..

What need to do when encounter the error ORA-28001: the password has expired

When you encounter the error ORA-28001: the password has expired, execute below queries to resolve this. export ORACLE_SID=< databaseName> sqlplus / as SYSDBA SQL> alter profile default limit password_life_time unlimited; SQL> alter user <userName> identified by <password>; SQL> commit; SQL> exit;

Databases

Search This Blog