TechiesAbode.com : ORACLE Resources, tips, faqs, articles and discussions

	dumping a c or c++ or java program into oracle.
	converting number into words.
	An unexpected error has occurred: [Oracle JDBC Driver]Transliteration failed, reason: invalid UTF8 data.
	Leap Year Handling
	wat is diff between functions and packages

Resources

Admin Tools - [6]	Books and Journals - [0]
Development tools - [1]	Miscellaneous - [1]
Web Sites - [1]

Scripts

Admin Scripts - [2]	Developers Scripts - [0]

Upload your resources

Oracle Tips & Tricks

How to kill a Oracle Sessions?

Problem with BitMap Index

nth maximum by different way

How to access Oracle Database Server from JSP

SQL*Loader-00626 Character set conversion buffer overflow

Listing tablespaces whose extents can be coalesced

Tables with parent-child relationship

Show memory availability in the SGA (buffers)

This will list who is using which rollback segments

Monitoring Rollback segment!

Find out if an Oracle Applications patch has been installed into an Oracle Applications instance

Number of invalid objects by object_type

Delete duplicate records from a table

Show database uptime

Convert Alphabetical Phone Numbers to Numeric Phone Numbers

Running Sum

Select Nth highest paid person in an organization

List all indexed columns for a given table

Leap year check

Spell out the numbers into words.

Add a Tip / Trick

Oracle Articles

Recommended Books

Useful Links

Oracle Metalink

Its a must visit place for every oracle user. Suppose to be inventory for all kinds of oracle resources!

Oracle Magazine free subscription

Published bimonthly and distributed to more than 600,000 of the top IT managers, database administrators, and developers.
Oracle Magazine contains technology-strategy articles, sample code, tips, Oracle and partner news, how-to articles for developers and DBAs, and more.

Geographic Eligibility: Selected International

Publisher: Oracle Corporation

Oracle Software Downloads

All software downloads are free, and each comes with a development license that allows you to use full versions of the products only while developing and prototyping your applications.

Oracle Certification

Getting certified with Oracle can bring you the credibility you deserve for your knowledge, skill, and experience on the job as an Oracle Professional and will provide you with a market recognized credential that can lead to success.

Oracle Academic Initiative

The Oracle Academic Initiative partners with educators to deliver state-of-the-art Oracle software and curriculum resources to the college and university classroom. Our mission is to enable every student of higher education across the globe to acquire industry-relevant skills and an introduction to the Oracle certification pathway as part of a broader program of study

Oracle Downloadable CD Packs, includes part numbers

On this site you can download any Oracle product that is currently available to license

Free Oracle Training and Free Oracle Lessons

Let us help you learn Oracle. Free Oracle Tutorials and Free Oracle Training Lessons are available here. Just click on the title you are interested in. The free Oracle eLearning will render in a new browser window. Visit often because we add new free Oracle Training and eLearning modules frequently.

String Aggregation Techniques

On occasion it is necessary to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value. Using the SCOTT.EMP table as an example, we might want to retrieve a list of employees for each department. Below is a list of the base data and the type of output we would like to return from an aggregate query.

Suggest a link