Check Duplicate Rows

Delete Duplicate Rows

Use of Sysdate in Oracle

Compare Table


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


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 Select on all tables in a Schema to a user

List of Oracle Grants


Set  Default Schema after login using trigger