Get started

Get started

Bring yourself up to speed with our introductory content.

• Oracle Autonomous Database shifts IT focus to strategic planning

  This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider before using the automated cloud service. Continue Reading

• Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

  This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle cloud, database and application users. Continue Reading

• How to create Oracle Multitenant database user accounts

  Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary. Continue Reading

• How to connect to a pluggable database in Oracle Multitenant

  Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they can be used. Here's how to do that. Continue Reading

• Creating an Oracle Multitenant container database and PDBs

  Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the Oracle Multitenant architecture. Continue Reading

• Definitions to Get Started

  • NetSuite
  • stored procedure
  • object-oriented database management system (OODBMS)
  • PL/SQL (procedural language extension to Structured Query Language)

  • distributed database
  • Oracle NoSQL Database
  • PeopleSoft
  • MySQL

  View All Definitions

• NetSuite

  NetSuite is a business technology vendor based in San Mateo, California.Continue Reading

• stored procedure

  A stored procedure is a group of statements with a specific name, which are stored inside a database, such as MySQL or Oracle.Continue Reading

• Oracle Digital Assistant unifies use of enterprise chatbots

  With Oracle Digital Assistant, users are able to create digital assistants with multiple chatbots that handle different tasks to help increase worker productivity.Continue Reading

• object-oriented database management system (OODBMS)

  An object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system, is a database management system (DBMS) that supports the modelling and creation of data as objects.Continue Reading

• Oracle Database 19c new features and what users need to know

  Oracle Database 19c is the last update to the 12c Release 2 line of Oracle's database software. This handbook examines its new features and potential reasons to upgrade.Continue Reading

• PL/SQL (procedural language extension to Structured Query Language)

  In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL).Continue Reading

• distributed database

  A distributed database is a database that consists of two or more files located in different sites either on the same network or on entirely different networks.Continue Reading

• Oracle NoSQL Database

  The Oracle NoSQL Database is a nonrelational, horizontally scalable key-value database, with multiple higher-level data abstractions that support data management as binary key-value pairs, JSON objects, and SQL-like tables.Continue Reading

• PeopleSoft

  PeopleSoft is an e-business software product line owned by Oracle.Continue Reading

• MySQL

  MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language).Continue Reading

• Oracle Autonomous Database

  Oracle Autonomous Database is a cloud-based technology designed to automate many of the routine tasks required to manage Oracle databases, which Oracle says can free up database administrators (DBAs) to do higher-level and more strategic work.Continue Reading

• Oracle cloud services aim to pull users out of IT comfort zone

  Oracle has gone all-in on cloud computing and expanded its line of cloud services in the hopes users will make the jump. But there are issues to weigh first.Continue Reading

• Seven to-do items for managing an Oracle cloud migration

  Migrating Oracle systems to the cloud is a big initiative for any organization. Make sure you put a solid migration plan in place to help ease the transition and keep it on track.Continue Reading

• Oracle sees Autonomous Database changing DBA roles for the good

  The job duties of database administrators will likely change in organizations that use Oracle Autonomous Database Cloud, but in ways that are beneficial, according to Oracle.Continue Reading

• How to use Oracle DBSAT to do a database security assessment

  The Oracle Database Security Assessment Tool is free software that checks the security of databases. Here are the steps involved in using DBSAT to collect data and create reports.Continue Reading

• Oracle Blockchain Cloud Service: What it is and what it does

  Oracle's cloud-based blockchain service supports distributed transaction ledgers to boost data security and validation. Here's a look at the technology and its features.Continue Reading

• Cloud-based database software adds new IT options for users

  The increasing adoption of cloud database services has captured the attention of Oracle and Microsoft as they try to hold their spots at the top of the database market.Continue Reading

• Open Database Connectivity (ODBC)

  Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database.Continue Reading

• Oracle

  Oracle is one of the largest vendors in the enterprise IT market and the shorthand name of its flagship product, a relational database management system (RDBMS) that's formally called Oracle Database.Continue Reading

• What the annual Oracle Database release cycle means for DBAs

  As Oracle changes its database release cycle to yearly updates with new version numbers, Oracle users will get faster access to new features -- but also new upgrade questions to weigh.Continue Reading

• Oracle extents

  Oracle extents are a set of contiguous blocks allocated in an Oracle database.Continue Reading

• foreign key

  A foreign key is a column or columns of data in one table that connects to the primary key data in the original table.Continue Reading

• Five reasons to migrate to an Oracle Multitenant architecture

  Oracle's Multitenant technology enables users to plug multiple databases into a single container database. Is it time for your organization to consider a migration?Continue Reading

• Oracle E-Business Suite

  Oracle E-Business Suite is a set of applications for managing business operations, including customer relationship management, enterprise resource planning and supply chain management processes.Continue Reading

• A new enterprise resource planning system will affect the HFM

  Running an enterprise resource planning system and HFM projects together can be hard, but it offers a time to improve the HFM system and better align reporting.Continue Reading

• New orchestrator helps communication service providers

  The new Oracle Communication Network Service Orchestration solution is designed to guide communications service providers onto NFV.Continue Reading

• New president brings global change management skills to OAUG

  The 2015 OAUG president, Melissa English, found a love of education in teaching her peers. Now she brings global change management skills to the OAUG.Continue Reading

• Oracle Database 12c

  The Oracle Database 12c is a high-performance, enterprise-class database.Continue Reading

• The MicroStrategy best practices for Oracle In-Memory

  Jochen Demuth of MicroStrategy shares three best practices for the Oracle In-Memory Database. The MicroStrategy best practices come from Demuth's experience as a beta tester working closely with Oracle on the In-Memory Database.Continue Reading

• Oracle Database In-Memory

  Oracle Database In-Memory is an optional add-on to Oracle Database 12c that enables Oracle's flagship relational software to function as an in-memory database.Continue Reading

• Oracle Communications Network Charging and Control (OCNCC)

  Oracle Communications Network Charging and Control (OCNCC) is a product from the telecommunications industry used for real-time charging and session control.Continue Reading

• Design Hyperion for a natural class and a functional income statement

  Juan Porter explains what you need in Hyperion or Essbase for calculating a natural class and a functional income statement.Continue Reading

• Oracle ERP software implementation tips and trends

  In this guide, get expert advice for successful Oracle ERP implementation and insights into the future of enterprise resource planning software.Continue Reading

• Oracle gets away from relational DB with NoSQL database architecture

  Robert Sheldon traces the roots of NoSQL, shows the important features of the Oracle NoSQL Database architecture, and describes its implementation.Continue Reading

• Willis develops app to put a personal touch back in voluntary benefits

  Part two of a two-part article: Willis uses PeopleSoft 9.1 to bring back the personal feel to automated insurance selection for voluntary benefits.Continue Reading

• Willis develops app for real-time voluntary benefit selection

  Part one of a two-part article: Willis uses PeopleSoft 9.1 to create real-time automated insurance selection for voluntary benefits.Continue Reading

• Oracle 12c's heat map tool and data optimization can improve storage

  The heat map tool and Automatic Data Optimization features in Oracle 12c should help Oracle database shops improve data storage and compression.Continue Reading

• Handling database migrations, such as upgrading to Oracle 12c

  IOUG President Michelle Malcher talks about database migrations, from finding downtime to test and upgrade, to maintaining patch sets after go-live.Continue Reading

• JD Edwards EnterpriseOne

  JD Edwards EnterpriseOne is a suite of enterprise resource planning (ERP) software that is developed and sold by Oracle Corp.Continue Reading

• Eight tips for building hierarchies in Essbase Cubes

  Rules for member names and aliases, as well as tips for prefixes, suffixes and consistency, will help you build solid hierarchies in Essbase Cubes.Continue Reading

• Oracle TimesTen In-Memory Database

  The Oracle TimesTen In-Memory Database is an in-memory relational database in which all data is located in random access memory (RAM).Continue Reading

• Three tips for using Oracle insert syntax to insert multiple rows

  If you're looking for insert syntax to insert multiple rows in Oracle, read these tips from three of our community members.Continue Reading

• Batch updates to Oracle EPMA metadata

  Learn how to manage your metadata using Oracle EPMA.Continue Reading

• Quiz: Oracle Multitenant and Database 12c

  Test your knowledge of the database virtualization feature Oracle Multitenant and the release of the Oracle 12c database by taking this quiz.Continue Reading

• Guide to Oracle 12c database features and upgrades

  This guide offers a user analysis of Oracle Database 12c features, including the Multitenant add-on, and articles that evaluate the ROI of upgrading.Continue Reading

• correlated subquery

  A correlated subquery is a SQL query that depends on values executed by the outer query in order to complete.Continue Reading

• Quiz: How well do you know Oracle Fusion Apps?

  Not sure if your organization is ready for Fusion Apps? Test your knowledge of Oracle Fusion Applications by taking this brief quiz.Continue Reading

• Oracle Fusion Applications

  Oracle Fusion Applications is an all-encompassing suite of Oracle applications built for enterprise resource planning (ERP), customer relationship management (CRM), human capital management (HCM) and other business tasks.Continue Reading

• Oracle Hyperion

  Hyperion is the business division of Oracle that's known for corporate performance management (CPM) and business intelligence systems. Continue Reading

• Exadata

  Exadata (also called Oracle Exadata Database Machine) in-memory database appliance that supports OLTP (transactional) and OLAP (analytical) database systems.Continue Reading

• sharding

  Sharding is a type of database partitioning that is used to separate very large databases the into smaller, faster, more easily managed pieces called data shards.Continue Reading

• virtual private database (VPD)

  A Virtual Private Database (VPD) makes the database tables seem like they belong to one user when multiple users may actually be using that table.Continue Reading

• virtual (federated) database

  A virtual database, also called a federated database, is a system in which several databases appear to function as a single entity.Continue Reading

• Oracle upgrades: Tips and trends

  If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades.Continue Reading

• Oracle data warehousing tutorial

  In this Oracle data warehousing tutorial, learn data warehousing basics and data warehousing concepts. Get tips on using data warehousing tools, find out the most useful Oracle data warehousing features and learn about the most common data ...Continue Reading

• Oracle ETL tools tutorial

  In this Oracle Extract, Transform and Load (ETL) tutorial, learn how to evaluate Oracle ETL tools, understand ETL concepts and read advice on ETL basics from our panel of experts.Continue Reading

• operational data store (ODS)

  An operational data store (ODS) is a type of database that's often used as an interim logical area for a data warehouse.Continue Reading

• Oracle applications learning guide

  This learning guide is a one-stop shop for information on Oracle's changing role in the enterprise applications space, with news, analysis and tips on Oracle's acquisitions, Project Fusion, E-Business Suite and other apps, the battle between Oracle ...Continue Reading

• Stored procedures in PL/SQL

  Learn about Oracle PL/SQL stored procedures, such as the stored procedure definition and stored procedure examples in this PL/SQL tutorial for beginners and experts.Continue Reading

• PL/SQL functions and triggers in Oracle

  Learn about using Oracle PL/SQL functions and triggers, such as how to import a trigger and how and when to use a PL/SQL function in this PL/SQL tutorial.Continue Reading

• MySQL Connector/ODBC (Connector ODBC or MyODBC)

  MySQL Connector/ODBC (sometimes called just Connector ODBC or MyODBC) is a driver for connecting to a MySQL database server through the Open Database Connectivity (ODBC) application program interface (API), which is the standard means of connecting ...Continue Reading

• Solving common Oracle error codes guide

  Solve your Oracle errors quickly and easily with help from this fast guide. It covers every expert response pertaining to Oracle errors on SearchOracle.com.Continue Reading

• Oracle database performance tuning guide

  Learn the tricks of industry experts for identifying and eliminating performance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common ...Continue Reading

• Real Application Cluster (RAC)

  Real Application Cluster (RAC) is a component of the Oracle 9i database product that allows a database to be installed across multiple servers... (Continued)Continue Reading

• Crash Course: Oracle basics

  This crash course will bring you up to speed on Oracle DBMS basics for versions 8.x through 9.x, and provide you with an overview of Oracle10g's new tools and features.Continue Reading

• Solaris

  Solaris is the computer operating system that Sun Microsystems provides for its family of Scalable Processor Architecture-based processors as well as for Intel-based processors.Continue Reading

• 10g

  10g is Oracle's grid computing product group including (among other things) a database management system (DBMS) and an application server. In addition to supporting grid computing features such as resource sharing and automatic load balancing. (...Continue Reading

• responsibility

  In an Oracle environment, a responsibility is a defined user right, similar to the word privilege in some other settings.Continue Reading

• flexfield

  In an Oracle environment, a flexfield is a database field that has flexibility built into it so that users can define reporting structures that are relevant to their specific organizations.Continue Reading

• concurrent processing

  Concurrent processing is a computing model in which multiple processors execute instructions simultaneously for better performance.Continue Reading

• metadata repository

  A metadata repository is a database of data about data (metadata).Continue Reading

• metainformation

  Metainformation is information about information.Continue Reading

• metabase (metadatabase or metadata repository)

  A metabase (sometimes called a metadatabase or metadata repository) is a database for storing metadata (data that describes data) for a specific purpose.Continue Reading

• E. F. Codd (Edgar F. "Ted" Codd)

  E. F. Codd (Edgar F. "Ted" Codd) formed the concepts for organizing and accessing data that are embodied in the relational database, the predominant approach to data organization in today's business world.Continue Reading

• AS2 (Applicability Statement 2)

  AS2 (Applicability Statement 2) is a specification for Electronic Data Interchange (EDI) between businesses using the Internet's Web page protocol, the Hypertext Transfer Protocol (HTTP).Continue Reading

• autonomous transaction

  In Oracle's database products, an autonomous transaction is an independent transaction that is initiated by another transaction.Continue Reading

• row

  In a database, a row (sometimes called a record) is the set of fields within a table that are relevant to a specific entity.Continue Reading

• dynamic SQL (Dynamic Structured Query Language)

  Dynamic SQL is an enhanced form of Structured Query Language (SQL) that, unlike standard (or static) SQL, facilitates the automatic generation and execution of program statements.Continue Reading

• splay tree

  A splay tree is a self-adjusting search algorithm for placing and locating files (called records or keys) in a database.Continue Reading

• CFML (ColdFusion Markup Language)

  CFML (ColdFusion Markup Language) is a Web page markup language that allows a Web site developer to create pages with variable information (text or graphics) that is filled in dynamically (on the fly) in response to variables such as user input.Continue Reading

• field

  A field is an area in a fixed or known location in a unit of data such as a record, message header, or computer instruction that has a purpose and usually a fixed size.Continue Reading

• record

  In computer data processing, a record is a collection of data items arranged for processing by a program.Continue Reading

• relational online analytical processing (ROLAP)

  Relational online analytical processing (ROLAP) is a form of online analytical processing (OLAP) that performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually ...Continue Reading

• DSML (Directory Services Markup Language)

  DSML (Directory Services Markup Language) is an application of the Extensible Markup Language (XML) that enables different computer network directory formats to be expressed in a common format and shared by different directory systems.Continue Reading

• multidimensional database (MDB)

  A multidimensional database (MDB) is a type of database that is optimized for data warehouse and online analytical processing (OLAP) applications. Multidimensional databases are frequently created using input from existing relational databases.Continue Reading

• Query by Example (QBE)

  Query by Example (QBE) is a method of query creation that allows the user to search for documents based on an example in the form of a selected text string or in the form of a document name or a list of documents.Continue Reading

• Pick

  Pick is a data base management system (DMS) based on a business model of data and its organization and traditionally associated with minicomputer systems for small- to medium-size businesses.Continue Reading

• Good Automated Laboratory Practices (GALP)

  Good Automated Laboratory Practices (GALP) is a standardized set of best practices that are used to ensure data integrity for laboratory data that is gathered, processed, and archived by a laboratory information management system (LIMS).Continue Reading

• Relational Database Management System (RDBMS) fundamentals tutorial

  New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database management system.Continue Reading

• The Open Group

  The Open Group is a software standards organization that is sponsored by a number of major software vendors.Continue Reading

• delimiter

  In computer programming, a delimiter is a character that identifies the beginning or the end of a character string (a contiguous sequence of characters).Continue Reading

• Very Large Database (VLDB)

  While there is apparently no official or standard definition for the term Very Large Database (VLDB), it is sometimes used to describe databases occupying magnetic storage in the terabyte range and containing billions of table rows.Continue Reading

• Z39.50

  Z39.50 is a standard communications protocol for the search and retrieval of bibliographic data in online databases.Continue Reading

• repository

  In information technology, a repository (pronounced ree-PAHZ-ih-tor-i) is a central place in which an aggregation of data is kept and maintained in an organized way, usually in computer storage.Continue Reading

• bioinformatics

  Bioinformatics is the science of developing computer databases and algorithms for the purpose of speeding up and enhancing biological research.Continue Reading