Skip to main content

Humanities, Social Science and Language


Digital Products


Connect®
Course management and student learning tools backed by great support.

McGraw Hill GO
Greenlight learning with the new eBook+

ALEKS®
Personalize learning and assessment

ALEKS® Placement, Preparation, and Learning
Achieve accurate math placement

SIMnet
Ignite mastery of MS Office and IT skills

McGraw Hill eBook & ReadAnywhere App
Get learning that fits anytime, anywhere

Sharpen: Study App
A reliable study app for students

Virtual Labs
Flexible, realistic science simulations

AI Reader
Encourage Discovery, Boost Understanding

Services


Affordable Access
Reduce costs and increase success

Learning Management System Integration
Log in and sync up

Content Collections powered by Create®
Curate and deliver your ideal content

Custom Courseware Solutions
Teach your course your way

Education for All
Let’s build a future where every student has a chance to succeed

Business Program
Explore business learning solutions & resources

Professional Services
Collaborate to optimize outcomes

Remote Proctoring
Validate online exams even offsite

Institutional Solutions
Increase engagement, lower costs, and improve access for your students

Evergreen
Updated, relevant materials—without the hassle.

Support


General Help & Support Info
Customer Service & Tech Support contact information

Online Technical Support Center
FAQs, articles, chat, email or phone support

Support At Every Step
Instructor tools, training and resources for ALEKS, Connect & SIMnet

Instructor Sample Requests
Get step by step instructions for requesting an evaluation, exam, or desk copy

Platform System Check
System status in real time

Oracle Database 10g PL/SQL 101

ISBN10: 0072255404 | ISBN13: 9780072255409

Oracle Database 10g PL/SQL 101
ISBN10: 0072255404
ISBN13: 9780072255409
By Christopher Allen

Step 1 . Download Adobe Digital Editions to your PC or Mac desktop/laptop.

Step 2. Register and authorize your Adobe ID (optional). To access your eBook on multiple devices, first create an Adobe ID at account.adobe.com. Then, open Adobe Digital Editions, go to the Help menu, and select "Authorize Computer" to link your Adobe ID.

Step 3. Open Your eBook. Use Adobe Digital Editions to open the file. If the eBook doesn’t open, contact customer service for assistance.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Get The Ins-and-Outs of SQL and PL/SQL From an Oracle Expert Perform database functions quickly and easily using the comprehensive information in this step-by-step guide. Oracle professional Christopher Allen begins with database basics and progresses to plain-language explanations and real-world examples of SQL statements and PL/SQL programs. You’ll learn how to manage, query, and manipulate data, use SQL*Plus, create SQL functions, and write practical PL/SQL applications. Review questions, chapter summaries, and hands-on projects will have you understanding and exploiting the powerful features of Oracle Database 10g in no time. Create tables, rows, records, columns, and fields Store text, numbers, dates, pictures, and soundfiles in tables and columns Define, manipulate, retrieve, and delete data, using SQL commands Select, sort, and filter records with SQL functions and procedures Write SQL commands to declare variables using anchored types Use SAVEPOINT and ROLLBACK commands to ensure multilevel undo Perform time-based and hierarchical data queries Edit and reuse commands in script files, using the SQL*Plus program Use PL/SQL views, sequences, procedures, functions, and packages Use triggers to automate auditing, security, and maintenance tasks

PART I Database Basics

1 Introduction to Databases

2 Storing and Retrieving Data: The Basics

3 Advanced Data Manipulation

4 Controlling SQL*Plus

PART II Advanced SQL

5 SQL Functions

6 Using Indexes and Constraints

7 Other Useful Oracle Techniques

PART III Create Programs Using PL/SQL

8 Introduction to PL/SQL

9 More PL/SQL ToolsGlossary of Common Oracle Terms

Need support?   We're here to help - Get real-world support and resources every step of the way.

Top