Oracle

Oracle is a software company which has grown and thrived primarily through the sale of its enterprise grade RDBMS solutions to large companies and organizations, but has also grown through acquisitions, strategic partnerships and innovations to include a number of other significant technologies including servers (hardware) and storage devices, Web Server software, E-Business & BPM software, ERP software, CRM software, Financial software, Grid/Cloud Computing & Virtualization technologies, Oracle-developed Linux distributions and other development tools; not to mention the increasing revenue it earns through its consulting and technology support services.

Oracle acquired Sun Microsystems in 2009, thus becoming owner of the Java language, JVM and all notable Sun technologies, including the Sun-acquired open source MySQL RDBMS.

Tools

• Oracle 11g Express DB: http://www.oracle.com/technetwork/products/express-edition/overview/
• PL/SQL Developer: http://www.allroundautomations.com/plsqldev.html
• Toad for Oracle: http://www.quest.com/toad-for-oracle/

Resources

• Oracle - technology global price list (2020-09-08): http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf
• Oracle Database SQL Language Reference -- 11g Release 2 (11.2) - Data Types: http://docs.oracle.com/cd/E11882_01/server.112/e10592/sql_elements001.htm
• Oracle to Java -- Data Type Mapping: http://docs.oracle.com/javase/1.3/docs/guide/jdbc/getstart/mapping.html#1039196
• Oracle 11g -- SQLSTATE Codes: http://docs.oracle.com/cd/E15817_01/appdev.111/b31228/appd.htm
• Comparison with other RDBMS's: http://ss64.com/ora/syntax-datatypes.html#aswift_0_anchor
• Oracle PL/SQL Cheatsheet: http://www.yagc.ndo.co.uk/cheatsheets/plsql_cheatsheet.html
• Oracle PL/SQL Quick Reference: http://umanitoba.ca/computing/ist/internal/admin_sys/project_review/media/Oracle_PLSQL_Quick_Reference_Card.pdf
• Oracle guide to PL/SQL: http://www.oracle.com/technetwork/database/features/plsql/
• PL/SQL by Example (BOOK): http://www.choudhari.net/downloads/Books/Oracle%20PL-SQL%20by%20Example.pdf
• Oracle DBA on Linux and Unix (BOOK): http://choudhari.net/downloads/Books/Oracle%20DBA%20on%20Unix%20and%20Linux.pdf
• Oracle DBA Course - Top 20 Features: http://choudhari.net/downloads/Books/Oracle%20Database%2010g-The%20Top%2020%20Features%20for%20DBAs.pdf
• Oracle DBA Made Simple (BOOK): http://choudhari.net/downloads/Books/Oracle%20DBA%20Made%20Simple.pdf
• The Underground PHP & Oracle (DB) Manual: http://www.oracle.com/technetwork/database/database-technologies/php/201212-ug-php-oracle-1884760.pdf
• Datetime Datatypes and Time Zone Support: http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm
• Sequence Pseudocolumns: http://docs.oracle.com/cd/E11882_01/server.112/e26088/pseudocolumns002.htm#SQLRF50946
• Overview of Oracle11g DATE Datatype: http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#i1847
• Oracle/PLSQL -- TO_DATE Function: http://www.techonthenet.com/oracle/functions/to_date.php
• Oracle - Data Concurrency and Consistency: http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/consist.htm
• Oracle - Using a Connection Pool: http://docs.oracle.com/cd/B28359_01/java.111/e10788/manage.htm#BABCBEAC
• Oracle - Optimizing Connection Pool Behavior: http://docs.oracle.com/cd/B28359_01/java.111/e10788/optimize.htm#CFHHCICE
• Oracle Reports Documentation: http://www.oracle.com/technetwork/middleware/reports/documentation/

Tutorials

• Loading and Unloading Database Content Using Oracle Data Pump: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/prod/manage/datapump/datapump_otn.htm
• Step by Step Tutorial -- How to Use Oracle Data Pump Export & Import: http://www.dbuggr.com/smallwei/quick-step-step-summary-oracle-data-pump-export-impo/
• How do I export an Oracle database table to a flat file: http://www.jlcomp.demon.co.uk/faq/flatfile.html
• How to Make JDBC Connection to Oracle 11g Release 2: http://vigilance.co.in/how-to-make-jdbc-connection-to-oracle-11g-release-2/
• Create Dump file in Oracle: http://neozilon.com/oracle/create-dump-file-in-oracle
• CREATE MATERIALIZED VIEW: http://docs.oracle.com/cd/E11882_01/server.112/e17118/statements_6002.htm#SQLRF01302
• How to Import from Excel to Oracle with SQL Developer: http://www.thatjeffsmith.com/archive/2012/04/how-to-import-from-excel-to-oracle-with-sql-developer/
• Importing Data Using Oracle SQL Developer - SQL*Loader utility: http://database.blogs.webucator.com/2011/02/27/importing-data-using-oracle-sql-developer/
• Running SQLPlus and PL/SQL Commands From A Shell Script: http://dbamac.wordpress.com/2008/08/01/running-sqlplus-and-plsql-commands-from-a-shell-script/
• Using Oracle PL/SQL: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-plsql.html
• Oracle PL/SQL - Working with Records: http://www.oracle.com/technetwork/issue-archive/2012/12-may/o32plsql-1578019.html
• Oracle - Determine JDBC Driver Version: http://www.oracledistilled.com/java/determine-jdbc-driver-version/
• Why I Completely Forgot That Programming Languages Have While Loops: http://dzone.com/articles/why-i-completely-forgot-that-programming-languages
• Date / Time Arithmetic with Oracle 9/10: http://www.akadia.com/services/ora_date_time.html
• Subtract a Date from SYSDATE using Oracle Inline Query: http://stackoverflow.com/questions/11651708/how-to-minus-date-from-sysdate-using-oracle-inline-query
• Storing timestamp in Oracle database with JPA: https://forums.oracle.com/forums/thread.jspa?threadID=612075
• How to change default 8080 port of Oracle XE 11g: http://rajarshi-king.blogspot.ca/2012/02/how-to-change-default-8080-port-of.html
• Auto Generated Primary Keys in Oracle: http://blog.lishman.com/2009/02/auto-generated-primary-keys-in-oracle.html
• Hibernate-Oracle Sequence: http://www.coderanch.com/t/219007/ORM/databases/Hibernate-Oracle-Sequence
• Sequences [Oracle]: http://www.adp-gmbh.ch/ora/concepts/sequences.html
• Java Program to connect Oracle 11g Database with Example - JDBC Tutorial Sample Code: http://javarevisited.blogspot.com/2012/04/java-program-to-connect-oracle-database.html
• Insert CSV Data to Oracle - Java JDBC Example Program: http://thinktibits.blogspot.ca/2012/12/Insert-CSV-Data-Oracle-Table-Java-JDBC-Example.html
• Bulk Load CSV File Data to Oracle Java Example Program: http://thinktibits.blogspot.ca/2012/12/Bulk-Load-CSV-File-Data-Oracle-Java-JDBC-Example.html
• Altering Oracle sequences: http://www.dba-oracle.com/t_alter_sequence.htm
• CREATE DATABASE LINK: http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_5005.htm
• Developing Applications for Oracle Cloud Using NetBeans: http://apex.oracle.com/pls/apex/f?p=44785:24:0::::P24_CONTENT_ID,P24_PREV_PAGE:6945,1
• Oracle - Insert null value to a date field: http://www.dbasupport.com/forums/showthread.php?31397-Insert-null-value-to-a-date-field
• Right Outer Join example in SQL / Oracle Database: http://java.dzone.com/articles/right-outer-join-sql-oracle

• Oracle Virtual Private Data (VPD) - Data Filter: http://www.oracle.com/technetwork/database/security/index-088277.html
• Securing Data: http://docs.oracle.com/cd/B28359_01/server.111/b28337/tdpsg_securing_data.htm#TDPSG40000
• Using Oracle Virtual Private Database to Control Data Access: http://docs.oracle.com/cd/B28359_01/network.111/b28531/vpd.htm#DBSEG007
• Restricting Access with Oracle Virtual Private Database: http://docs.oracle.com/cd/E16655_01/server.121/e17609/tdpsg_vpd.htm#TDPSG30341
• Using Application Contexts to Retrieve User Information: http://docs.oracle.com/cd/E16655_01/network.121/e17607/app_context.htm#DBSEG174

• How to install Oracle Weblogic Server using Generic Package installer?: https://blogs.oracle.com/WeblogicConfigurations/entry/how_to_install_oracle_weblogic2
• Starting and Stopping Oracle WebLogic Servers: http://docs.oracle.com/cd/E12839_01/web.1111/e13708/overview.htm#i1070153
• Creating a WebLogic Domain: http://docs.oracle.com/cd/E17904_01/web.1111/e14140/newdom.htm#i1071362
• WebLogic / JDeveloper 12c (12.1.2.0.0) Generic Installer, jdev_suite_121200.jar: https://community.oracle.com/thread/2589611
• Developing an Enterprise Application for Oracle WebLogic Server: https://netbeans.org/kb/docs/web/jsf-jpa-weblogic.html

External Links

• Oracle: http://oracle.com
• wikipedia: Oracle Corporation
• wikipedia: Oracle Database
• wikipedia: Google LLC v. Oracle America, Inc.
• Oracle says Google directly copied Java code -- Here's the line-by-line comparison: http://www.zdnet.com/blog/btl/oracle-says-google-directly-copied-java-code-heres-the-line-by-line-comparison/41025?tag=nl.e589
• Supreme Court of the United States -- GOOGLE LLC,Petitioner, v. ORACLE AMERICA,INC., : https://www.supremecourt.gov/DocketPDF/18/18-956/128381/20200113143602407_Microsoft - Google v Oracle Amicus Brief_Efile.pdf
• Google's 'copied Java code' disowned by Apache -- Dis-Harmony from Oracle's Android suit: http://www.theregister.co.uk/2010/11/01/oracle_hits_google_with_code_copying_claims/
• How to do an "insert ignore" in Oracle : http://halisway.blogspot.ca/2007/04/how-to-do-insert-ignore-in-oracle.html
• The 11GR2 IGNORE_ROW_ON_DUPKEY_INDEX hint: http://guyharrison.squarespace.com/blog/2010/1/1/the-11gr2-ignore_row_on_dupkey_index-hint.html
• ORA-01861 -- Literal does not match format string: http://www.dbmotive.com/ora-01861-literal-does-not-match-format-string/
• Fix error -- "ORA-01830: date format picture ends before converting entire input string": http://oraclequirks.blogspot.ca/2007/09/ora-01830-date-format-picture-ends.html
• Fixing the ORA-12519 -- TNS:no appropriate service handler found error: http://www.atpeaz.com/index.php/2010/fixing-the-ora-12519-tnsno-appropriate-service-handler-found-error/
• Case No. 18-956 -- IN THE Supreme Court of the United States - GOOGLE LLC,Petitioner,v. ORACLE AMERICA,INC: https://static1.squarespace.com/static/53864718e4b07a1635424cdd/t/5c740723ee6eb02c2af0935e/1551107888216/18-956+Amicus+Brief+of+Developers+Alliance.pdf
• Supreme Court to hear copyright case pitting Google against Oracle: https://www.politico.com/news/2019/11/15/supreme-court-copyright-google-oracle-071170
• APIs And The Notorious RBG: November 2019 Update: https://www.developersalliance.org/news/2019/2/25/apis-and-the-notorious-rbg
• Supreme Court takes on Google vs. Oracle - The biggest software development case ever: https://www.zdnet.com/article/supreme-court-takes-on-google-vs-oracle-the-biggest-software-development-case-ever/ (whatever happened to Oracle .vs. Google and vice versa court cases? Turns out they're STILL at it? in 2020-2021)
• SCOTUS Defends APIs While Congress And States Threaten Software Marketplaces: https://www.developersalliance.org/news/scotus-defends-apis-while-congress-and-states-threaten-software-marketplaces
• Techies give an old fashioned Supreme Court decent marks in coding case: https://www.usatoday.com/story/news/politics/2021/04/10/supreme-court-wrestled-complicated-google-oracle-coding-dispute/7145113002/

See Also

Database | MySQL | SQL | NoSQL | DBMS | RDBMS | Sun | JAVA