Useful web sites The Best collections of Oracle related Links I have found • • • •
• • • • • • • • • • •
• • • • • •
Atul Mehta's Oracle World Stewart McGlaughlin Oracle Links Great Oracle Sites to Visit orafaq.com OracleAdvice.com | SQL*Plus Tips | Oracle 9i | Oracle 10g | Oracle 10g Documentation Library Rhubarb's Oracle Links (error codes, books, UTILITIES, code) Oracle Quick Reference Peter's Links Free Oracle Training and Tutorials Ask Tom Codebox: Wide assortment of SQL, PL/SQL Jeff Hunter's DBA/Development site (click ORACLE on LEFT) Akadia Info Technology Oracle FAQ FAQ ( scripts, vendors, etc) et c) Assorted Scripts (advanced) & Vendors Vendors Oracle8i Server, Release 8.1.5 (HTML & PDF) Conc Concepts, epts, Administration, Reference, Development Oracle9i Database Online Documentation (Release 2 (9.2)) Oracle9i Database List of Books (Release 2 (9.2)) Oracle10g Database Online Documentation 10g Release 1 (10.1) Oracle's Magazine OracleApps Blog http://searchoracle.techtarget.com/need http://searchoracle.techtarget.com/ need membership
FAQ's, Tips, T ips, Directories, Dire ctories, Glossary, Dictionary FAQ's Oracle Users' Co-Operative FAQ Oracle tips Archive by Donald K. Burleson CanadaNet411 Q&A Assorted Q&A FAQ's (very good mix of SQL, PLSQL & Oracle http://www.orafaq.com/faq2.htm IXORA Q & A http://www.orafaq.com/faqwinnt.htm FAQ for Oracle on Windows NT/2000 Oracle FAQ Oncall DBA (APPS & Concurrent)
Oracle DBA Tips Index DBA Tips Corner | Corner | dbahelp | dbazine.com SQL for Web Web Nerds by Philip Greenspun Jonathan Gennick http://www.adp-gmbh.ch/sitemap.html
Tips Did you Know ? Oracle Idiosyncrasies http://www.uaex.edu/srea/ Stephen Rea's Oracle Tips, Tricks, and Scripts Ken Atkins Oracle Tips Oracle Tips from www www.praetoriate.com .praetoriate.com Oracle newsgroups (USENET) Avisit Solutions Tips vi, rman, legato, unix, financials, init.ora Akadia Information Technology Part 1 and Part 2 http://directory.google.com/Top/Computers http://directory .google.com/Top/Computers/Software/Databases/Oracle/ /Software/Databases/Oracle/ Oracle SQL Tricks | http://www.oraclenotes.com/ | Cheat Sheet SQL*Plus COPY Utility Morgan's Library (Oracle 9.2/10.1 commands, syntax, reference, etc)
Glossaries Oracle's Glossary
|
Bytelife Oracle Glossary
|
Digital Guru's Dictionary
Scripts, Links, Jobs, Search Engines and Commands Oracle tips (forms & db) | Ari Kaplan's site & Oracle Tips | Oracle Links (jobs/search engines, etc) | ORAF ORAFAQ AQ Scripts | Oracle 8i 9i SQL Scripts and Database Commands | Rhubarb's Oracle Links (has scripts) | Kevin Loney's Scripts | Magazines, PL/SQL, Replication, DBA tasks | Oracle DBA Scripts and Tips | thescripts.com assorted directories of scripts Flying Sideways – Oracle Scripts/Views/Grants/SGA Scripts/Views/Grants/SGA
Mailing Lists & Forums: Mailing Lists:
ittoolbox.com very good Mailing list also ITtoolbox Wiki | Oraclemonster.com | OracleFans Forums |
[email protected] | lazydba.com mailing list | rchath.com mailing list | freelists.org Forums: http://www.tek-tips.com/gthreadminder http://www .tek-tips.com/gthreadminder.cfm/lev2/4/lev3/27/pid/18 .cfm/lev2/4/lev3/27/pid/18 | Throne Software Message Boards | DBFORUMS | Oracle Database, Tools & MarketPlace (MCSE.MS) | Google's Directory | Yahoo's Directory | OTN: Forums Home » Oracle
Technology Network (OTN) » Products | Oraclenotes | UK Oracle User Group | List of worldwide user groups | theoraclejobsite.com Special Interest Groups | Yahoo Directory: Oracle Groups | webservertalk webservertalk || WROX: Programmer to Programmer | Programmer | QAIX | Oracle Applications Users Group Public Sector Special Interest Group (OAUG Public Sector SIG)
Oracle Newsgroups: Oracle Newsgroups/USENET link above lets you view, search and post these groups Usenet comp.databases.oracle comp.databases.oracle.marketplace comp.databases.oracle.misc comp.databases.oracle.server.* (1) comp.databases.oracle.tools.* (1)
PL SQL: http://directory.google.com/Top/Computers/Programming/Languages/PL -SQL/ The Oracle PL/SQL CD Bookshelf Steven Feuerstein Feuerstein Oracle PL/SQL CD Bookshelf (O'Reilly) Minmaxplsql list of resour resources ces & 3rd party software | stevenfeuerstein.com | minmaxplsql.com (Blast Off PL/SQL) | Steve's books on PL/SQL also Supplemental files (code) | | http://www.oracleplsqlprogramm http://www .oracleplsqlprogramming.com/ ing.com/
PL/SQL reference Tucano's Introduction to Oracle PL/SQL Programming PL NET (Open-source PL/SQL code library) SourceForge.Net Oracle9i Application Developer's Guide - Fundamentals Release 2 (9.2) Part Number A96590-01 Oracle8i Supplied PL/SQL Packages Reference Oracle 101 CTA Program Database Application Development & Design Track Columbia Univ. Univ. courses & refere reference nce info ! Testing your PL/SQL by Ken Atkins http://www.ilook.fsnet.co.uk/ora_sql/sqlmain2.htm http://www .ilook.fsnet.co.uk/ora_sql/sqlmain2.htm Oracle PL/SQL Tips, Tricks & Utils set of 28 PL/SQL codes http://www.jusungyang.com/ORACLEfolder/PLSQL.html PL/SQL Programming Examples (sending email, random number, clob, dbms_job) Useful introduction to PL SQL PL/SQL reference, reference, help, & tutorial PL SQL FAQ (Underground) | ORA FAQ DMOZ open directory pl/sql
PL SQL Tutorial PL/SQL users guide & ref ver 8.0 OraNails (tools, forms, reports, pl/sql Useful PL/SQL sample code by ( keyword ) or by (description (description)) UltraEdit and TEXTPAD and TEXTPAD are good editors for PL/SQL especially for ASCII info Books & code PL SQL Message Forum or SQL & PL/SQL for Newbies Oracle PL/SQL Interactive Workbook, 2/e Error Handling Oracle supplied Packages (DBMS_**,UTL_**, etc) Good Intro & Tutorial Errors & Error Handling FAQ's (very good mix of SQL, PLSQL & Oracle CLOB Example Sending E-Mail in PL/SQL Intro to DBMS_JOB TEXT_IO code to write data to a flat file ASK TOM: how to get around Dbms_output limitations ASK TOM: dbms_output.enable does not work
Useful Links & Documents Documents for Legacy Interfaces / Extracts / Conversion •
• • • •
• • • • • •
•
• • •
IBMMAINFRAMES.com Online Discussion about IBM & UNISYS Mainframes Forum Index Legacy Data Conversions With Simple Tools COBOL User Groups (COBUG) http://www.cobug.com/ Mainframe FAQ's IBM's DFSORT feature to port packed signed ebcdic numeric data into ascii format document I wrote for porting packed data easily (PDF document) http://www.theamericanprogrammer.com IBM Mainframe Discussion List
[email protected] TSO Intro COBOL/VSE Language Reference Vedit editor EBCDIC/ASCII editor EBCDIC/ASCII conversion, large files, etc IBM Mainframe Datatypes: Mainframe Data (Field) Types Types | COBOL Comp-3, also called Computational-3, Packed Decimal, or Packed | IBM Mainframe: MVS z/OS utility DFSOR DFSORT T R14 Application Ap plication Programming Guide | Ask Professor Sort | Smart DFSORT Tricks | OUTFIL Control Statements (DFSORT) Useful for converting COMP-3 & Signed numerical data from EBCDIC to ASCII see Table 38 Edit Mask Patters ASCII Software The COBOL Center infogoal.com Center infogoal.com COBOL Connection | Commonly Used Numeric Formats (COBOL)
• • • • • • • •
• • • • •
Encryption software Free Compilers From There to Here: Database Migration Inserting Data from Excel How Oracle Handles Numbers MVS Help for the Mainframe Programmer http://www.mainframemigration.org Cathy Cakebreads site (mostly Financials) | Tips on implementing and Quickstart guide implementing Receivables Various tips for data conversion Handling Numbers TSO Introduction | TSO/ISPF Guide VENDORS: TAPECONVERSIONS.COM | SOFTWARE: EBCDIC to ASCII converter for Window (ZIP'd)
MVS •
http://www.ibmmainframes.com/ | IBM Mainframe reference info and Emulators
See on Metalink: 118366.1, 123512.1, 1072874.6, 1072874.6, 181874.1, 118347.1, 140833.1, 6
Oracle Applications ( APPS 11i10 11i 11.5.X 11.5. 10.7 10.7 SC ) FND - Apps Foundation Level CM - Cash Management GL - General Ledger INV - Inventory AP - Accounts Payable OPM - Process Manufacturing AR - Accounts Receivable BOM - Bill of Material PO - Purchasing
Metalink: 1012626.102 ( GL to AR Mapping ) ; 1011799.6 ( GL to AP Mapping)
11.5.10 11i10 info, upgrades, etc
11i10 New Features (PDF) COAUG Presentations look for 11.5.10 Version Update OracleGrapeVine.com Upgrade, Enchancements, Utility info Useful documents from Michigan Oracle Applications Users Group Presentations of Colorado Oracle Applications User Group has XML, Payables, 11.5.10 Oracle Application Hints and Tips Oracle Application Tips 16 tips Oracle 11i Tutorial (solbourne) Home » Applications » Oracle E-Business Suite FORUM Oracle E-Business Suite 11.5.10 - Vision Instance Oracle Application Hints and Tips
Appsking.com FAQ's Financials-Server.com 5 Upgrade Pitfalls Upgrade of Oracle Applications Oracle ERP Release Strategy 11.5.9 & 11.5.10 11i (11.5.10) Documentation Library (ORACLE) Unix & Oracle Weblog (11.5.10 maintenance pack) Oracle 11.5.10 Aligns Sales and Marketing, but Service Lags (by Gartner) Conversion Planning Guide Be sure to look on Metalink for NOTE: 182250.1 "Release 11i Related Documentation" Adobe Output Pak for Oracle E-Business Suite Overview and tips for Oracle Financials 10.7 SC 10.7 --> GOOGLE search on Oracle 10.7 SC migrations, etc
Oracle APPS Blog - Financial Financial Systems Navigation Card for APPS (very good) MS WORD Oracle Applications (AR/GR/AP/FND, etc) Assorted FinApps SQL code by module Oracle Application Hints and Tips Oracle Financials Financials group web site Oracle Application Experts by Carol Francum Oracle 11i documentation DARC White Papers DSP Global - Downloads (11i PDF's) Oracle 11i newsletter by Solution Beacon Free Release 11i Tools Oracle Financials message board OTN: Oracle Applications Documentation Oracle Apps FAQ's Most Popular Oracle Financials Articles Cathy Cakebreads site (mostly Financials) | Tips on implementing and Quickstart guide implementing Receivables Receivables Allen-Sauer Printing bitmapped reports Importing Journals BOSS White Papers and Tips and Tips COAUG Presentations Presentations (good collection!) CUSTOM library Harvard's Accounts Recei Receivable vable | Harvard's General Ledger | Chart of Accounts | Assorted AR, GL and financial documents Interfaces (PDF) Tuning & Optimizing (PDF) Implementing Release 11 11i New Features (PDF) Oracle Application Hints and Tips UK Oracle User Group
AR Invoice Wizard EXCEL & API FAQ's Oracle's TCA Architecture (Party, Sites & Accounts) Managing Concurrent Mgr (PDF) also see Oncall DBA
MULTI ORG Release 11i Use of Multiple Organizations | DSP Global - Downloads 11iRelease Upgrades | Multi-Org in Oracle APPS Implementing HR after Financials | Multi-Org: Technical Perspective SQL query to display Items in a multi-org setup | Foreign and Legacy Data
Form Customization / Custom.pll Library Boss Corp. Custom Library Notes Develop Custom Forms in Oracle Applications(tm) Release 11
Application Object Library (AOL) Application Object Library
DBA Stuff DBA Scripts A guide to Oracle, Windows, Linux and OS X commands SS64 Scripts from Dennis Datatypes (number, long, raw, date, etc) Oracle Executable Executables s This table lists executable programs in $ORACLE_HOME/bin How Oracle Stores Integers
Miscellaneous PDF of flexfields and how they are stored and referenced referenced A/R's Chart of accounts Metalink Pocket Guide Oracle Supplied Packages (DBMS, UTL, etc) Oracle Replication 8i Oracle Utilities 8i Oracle XML Publisher Evergreen Database Technologies links ASCII Chart or ASCII Chart 2 Frank-Peter Schultze Batch Bookmarks | Allenwar Allenware.com e.com Batch XML FAQ ORAFAQ ORAF AQ (tools, glossary, scripts, books, links, tools) How to send mail from Oracle Forms? ORA errors codes - number related Oracle Error Codes Oracle Messages & Codes VERY GOOD Oracle Syntax
Oracle Glossary Oracle Security & Auditing Oracle Database, SQL, Application, Programming Programming Tips Oracletuning.com Good resorce on Discoverer Good Course on Oracle Oracle Report Notes Bulletproofing, Backups, and Disaster Recovery Recovery Scenarios Microsoft's Technet Script Center Planet PDF
Windows, DOS, Batch, Command Shell, Scripting Batfiles: The DOS batch file programming handbook & tutorial loaded with info and samples ! windowsshellscripting.com | Tom Lavedas Bookmarks DOS, Scripting NT/Win2k scripting 4DOS INFO | Shell Scripts on the PC | Garbo FTP archive DOS Command line links | Microsoft & Windows Tips, Techniques, and Goodies Microsoft Windows NT: Command Shell Command shell overview
Email, SMTP PL/SQL API Reference | an Oracle PL/SQL procedure to send an email with file attachments | Emailing from Oracle | SEND MAIL THROUGH DATABASE BY UTL_SMTP | Send Email by UTL_SMTP or | Send Email by UTL_SMTP
Visual Basic, VB, ODBC, Barcoding, Perl, Forms/Reports, OCI • • •
•
• • • • • • • •
Open Database Connectivity - 'ODBC' JDBC/Oracle Tutorial 1 JDBC 1.0 Oracle ODBC Class Module | VB Site Links ( VB Net, VB Thunder, Planet Source Code DataDirect Connect for ODBC - Windows ODBC, UNIX ODBC, Linux ODBC, Oracle ODBC, and DB2 ODBC http://www.perl.com/ selection of Oracle, VBA and miscellaneous tips, tricks and hints Ericp Helps.com | Assorted Programming Links Computerhope.com Manuipulating Text Text (perl, sed, regular expressions, cgi IDAutomation (barcoding) ProgrammersHeaven.com CanadaNet411 Q&A Assorted Q&A
• •
Customizing Reports at Runtime Programmer's Guide to the Oracle Call Interface
Interview Q & A | Geekinterview.com Descriptive FlexFields FlexFields (DFF) Setup and Use Spring 1997 or DFF Setup & Use Generating Sequence Numbers Use of Sequences Sequence Numbers (PDF) Assorted Editors | Personally I suggest Textpad suggest Textpad , especially for PL/SQL ouput Useful info on Oracle History, SQL, PLSQL, etc Integrigi's Security resour resources ces Oracle Internationalization & Character Sets dbms_metadata How do I become a DBA ? Date / Time Arithmetic with Oracle 9/10 Pro*COBOL Precompiler Programmer's Guide Release 8.1.5 A68023-01 Guide to File extensions (PDF) | File Extensions ( Windows OS2 Apple Unix Oracle Reports Barcode FAQ & Tutorial Oracle Reports Developer Release 6i
SQL ORAFAQ SQL+ DEBUGGING APPLICATIONS WITH SQL*TRACE SQL Character functions | SQL+: Converting Files | SQL online course/tutorial | Subqueries | Handling Numbers ORA-XXXX errors assorted | http://www http://www.techonthenet.com/oracle/i .techonthenet.com/oracle/index.htm ndex.htm also pl/sql | SQL*Plus substution variables
Assorted Code Oracle PL/SQL Programming, 3rd Ed. Supplemental Files | CISY 286 Introduction to Oracle: SQL & PL/SQL | Oracle Press | Lowe Lum Carlson Systems FAQ,Tutorial, AQ,Tutorial,Scripts Scripts | Oracletuning.com | Oracle Solutions in Australia - asstd code
Assorted Tutorials Notes on the Oracle DBMS | Oracle 11i Tutorial (solbourne) | An Introduction to Oracle: Tutorial Series | 8i Character Functions |
SQLCOURSE2.COM Assortment !!! | SQL Q & A | PL/SQL, Tutorials (columbia univ.) | programmingtutorials.com | Oracle Forms Developers Guide | SQL Tutorials w3schools.com | Lowe Lum Carlson Systems FAQ,Tutorial, AQ,Tutorial,Scripts Scripts | Oracle 101 (DB Admin, PLSQL, Concepts) | Codebox: Wide assortment of SQL, PL/SQL | Oracle / Access / PowerPoint Tutorial and Help Page | PL SQL Tutorial & Reference | Intro to Oracle | Free Online SQL Documentation, Tutorial, References | Oracle Discoverer Desktop User's Guide | Oregon State Univ. (Forms, | http://www.virtualschool4all.com/Or http://www .virtualschool4all.com/Oracle acle | App Development with Oracle (9i) | Oracle 101 | Oracle Forms 4.5/ 5.0/ 6.0/ 6i and 9i FAQ | CPSC 304 Introduction to Relational Databases | Exforsys Inc Free Training wide assortment besides Oracle stuff
Useful "WHITE" Papers GOOGLE search AOUG White Paper Links District of Columbia Oracle Users Group - PAPERS Useful documents from Michigan Oracle Applications Users Group | NorCal OAUG Training Day 2004 Presentation Downloads | Orafaq links | TUSC Downloads | Wichita Area OUG | BOSS Corportation | Australian Oracle User Group | | Oracle Development Tools User Group | COAUG Presentations | NYOUG Presentations | Mid-West Oracle Users Group papers | Integrigy Security Whitepapers | Quest Software's Document Library | Univ Waterloo Financial Systems Upgrade Project (alot of 10.7, NCA, upgrade docs) | Database Specialists | Useful Oracle Articles | Evergreen Database Technologies White Papers & Presentations
Useful Consulting Web Sites and Training Yahoo: Business to Business Directory | Assist | Akadia.com | Akadia publications Dan Hotka | TUSC The Oracle Experts | Red Rock | Articles | Avisit Solutions Lts | Tips & Tricks | COMP9311 Database Systems 04s2 | Ask Tom or Ask Tom | Oracle Reprorts - Red Star Technologies | FINANCIALSSERVER.COM | OUTERBAY APPLICATION DA DAT TA MANAGEMENT MANAGEM ENT archiving and other special software
Oracle Error Code prefixes and categories ORA-
Oracle RDBMS errors
DBA-
SQL*DBA errors
LCC-
Parameter parsing errors
IMP-
Import errors
EXP-
Export errors
PLS-
PL/SQL errors
DBV-
DB Verify errors
OBK-
Oracle Backup / Restore Utility
RMAN-
RMAN error messages
TNS-
SQL*Net/Net8 errors
OSD-
OSD level errors
SQL-
SQLLIB runtime errors
FRM-
Oracle Forms errors
REP-
Oracle Reports errors
CDI-
Oracle Case Dictionary errors
CGE CGEN-
Orac Oracl le Cas Case e Gen Gene erat rator (Form orms an and Re Report ports s)
PCC-
Precompiler errors
SQL*LoaderSQL*Loader- SQL*Loader errors
Training, Testing & Certification Cert ification Yahoo: Training | Learning Tree | Prepar Preparation ation for f or Certification | Raritan Valley Computer Dept | OA Train – Oracle Applications | Self Test Software | Computertrainingschools.com | Netstar | Object and Data Labs: Sysadmin | CMIS 565 Oracle Database Administration
Resumes & Interviewing Assorted Resume samples Geek Interview.COM englishinterview.com
Various Installations with Oracle and/or Applications (APPS) Rockefeller Univ. Integrated Administrative Systems IAS | Oracle Navigation User Guide – Rockefeller Rockefeller Univ http://www.bc.pitt.edu/prism/ UAB Finance Manuals | UAB Oracle Accounting Applications nbs.nih.gov | UAB.edu stanford.edu | Oracle 11.5.9 upgrade | Resources / Learning Center Ithaca Harvard's ABLE | Harvard's 11i Navigation | Harvard's A/R | Harvard's General Ledger | Chart of Accounts Harvard's Financial & Reporting Applications | FAQ's A/R | Assorted AR, GL and financial documents Univ of Vir Virginia ginia | How Do I ? | Glossary US Dept Transportation Univ Waterloo Financial Systems Project The University Computer Center (TUCC)
Government of Newfoundland and Labrador Binghamton's Pegasus Univ College London | User guides Binghamton Training Library University of Cambridge > University Offices > Finance Division > Finance Training Good Reference & Training MANUALS