Preview

Oracle Features

Good Essays
Open Document
Open Document
6482 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Oracle Features
Oracle Features
The Oracle database is a broad and powerful product.
To give some structure to the broad spectrum of the Oracle database, we’ve organized the features into the following sections:
• Database application development features
• Database connection features
• Distributed database features
• Data movement features
• Performance features
• Database management features
Database Application Development Features
The main use of the Oracle database system is to store and retrieve data for applications. The features of the Oracle database and related products described in this section are used to create applications. We’ve divided the discussion in this section into two categories: database programming and database extensibility options. Later in this chapter, we describe the Oracle Developer Suite, a set of optional tools used in
Oracle Database Server and Oracle Application Server development.
Database Programming
All flavors of the Oracle database include different languages and interfaces that allow programmers to access and manipulate the data in the database. Database programming features usually interest two groups: developers building Oracle-based applications that will be sold commercially, and IT organizations within companies that custom-develop applications unique to their businesses. The following sections describe the languages and interfaces supported by Oracle.This is the Title of the Book, eMatter Edition
Copyright © 2004 O’Reilly & Associates, Inc. All rights reserved.
10 | Chapter 1: Introducing Oracle
SQL
The ANSI standard Structured Query Language (SQL) provides basic functions for data manipulation, transaction control, and record retrieval from the database. However, most end users interact with Oracle through applications that provide an interface that hides the underlying SQL and its complexity.
PL/SQL
Oracle’s PL/SQL, a procedural language extension to SQL, is commonly used to implement program logic
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    pt2520 assignment 1
    • 466 Words
    • 2 Pages

    pt2520 assignment 1

    Oracle Express features: application builder for mobile, mobile and response themes, HTML5 charts, HTML5 item types, mobile calendar, packages applications, RESTful web services, Oracle Fail Safe, SQLJ, Oracle Developer Tools for Visual Studio .NET, Microsoft Distributed Transaction Coordinator support, Active Directory integration, Native .NET Data Provider—ODP.NET,.NET Stored Procedures.…

    • 466 Words
    • 2 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Unit 6 True
    • 287 Words
    • 1 Page

    Unit 6 True

    SQL is the programming language used to manipulate data and data objects in a relational database management system. TRUE…

    • 287 Words
    • 1 Page
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    unit 6
    • 360 Words
    • 2 Pages

    unit 6

    1) SQL is the programming language used to manipulate data and data objects in a relational database management system.…

    • 360 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Final Exam Review Questions
    • 1917 Words
    • 8 Pages

    Final Exam Review Questions

    A database language must enable the user to perform complex queries designed to transform the raw data into useful information.…

    • 1917 Words
    • 8 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Riordan Manufacturing Case Study
    • 3551 Words
    • 15 Pages

    Riordan Manufacturing Case Study

    Riordan Manufacturing, Inc. has earned international recognition as a leader in the field of plastic injection molding with its pioneering plastic designs. Products include plastic beverage containers manufactured at its plant in Albany, Georgia, modified plastic parts produced at its plant in Pontiac, Michigan, and plastic fan parts manufactured at its facilities in Hangzhou, China. Research and development for the company is carried out at its corporate headquarters in San Jose, California. Altogether Riordan Manufacturing employs 550 people within its four facilities, including 125 corporate members. Extreme precision and quality control standards exceeding ISO 9000 allow Riordan to maintain a customer…

    • 3551 Words
    • 15 Pages
    Powerful Essays
    Read More
  • Good Essays

    Assingment 1
    • 663 Words
    • 3 Pages

    Assingment 1

    Applications and utility software are used to access and use data in the DBMS and to manage the computer environment. Application programs developed in programming languages such as C++, Visual Basic that are used to access database in database management system. Utilities are the tools that helps to to manage the computer components such as anti-virus programs.…

    • 663 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    The Truth Behind the Billion Dollar Story and Lessons for the Dod
    • 26520 Words
    • 107 Pages

    The Truth Behind the Billion Dollar Story and Lessons for the Dod

    Baum, David and others. “Oracle 25 Years of Technology Innovation.” Oracle Magazine, November/December, 2001, pp. 65-82.…

    • 26520 Words
    • 107 Pages
    Good Essays
    Read More
  • Better Essays

    Term Paper Intro to I.T.
    • 1605 Words
    • 7 Pages

    Term Paper Intro to I.T.

    Greenwald, R. (2011, November). Creating value with the oracle database cloud service. Retrieved from http://www.oracle.com/technetwork/database/database-cloud/public/extreme-productivity-wp-1844125.pdf…

    • 1605 Words
    • 7 Pages
    Better Essays
    Read More
  • Good Essays

    Exploring Programming Languages
    • 701 Words
    • 3 Pages

    Exploring Programming Languages

    1.) There have been several versions of SQL created in the last 26 years. In 1986, SQL-86 (SQL-87) was first published. In 1989, SQL-89 was a minor revision made to the original SQL. In 1992, SQL-92 (SQL2) was a major revision to its previous version. In 1999, SQL-99 (SQL3) added regular expression matching, recursive queries, triggers, non scalar types and some object oriented features. In 2003, SQL-2003 introduced XML related features, standardized sequences, and columns with auto generated values. In 2006, SQL-2006 defined ways in which SQL can be used in conjunction with XML and it defined ways of importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form. It also enables applications to integrate into their SQL code the use of XQuery. In 2008, SQL-2008 Legalized ORDER BY outside cursor definitions, added INSTEAD OF triggers, and added the TRUNCATE statement. As of March 2012, the newest SQL was released its new features include AlwaysOn SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new Spatial features, Metadata discovery, Sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and Partition level operations and security enhancements including Provisioning During Setup, new permissions, improved role management and default schema assignment for groups…

    • 701 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    CS-669 Assignment 1
    • 985 Words
    • 4 Pages

    CS-669 Assignment 1

    The purpose of the DBMS is to service between users’ applications and database. This way of accessing to data through the DBMS brings several advantages. First of all, it supports multiple user access at the same time, which helps to update data just in time.…

    • 985 Words
    • 4 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    information systems plan for seminole industries research project
    • 5678 Words
    • 23 Pages

    information systems plan for seminole industries research project

    References: (1) Information technology in business: Let me count the ways. (1992). CIO, , 1-1. Retrieved from…

    • 5678 Words
    • 23 Pages
    Powerful Essays
    Read More
  • Good Essays

    Ibm Db2 vs Oracle
    • 1231 Words
    • 5 Pages

    Ibm Db2 vs Oracle

    For this week 's paper I have chosen to do a comparison between IBM 's DB2 database management system (DBMS) product and Oracle. Realistically, making such a comparison is akin to discussing religion with friends. Each person will have their own biases based on their own experiences. Looking for an unbiased opinion is much like looking for the Holy Grail, every bit as speculative and subjective with the results jaundiced by the outlook of the reporter (Lim, 2002).…

    • 1231 Words
    • 5 Pages
    Good Essays
    Read More
  • Powerful Essays

    Introduction to Oracle 9i: Sql Chapter 4-10
    • 1047 Words
    • 5 Pages

    Introduction to Oracle 9i: Sql Chapter 4-10

    Introduction to Oracle 9i: SQL Name: _______ Junel L Cofino Table of Contents Introduction: I-7 - Relational and Object Relational Database Management System I-10 - System Development Life Cycle I-12 - Relational Database Concept I-20 - Relational Database Properties I-24 - Tables used in the course Chapter 1: Writing Basic SELECT SQL Statements 1-4- Basic Select Statement 1-5- Selecting All Columns 1- 6- Selecting Specific Columns 1-7- Writing SQL Statements 1-8- Column Heading Defaults 1-9- Arithmetic Expressions 1-15- Null Values in Arithmetic Expressions 1-16- Defining A Column Alias 1-17- Using Column Alias 1-18- Concatenation Operator 1-19- Using Concatenation Operator 1-22- Duplicate Rows 1-23- Eliminating Duplicate Rows Chapter 2: Restricting and Sorting Data 2-4-Limiting the Rows Selected 2-5-Using WHERE Clause 2-6- Character Strings and Dates 2-7- Comparison Conditions 2-8- Using Comparison Conditions 2-9- Other Comparison Conditions 2-10- Using the BETWEEN Condition…

    • 1047 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    Sql Introduction to Database
    • 887 Words
    • 4 Pages

    Sql Introduction to Database

    SQL was invented and developed by IBM in early 1970’s. IBM was able to demonstrate how to control relational databases using SQL. The SQL implemented by ORACLE CORPORATION is 100% compliant with the ANSI/ISO standard SQL data language. Oracle’s database language is SQL, which is used for storing and retrieving information. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. A table is a primary database object of SQL that is used to store data. A table holds data in the form of rows and columns…

    • 887 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Oracle Rac
    • 841 Words
    • 4 Pages

    Oracle Rac

    Students will learn about RAC database administration in the Oracle Grid Infrastructure environment. Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus. Students will study the new connection architecture and how to make those connections highly available. Backup and recovery issues relative to cluster database environments will also be studied.…

    • 841 Words
    • 4 Pages
    Good Essays
    Read More

Related Topics