Search results
This website offers a comprehensive guide to Oracle Database for beginners and advanced users. You can learn how to install, query, manage, and administer Oracle Database using SQL, PL/SQL, and other features.
- Start Here
The Oracle Database is quite a complex system; getting it up...
- Basics
The Oracle basics section covers the fundamentals of the...
- PL/SQL
Section 1. Getting started with PL/SQL. What is PL/SQL –...
- Oracle View
This section covers Oracle View which is an essential...
- Oracle Index
This section helps you understand and use Oracle indexes to...
- Oracle Sequence
You use the sequence object to generate a sequence of unique...
- Aggregate Functions
Summary: in this tutorial, you will learn how Oracle...
- Analytic Functions
Oracle analytic functions calculate an aggregate value based...
- Start Here
- Querying data. This section guides you through querying data from the Oracle Database. We will begin with a simple query that retrieves data from a single table.
- Sorting data. ORDER BY – sort the result set of a query in ascending or descending order.
- Filtering data. DISTINCT – Eliminate duplicate rows from the output of a query. WHERE – Learn how to specify a condition for rows in the result set returned by a query.
- Joining tables. A visual explanation of Oracle Joins – A brief introduction to joins in Oracle using visual illustrations. INNER JOIN – Show you how to query rows from a table that has matching rows from another table.
Learn about relational databases, database management systems, and Oracle Database features and history. This chapter provides an overview of Oracle Database concepts and architecture for beginners.
Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle Database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user's request.
Learn how to use Oracle Database 19c with this comprehensive guide. Find out how to create, manage, and optimize databases, applications, and features such as Oracle Multitenant, In-Memory, and Sharding.
Tutorial Introduction to SQL. Description This tutorial provides an introduction to the Structured Query Language (SQL), learn how to create tables with primary keys, columns, constraints, indexes, and foreign keys. Tags create table, create, select, insert, update, delete, drop, drop table, recycle bin, purge. Area SQL General.