Oracle Consulting, Oracle Support and Oracle Training by Spyridon N. Kaparelis
Oracle
Oracle Scripts
(Search)
»
Categories
»
Oracle SQL tricks
My Account
Categories
Free Oracle Support
(1)
Administration->
(120)
FlexCube
(4)
ORA errors
(14)
Oracle Application Server
(1)
Oracle APPS DBA->
(38)
Oracle APPS DBA jobs
(1)
Oracle Books
(18)
Oracle RAC
(3)
Oracle Real Cases
(29)
Oracle Security
(6)
Oracle SQL tricks
(32)
Other Oracle sites
(3)
Performance Tuning->
(53)
Site info
About Spyridon N. Kaparelis
Privacy Notice & Disclaimer
Buy Oracle APPS DBA Books
Ask for Free Oracle Support
Scripts+
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(*)
Truncate table from remote database
Use DECODE instead of IN for performance
Displaying
1
to
32
(of
32
scripts)
Pages:
1
Reviews
No reviews recently
Read Latest Oracle News
Search at the site
Press Enter to search
Advanced Search
Search Error Messages
Oracle8i
Oracle9i
Oracle10g
Oracle11g
Search Oracle Docs
Metalink
Oracle8i
Oracle9i
Oracle10g
Oracle11g
Wednesday 08 September, 2010
Created by:
Spyridon N. Kaparelis
136586 page views since Tuesday 27 October, 2009
Oracle APPS DBA Kaparelis
|
Oracle RAC
|
Oracle PLSQL
|
Oracle Tips
| Oracle Consulting |
Oracle Metalink
| Oracle Support
Oracle Training
|
Oracle Certification
|
Oracle Articles
|
Oracle DBA
|
Oracle Magazine
|
Oracle User Groups
Oracle 7.3 Oracle 8 Oracle 8i Oracle9i Oracle10g Oracle11g EBS E-Business Suite 11.5.10 Oracle Apps Tuning Oracle SGA tuning sql tracing oracle session oracle errros ORA error ORA-600 Ora-00600 oracle jobs dba jobs apps dba jobs oracle experts oracle guru oracle oracle real application cluster oracle index oracle optimazation query oracle explain plan query optimization oracle I/O oracle memory tuning oracle xstress test oracle education oracle university oracle certification OCP OCA oracle support contracts oracle monitoring RAC interconnect developer oracle forms reports oracle application server Rman spyros dba oracle backup Veritas recovery catalog rcvcat oracle Σπυρίδων Καπαρέλης Ora-00600:[] Sp???d?? ?. ?apa????? oracle monitor daily operations free oracle support free consulting oracle seminars oracle arhitecture Unix linux HP-UX AIX Sun Solaris Windows TAR Service Request Metalink oracle disaster recovery oracle Data Guard Oracle Database Administrator Oracle Services low cost oracle support oracle patches upgrades apps dba spyros patch upgrade oracle opatch OUI export import oracle data pump ADDM ASM oracle OAS PGA shared pool ?p?st????? Oracle Application Server 10g consultans Oracle ERP CRM Apache WebUtil oracle 10g 11g 12g New Features Oracle courses development Oracle News forums Oracle Technical Docs FAQ Oracle Professionals Oracle DataCenter Data Center IT Oracle prices oracle software pricelist oracle carriers Oracle RDBMS Oracle Σπύρος Καπαρέλης Oracle Fusion Spiros Kaparelis oracle Spyros Kaparelis
