Sams Teach Yourself Oracle PL/SQL in 10 Minutes - Brossura

Forta, Ben

Brossura

ISBN 10: 0672328666 ISBN 13: 9780672328664

Casa editrice: Sams, 2015

Riassunto

PL/SQL is Oracle's proprietary variant of the industry standard Structured Query Language (SQL). In order to effectively develop or maintain - or even use - an Oracle database you need to have a good working knowledge of PL/SQL. This book teaches you what you really need to know, without getting bogged down by what you don't. Sams Teach Yourself Oracle PL/SQL in 10 Minutesa tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling on database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data. It uses the format of the author's bestselling Sams Teach Yourself SQL in 10 Minutes.

Su questo libro

L'autore:

Ben Forta is Adobe Systems’ Director of Developer Relations and has more than 20 years of experience in the computer industry in product development, support, training, and product marketing. He spent six years as part of the development team responsible for creating OnTime, one of the most successful calendar and group-scheduling products, with more than one million users worldwide. Ben is the author of many books, includingSams Teach Yourself SQL in 10 Minutes , 9780672336072, which is one of the world's bestselling SQL books, now in its fourth edition, with more than 100,000 copies sold, and translated into more than a dozen languages.

Product Description:

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

Su questa edizione

• Editore: Sams
• Data di pubblicazione: 2015
• ISBN 10: 0672328666
• ISBN 13: 9780672328664
• Rilegatura: Copertina flessibile
• Numero edizione: 1
• Numero di pagine: 271