Veze, linkovi
Kompjuter biblioteka
Korpa
Oracle PL/SQL primeri

Baze podataka Baze podataka

Oracle PL/SQL primeri

Autor: Benjamin Rosenzweig, Elena Rakhimov
Broj strana: 525
ISBN broj: 9780133796780
Izdavač: PEARSON EDUCATION PEARSON EDUCATION
Godina izdanja: 2015.

                 
Twitter   Facebook   Linkedin   Pinterest   Email
                 
Predlog za prevod

 

Oracle® PL/SQL by Example, Fifth Edition, teaches all the PL/SQL skills you’ll need, through real-world labs, extensive examples, exercises, and projects. Now fully updated for the newest version of PL/SQL, it covers everything from basic syntax and program control through the latest optimization and security enhancements.

Step by step, you’ll walk through every key task, mastering today’s most valuable Oracle 12cPL/SQL programming techniques on your own. Start by downloading projects and exercises from informit.com/title/0133796787. Once you’ve done an exercise, the authors don’t just present the answer: They offer an in-depth discussion introducing deeper insights and modern best practices.

This book’s approach fully reflects the authors’ award-winning experience teaching PL/SQL to professionals at Columbia University. New database developers and DBAs can use it to get productive fast; experienced PL/SQL programmers will find it to be a superb Oracle Database 12csolutions reference.

New in This Edition

  • Updated code examples throughout
  • Result-caching of invoker’s right functions for better performance
  • Extended support for PL/SQL-only data types in dynamic SQL, OCI, and JDBC
  • Security enhancements, including ACCESSIBLE BY whitelists, improved privilege control, and Invisible Columns

Other topics covered

  • Mastering basic PL/SQL concepts and language fundamentals, and understanding SQL’s role in PL/SQL
  • Using conditional and iterative program control, including CONTINUE and CONTINUE WHEN
  • Efficiently handling errors and exceptions
  • Working with cursors and triggers, including compound triggers
  • Using stored procedures, functions, and packages to write modular code that other programs can run
  • Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced features

Preface xvii

Acknowledgments xxi

About the Authors xxiii

Introduction to PL/SQL New Features in Oracle 12c xxv

Invoker’s Rights Functions Can Be Result-Cached xxvi

More PL/SQL-Only Data Types Can Cross the PL/SQL-to-SQL Interface Clause xxvii

ACCESSIBLE BY Clause xxvii

FETCH FIRST Clause xxviii

Roles Can Be Granted to PL/SQL Packages and Stand-Alone Subprograms xxix

More Data Types Have the Same Maximum Size in SQL and PL/SQL xxx

Database Triggers on Pluggable Databases xxx

LIBRARY Can Be Defined as a DIRECTORY Object and with a CREDENTIAL Clause xxx

Implicit Statement Results xxxi

BEQUEATH CURRENT_USER Views xxxii

INHERIT PRIVILEGES and INHERIT ANY PRIVILEGES Privileges xxxii

Invisible Columns xxxiii

Objects, Not Types, Are Editioned or Noneditioned xxxiv

PL/SQL Functions That Run Faster in SQL xxxiv

Predefined Inquiry Directives $$PLSQL_UNIT_OWNER and $$PLSQL_UNIT_TYPE xxxvi

Compilation Parameter PLSQL_DEBUG Is Deprecated xxxvii

Chapter 1: PL/SQL Concepts 1

Lab 1.1: PL/SQL Architecture 2

Lab 1.2: PL/SQL Development Environment 9

Lab 1.3: PL/SQL: The Basics 18

Summary 25

Chapter 2: PL/SQL Language Fundamentals 27

Lab 2.1: PL/SQL Programming Fundamentals 28

Summary 41

Chapter 3: SQL in PL/SQL 43

Lab 3.1: DML Statements in PL/SQL 44

Lab 3.2: Transaction Control in PL/SQL 49

Summary 55

Chapter 4: Conditional Control: IF Statements 57

Lab 4.1: IF Statements 58

Lab 4.2: ELSIF Statements 63

Lab 4.3: Nested IF Statements 67

Summary 70

Chapter 5: Conditional Control: CASE Statements 71

Lab 5.1: CASE Statements 71

Lab 5.2: CASE Expressions 80

Lab 5.3: NULLIF and COALESCE Functions 84

Summary 89

Chapter 6: Iterative Control: Part I 91

Lab 6.1: Simple Loops 92

Lab 6.2: WHILE Loops 98

Lab 6.3: Numeric FOR Loops 104

Summary 109

Chapter 7: Iterative Control: Part II 111

Lab 7.1: CONTINUE Statement 111

Lab 7.2: Nested Loops 118

Summary 122

Chapter 8: Error Handling and Built-in Exceptions 123

Lab 8.1: Handling Errors 124

Lab 8.2: Built-in Exceptions 126

Summary 132

Chapter 9: Exceptions 133

Lab 9.1: Exception Scope 133

Lab 9.2: User-Defined Exceptions 137

Lab 9.3: Exception Propagation 141

Summary 147

Chapter 10: Exceptions: Advanced Concepts 149

Lab 10.1: RAISE_APPLICATION_ERROR 149

Lab 10.2: EXCEPTION_INIT Pragma 153

Lab 10.3: SQLCODE and SQLERRM 155

Summary 158

Chapter 11: Introduction to Cursors 159

Lab 11.1: Types of Cursors 159

Lab 11.2: Cursor Loop 165

Lab 11.3: Cursor FOR LOOPs 175

Lab 11.4: Nested Cursors 177

Summary 181

Chapter 12: Advanced Cursors 183

Lab 12.1: Parameterized Cursors 183

Lab 12.2: Complex Nested Cursors 185

Lab 12.3: FOR UPDATE and WHERE CURRENT Cursors 187

Summary 190

Chapter 13: Triggers 191

Lab 13.1: What Triggers Are 191

Lab 13.2: Types of Triggers 205

Summary 211

Chapter 14: Mutating Tables and Compound Triggers 213

Lab 14.1: Mutating Tables 213

Lab 14.2: Compound Triggers 217

Summary 223

Chapter 15: Collections 225

Lab 15.1: PL/SQL Tables 226

Lab 15.2: Varrays 235

Lab 15.3: Multilevel Collections 240

Summary 242

Chapter 16: Records 243

Lab 16.1: Record Types 243

Lab 16.2: Nested Records 250

Lab 16.3: Collections of Records 253

Summary 257

Chapter 17: Native Dynamic SQL 259

Lab 17.1: EXECUTE IMMEDIATE Statements 260

Lab 17.2: OPEN-FOR, FETCH, and CLOSE Statements 271

Summary 280

Chapter 18: Bulk SQL 281

Lab 18.1: FORALL Statements 282

Lab 18.2: The BULK COLLECT Clause 291

Lab 18.3: Binding Collections in SQL Statements 299

Summary 309

Chapter 19: Procedures 311

Benefits of Modular Code 312

Lab 19.1: Creating Procedures 312

Lab 19.2: Passing Parameters IN and OUT of Procedures 315

Summary 319

Chapter 20: Functions 321

Lab 20.1: Creating Functions 321

Lab 20.2: Using Functions in SQL Statements 327

Lab 20.3: Optimizing Function Execution in SQL 329

Summary 331

Chapter 21: Packages 333

Lab 21.1: Creating Packages 334

Lab 21.2: Cursor Variables 344

Lab 21.3: Extending the Package 353

Lab 21.4: Package Instantiation and Initialization 366

Lab 21.5: SERIALLY_REUSABLE Packages 368

Summary 371

Chapter 22: Stored Code 373

Lab 22.1: Gathering Information about Stored Code 373

Summary 382

Chapter 23: Object Types in Oracle 385

Lab 23.1: Object Types 386

Lab 23.2: Object Type Methods 394

Summary 404

Chapter 24: Oracle-Supplied Packages 405

Lab 24.1: Extending Functionality with Oracle-Supplied Packages 406

Lab 24.2: Error Reporting with Oracle-Supplied Packages 419

Summary 429

Chapter 25: Optimizing PL/SQL 431

Lab 25.1: PL/SQL Tuning Tools 432

Lab 25.2: PL/SQL Optimization Levels 438

Lab 25.3: Subprogram Inlining 444

Summary 453

Appendix A: PL/SQL Formatting Guide 455

Case 455

White Space 455

Naming Conventions 456

Comments 457

Other Suggestions 457

Appendix B: Student Database Schema 461

Table and Column Descriptions 461

Index 469

 

Komentari

• Dragan Radisavljevic
U bre pa vi to vec skoro ima vise od godinu dana kako planirate, predjite na dela

• Radenko Vojinović
Da li imate prevod ove knjige ili prodajete na engleskom?

Pozdrav Nemamo ni prevod, ni original. Planiramo da objavimo prevod.

Ostavite komentar Ostavite komentar

 

Preporučujemo

Nema slike

Popust cena:
rsd

Veze, linkovi
Linkedin Twitter Facebook
 
     
 
© Sva prava pridržana, Kompjuter biblioteka, Beograd, Obalskih radnika 4a, Telefon: +381 11 252 0 272