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

• Flip the switch and turn on Oracle Database In-Memory

  Oracle Database In-Memory turns Oracle Database 12c into an in-memory database. It promises to accelerate performance for both analytics and queries using its dual format architecture. Find out more from a beta tester.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

• Not much Exadata training necessary for experienced DBAs, says expert

  A database consultant says using Exadata is relatively easy for IT shops already managing Oracle Database. But some new DBA skills may be required.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

• Memphis to make assets out of infrastructure with EAM implementation

  Memphis CIO Ben Nair explains how his city's plans to implement Oracle EAM will create a more efficient government and make the trucks run on time.Continue Reading

• Oracle Mobile Security Suite (OMSS)

  Oracle Mobile Security Suite (OMSS) is a mobile security system intended to allow organizations to provide secure application access from mobile devices to enterprise applications.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 in-memory database option: Intro and implementation

  Learn about the forthcoming Oracle Database 12c In-Memory Option and some preliminary considerations you need to take into account.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

• Analyst talks Exadata x4-2, Oracle Database 12c

  IDC Research Vice President Carl Olofson talks about the new features of Oracle Exadata x4-2 and Oracle Database 12c.Continue Reading

• Top 5 Oracle stories of 2013

  Oracle Database 12c, Fusion Applications and Hyperion are some of the topics that hit home with SearchOracle readers in 2013.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

• Guide to Oracle engineered systems and server appliances

  This guide offers expert and user insights into engineered systems and server appliances such as Oracle Exadata and Oracle Database Appliance.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

• Quiz: How well do you know Oracle Solaris 11?

  From the basics to specific commands, this quiz will test you on how well you know Solaris 11 and where you might want to brush up a bit.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 application upgrade guide

  Read this Oracle application upgrade guide for news, demos and advice on the latest in Oracle application upgrades, whether you’re upgrading Oracle E-Business Suite, PeopleSoft or to Oracle Fusion applications.Continue Reading

• Oracle database upgrade guide

  If you’re considering a move to a new Oracle database version -- especially Oracle Database 11g or Oracle Database 11gR2 -- read our Oracle database upgrade guide for tips and customer success stories.Continue Reading

• Oracle application development trends toward the Web

  With the economy forcing developers to pursue less expensive methods of Oracle application development, many are evaluating Web development tools, including those for Rapid Application Development.Continue Reading

• Oracle APEX is totally RAD for Web development

  Oracle’s Application Express (APEX) development environment allows developers to create Web applications quickly for Oracle databases that feature Rapid Application Development (RAD) tools.Continue Reading

• RAD Studio 2010 supports Oracle databases, .NET environments

  The three versions of Embarcadero’s RAD Studio 2010 are designed for individual developers and teams of developers building client-server and RAD Web applications for native Windows and .NET.Continue Reading

• Toad 10: Good for database developers, good for administrators

  A major strength of Toad 10 is its ability to serve both Oracle database application developers and administrators equally well.Continue Reading

• Codeless AJAX development improves Alpha Five V10 for the Web

  By adding a form of codeless AJAX development, Alpha Software lets V10 developers create Web-based apps with richer user interface controls.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 datatypes in Oracle

  Learn about PL/SQL datatypes in Oracle, and learn the definitions of BLOB, CLOB, DATE, VACHAR2 and more 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

• Oracle data export guide

  Exporting data is a common task for an Oracle DBA, but not necessarily a straightforward one. In this compliation of questions and answers, SearchOracle.com's resident Oracle experts Eli Leiba, Karen Morton and Brian Peasland explain how it's done, ...Continue Reading

• Oracle Enterprise Manager quiz

  Test your knowledge of Oracle Enterprise Manager by taking this OEM quiz.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

• Oracle database security guide

  Keeping data and systems secure is a must for any Oracle DBA. Beyond patching known security flaws, there is a great deal a DBA can do to protect Oracle DBMSs and applications from security breaches, both from inside and outside your organization....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

• concurrent processing

  Concurrent processing is a computing model in which multiple processors execute instructions simultaneously for better performance.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

• 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