Get started
Bring yourself up to speed with our introductory content.
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
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
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
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
State of Texas implements Oracle Database as a Service
The eGovernment director for the state of Texas, along with a business partner from Xerox, explain how they implemented Oracle Database as a Service.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