Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top
Published in:
Understand Relational Databases Read chapter Read first chapter

2019 | OriginalPaper | Chapter

9. Improve the Database with Advanced Oracle Schema Objects

Author : Jon Heller

Published in: Pro Oracle SQL Development

Publisher: Apress

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

So far this book has used pre-built objects but now it’s time to start making our own. This book assumes you are familiar with basic Data Definition Language commands like CREATE TABLE. This chapter describes advanced features of Oracle schema objects and the advanced DDL commands to create and maintain them.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

inform now
previous chapter Modify Data with Advanced DML
next chapter Optimize the Database with Oracle Architecture
Footnotes
1
There are ALTER commands that affect object-relational code. But those exceptions are a reason why we should avoid object-relational technology. It’s a nightmare when altering code permanently breaks our data.
 
2
Adrian Billington’s excellent website describes how to use a preprocessor to generate a list of files in a directory: www.oracle-developer.net/display.php?id=513 .
 
4
Partition-wise joins work one partition at a time. Joining per partition instead of per table can significantly decrease the memory requirements and improve performance. But partition-wise joins only happen if the tables are partitioned the exact same way and the join uses the partition column. Most hash-partitioned tables are a mistake because programmers incorrectly think partition-wise joins happen with every join.
 
5
To make things even more confusing, Oracle has an unrelated CREATE SCHEMA command. The CREATE SCHEMA command does not create a user, the command is for creating multiple objects with one statement. This unusual command is useful for creating tables with circular dependencies.
 
Metadata
Title
Improve the Database with Advanced Oracle Schema Objects
Author
Jon Heller
Copyright Year
2019
Publisher
Apress
Book
Pro Oracle SQL Development

Print ISBN: 978-1-4842-4516-3

Electronic ISBN: 978-1-4842-4517-0

Copyright Year: 2019

DOI
https://doi.org/10.1007/978-1-4842-4517-0_9

Premium Partner

    Image Credits