Oracle Scripts » Categories » Oracle SQL tricks

Oracle SQL tricks

Use DECODE instead of IN for performance

Truncate table from remote database

The same result with count(*)

Sys_Context fails to compile ('SYS_CONTEXT' must be declared)

Selecting only even or odd records

Replace quotes from strings

Remove bad 'child' records to enable or create a foreign key

Re-order characters in a column

Randomly select rows from a table

Procedure to check for spaces in a table

Modify not null number column to varchar2

Master-slave tree

How to remove symbols from strings

How to remove all left and right spaces from string

Finds only the numeric values from varchar2 columns

Find time difference in 00:00:00(H24:MI:SS) between two dates

Find the difference between two strings

Find prime numbers between a range

Find n lowest values from table

Find m to n rows from table

Find Hardware-OS of the server

Explain plan and statistics with SQL*Plus

Escape character in sql queries

Environment settings for SQL*PLUS

Delete duplicate records from table

Database up time

Create christmas tree in SQL*PLUS

Create a table with random values

Compare two table data

Client IP Address

Result Pages: 1 2 [Next >>] Displaying 1 to 30 (of 32 scripts)

Categories

Oracle DBA-> (147)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)

Filters

Search

Information

Ask for Free Support
About the Author
Buy Oracle Books
Privacy Notice