Oracle Database 12c Hands-On SQL and PL/SQL - Softcover

Asnani, Satish

Softcover

ISBN 10: 8120351517 ISBN 13: 9788120351516

Publisher: PHI Learning, 2016

Synopsis

The book teaches the basics of the Oracle database from a beginnerâ s perspective to the advanced concepts using a hands-on approach. Each and every concept has been elaborated with suitable practical examples along with code for clear and precise understanding of the topic. Using a practical approach, this new edition of the book covers the detailed introspection of pluggable databases and explains practically the various new features incorporated in the new 12c version. It also explains how to retrieve, add, update and delete data in the Oracle database using SQL, SQL*PLUS and PL/SQL. In the process, it discusses the various data types and built-in functions of Oracle, as well as the sorting of records and the table operations. The text also includes coverage of advanced queries using special operators, Oracle security, indexing and stored functions and procedures.

About this title

About the Author

Satish Asnani is currently Senior Manager, Informatics Division, Bharat Heavy Electricals Limited, Bhopal, India. He is a Red Hat Certified Engineer (RHCE) for administration of Linux-based servers and also a Certified Internal Information Security Auditor (CIISA) from STQC, India. Mr. Asnani has more than 15 years of experience in database design, application development and implementation of several 2-tier and 3-tier projects using Oracle Database and Oracle Developer 2000. He has worked on wide range of web technologies also like ASP, ASP.NET and JSP and has been a speaker on various topics in renowned institutions.

Edition details

• Publisher: PHI Learning
• Publication date: 2016
• Language: English
• ISBN 10: 8120351517
• ISBN 13: 9788120351516
• Binding: Paperback
• Edition number: 2
• Number of pages: 544