Beginning PL/SQL by Donald Bales
By Donald Bales
Start with PL/SQL, the integrated language that each Oracle developer and database administrator needs to be aware of, in starting PL/SQL, a fast paced and example-filled educational. study from writer Don Bales' wide event to find the main familiar facets of PL/SQL with no losing time with imprecise and out of date features.Author Don Bales takes his 20+ years of expertise and a wealth of records he is collected on PL/SQL utilization over these years and applies the 80/20 rule - conceal what is so much wanted and utilized by PL/SQL execs and stay away from what is now not important! the result's a e-book that covers all of the key positive factors of PL/SQL with no wasting precious time discussing esoteric and out of date components of the language. examine what relatively concerns, for you to get to paintings feeling convinced with what you recognize approximately PL/SQL. * realize the 20% of PL/SQL that offers you eighty% of the bang - key subject matters lined contain variables and datatypes, executing statements, operating with cursors, real-world gadgets, debugging, checking out, and extra. * tips on how to write production-level, object-oriented PL/SQL - you are going to discover relational PL/SQL, yet not like such a lot different books at the topic, Don Bales emphasizes using PL/SQL's object-oriented beneficial properties besides. * paintings via genuine examples of utilizing of PL/SQL - you will examine PL/SQL by means of making use of it to real-world company difficulties, no longer via heavy theory.What you are going to study * How very important SQL is in PL/SQL * the way to use PL/SQL in either a relational and object-relational surroundings * how one can createmaintainable, modular, and reusable PL/SQL application devices * the significance of checking out as you pass, and of creating an everlasting try plan for every module * the significance of establishing debugging services into your code and construction an enduring debug facility for every module * the significance of documenting as you pass, and within the technique construction an enduring documentation set to your reusable modules * tips to follow modular PL/SQL to unravel real-world problemsWho is that this ebook for?Anyone who desires to easy methods to create saved techniques opposed to an Oracle database utilizing PL/SQL. Programmers constructing purposes to be deployed opposed to an Oracle database will want PL/SQL to take complete good thing about the facility Oracle has to provide. Database directors who desire to enforce performance uncovered merely through PL/SQL package deal interfaces also will locate this publication useful.About the Apress starting SeriesThe starting sequence from Apress is the ideal option to get the knowledge you want to land that an important entry-level task. those books will train you a typical and demanding expertise from the floor up simply because they're explicitly designed to take you from "novice to specialist. you are going to begin your trip via seeing what you want to understand - yet with out pointless conception and filler. you will construct your ability set by means of studying the right way to prepare real-world initiatives step-by-step. So even if your aim is your subsequent occupation problem or a brand new studying chance, the start sequence from Apress will take you there - it's your relied on consultant via surprising territory!"
Read or Download Beginning PL/SQL PDF
Similar oracle books
За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.
Grasp Oracle Streams 11g Replication allow real-time details entry and information sharing throughout your allotted framework utilizing the professional details during this Oracle Press advisor. Oracle Streams 11g information Replication explains find out how to arrange and administer a unified firm information sharing infrastructure.
Oracle software show four Recipes offers an example-based method of studying software convey - the ground-breaking, fast program improvement platform integrated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires an exceptional instance or to kick commence their considering and get pointed within the correct course.
- Oracle Database 11g A Beginner's Guide, 1st Edition
- Oracle Embedded Programming and Application Development
- Oracle Embedded Programming and Application Development
- Perl for Oracle DBAs
- The Oracle Universal Content Management Handbook
- Oracle Database 12c DBA Handbook (1st Edition)
Additional info for Beginning PL/SQL
But its most handy use is to create conditional INSERT statements like the one in Listing 1-15. Listing 1-15. Conditional INSERT ... id = 300 ); COMMIT; The subquery in Listing 1-15’s SQL SELECT statement, on lines 11 through 14, first checks to see if the desired entry already exists in the database. If it does, Oracle does not attempt the INSERT; otherwise, it adds the row. You’ll see in time, as your experience grows, that being able to do a conditional insert is very useful! JUST WHO IS THIS DUAL GUY ANYWAY?
It’s Your Turn to Create Content Tables Now that you’ve seen me do it, you should be able to code the scripts to do the same for the WORK and PHYSICAL_WORKPLACE tables (again, don’t forget to suffix them with _T). tab, respectively. Then execute each script. You can view my solutions to these scripts in the book’s source code directory for Chapter 2. Now let’s move on to creating intersection tables. C HA PTER 1 ■ G ENES IS Create an Intersection Table It’s time to create some intersection tables.
We were supposed to put the data in the database in uppercase so we could perform efficient case-insensitive queries. Well, we should fix that. I guess we’ll need to use the UPDATE statement. C HA PTER 1 ■ G ENES IS Update An UPDATE statement allows you to selectively update one or more column values for one or more rows in a specified table. In order to selectively update, you need to specify a WHERE clause in your UPDATE statement. Let’s first take a look at an UPDATE statement without a WHERE clause.