Oracle PL/SQL in 10 Minutes, Sams Teach Yourself
Samenvatting
Covers Oracle DBMS versions 10, 11, 12, and XE
'Sams Teach Yourself Oracle PL/SQL in 10 Minutes' offers straightforward, practical answers when you need fast results. By working through the book’s 26 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Oracle’s PL/SQL language.
This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more.
- Tips point out shortcuts and solutions.
- Cautions help you avoid common pitfalls.
- Notes explain additional concepts and provide additional information.
10 minutes is all you need to learn how to...
- Use PL/SQL in the Oracle environments and tools
- Construct complex PL/SQL statements using multiple clauses and operators
- Retrieve, sort, and format database contents
- Pinpoint the data you need using a variety of filtering techniques
- Use string, date-time, and math functions to manipulate your data
- Join two or more related tables
- Insert, update, and delete data
- Create and alter database tables
- Work with views, stored procedures, cursors, triggers, and more
Specificaties
Inhoudsopgave
U kunt van deze inhoudsopgave een PDF downloaden
1. Understanding SQL
2. Getting Started with Oracle and PL/SQL
3. Working with Oracle
4. Retrieving Data
5. Sorting Retrieved Data
6. Filtering Data
7. Advanced Data Filtering
8. Using Wildcard Filtering
9. Searching Using Regular Expressions
10. Creating Calculated Fields
11. Using Data Manipulation Functions
12. Summarizing Data
13. Grouping Data
14. Working with Subqueries
15. Joining Tables
16. Creating Advanced Joins
17. Combining Queries
18. Inserting Data
19. Updating and Deleting Data
20. Creating and Manipulating Tables
21. Using Views
22. Working with Stored Procedures
23. Using Cursors
24. Using Triggers
25. Managing Transaction Processing
26. Managing Security
Appendix A: The Example Tables
Appendix B: Oracle PL/SQL Datatypes
Appendix C: Oracle PL/SQL Reserved Words and Keywords
Index
Anderen die dit boek kochten, kochten ook
-
Bob van Duuren€ 34,99 -
Simon Asplen–taylor€ 53,89
-
Bitmap Books€ 65,54
-
Nader Rad€ 34,83
-
Jordan Morrow€ 48,60
-
Razi Rais€ 50,14
Net verschenen
Rubrieken
- aanbestedingsrecht
- aansprakelijkheids- en verzekeringsrecht
- accountancy
- algemeen juridisch
- arbeidsrecht
- bank- en effectenrecht
- bestuursrecht
- bouwrecht
- burgerlijk recht en procesrecht
- europees-internationaal recht
- fiscaal recht
- gezondheidsrecht
- insolventierecht
- intellectuele eigendom en ict-recht
- management
- mens en maatschappij
- milieu- en omgevingsrecht
- notarieel recht
- ondernemingsrecht
- pensioenrecht
- personen- en familierecht
- sociale zekerheidsrecht
- staatsrecht
- strafrecht en criminologie
- vastgoed- en huurrecht
- vreemdelingenrecht
