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

20. Use SQL More Often with Advanced Dynamic SQL

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

SQL is Oracle’s greatest strength. Dynamic SQL is important because it gives us more opportunities to use SQL. Chapter 14 introduced the basic features: using dynamic SQL for DDL, unknown objects, and simplifying privileges; EXECUTE IMMEDIATE and bind variable syntax; simplifying dynamic code with multiline strings, alternative quoting syntax, and templating; and the benefit of generating code instead of creating generic code.

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 Solve Challenging Problems with Arcane SQL Features
next chapter Level Up Your Skills with PL/SQL
Footnotes
1
The example assumes you have installed https://github.com/method5/plsql_lexer .
 
2
Although DBMS_SQL can parse SQL, it does not make the entire parse tree available the way ANTLR does. DBMS_SQL can only solve a small number of our parsing problems.
 
3
The example assumes you have installed https://github.com/method5/method4 .
 
4
The example assumes you have installed Method5 from https://method5.github.io/ .
 
Metadata
Title
Use SQL More Often with Advanced Dynamic SQL
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_20

Premium Partner

    Image Credits