Oracle Scripts » Categories » Oracle SQL tricks

Oracle SQL tricks

Script+
Change fonts size at SQL*PLUS
Change login prompt at SQL*Plus
Client IP Address
Compare two table data
Create a table with random values
Create christmas tree in SQL*PLUS
Database up time
Delete duplicate records from table
Environment settings for SQL*PLUS
Escape character in sql queries
Explain plan and statistics with SQL*Plus
Find Hardware-OS of the server
Find m to n rows from table
Find n lowest values from table
Find prime numbers between a range
Find the difference between two strings
Find time difference in 00:00:00(H24:MI:SS) between two dates
Finds only the numeric values from varchar2 columns
How to remove all left and right spaces from string
How to remove symbols from strings
Master-slave tree
Modify not null number column to varchar2
Procedure to check for spaces in a table
Randomly select rows from a table
Re-order characters in a column
Remove bad 'child' records to enable or create a foreign key
Replace quotes from strings
Selecting only even or odd records
Sys_Context fails to compile ('SYS_CONTEXT' must be declared)
The same result with count(*)

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
 

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