Mohammad Nazmul Huda
Search this site
About Me
Certifications
Employment History
Publications
Study Resources
Training
Technical Docs
Oracle
Managing Database
Backup and Recovery
Performance Tuning
ASM
Security
Replication
Database Change
Data Guard
Cloud Control
LISTENER
Parameters
SQL
SQL Functions
PL/SQL
ORA ERROR
12c Issues
Bugs
Scripts
Tools
OCM
Teradata
MySQL
SQL SERVER
Linux
AWS
Data Science
Other
Contact
SQL
Check Duplicate Rows
Delete Duplicate Rows
Use of Sysdate in Oracle
Compare Table
Synonyms
How to enter special characters like “&” in oracle database
Difference Between Count(*) and Count(Column Name)
Search/Remove space in String
Retrieve Nth Row from a table
How to check size of clob Column
ORA_ROWSCN
Concatenating field values to update one column
How to concatenate multiple rows into one in oracle using wm_concat function
How to Find the Size of Number Of Rows Of A Table
How to generate md5 value in Oracle
SQL for DBA
Display all schemas in Oracle Database
Display all schemas that have partition table in Oracle Database
Display size of Schemas
How to check character set in Oracle
How to Check Database Language,Territory and Character Set
Query to find out sql statement running by the active user
Query to find out total number of session in database from different machine and osuser
Query to find out Total numeber of session in database and currently total active session
Archive Log Information
Check uncommited Session
How to check Lock objects
Check Redo Log Size
Size of the Tablespaces Check
ASM Disk Group Size Check
How to check Database is in restricted mode or not
Check inactive or Idle session
Check Bind Variable History
Session or Process Count from History
How to get size of the table including indexes
SQL Script
Disable and Enable All Constraint
Rebuild index Script
Kill all blocking Session
Grant
Grant Select on all tables in a Schema to a user
List of Oracle Grants
User
Set Default Schema after login using trigger
Comments