SQL - Mohammad Nazmul Huda

SQL

Check Duplicate Rows

Delete Duplicate Rows

Use of Sysdate in Oracle

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

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