Imagen del editor

SQL and PL/SQL for Oracle 11g Black Book

P.S. Dehspande

ISBN 10: 8177229400 / ISBN 13: 9788177229400
Editorial: Dreamtech Press/Wiley India, 2011
Nuevos Condición: New Encuadernación de tapa blanda
Comprar nuevo
Precio: EUR 15,05 Convertir moneda
Gastos de envío: EUR 3,99 De India a Estados Unidos de America Destinos, gastos y plazos de envío
Añadir al carrito

Ofrecido por

BookVistas
New Delhi, DELHI, India

Valoración 4 estrellas

Librería en AbeBooks desde: 24 de noviembre de 2010

Descripción

This book, SQL & PL/SQL Black Book, brings to you the complete, latest account of SQL and PL/SQL for Oracle. It gifts you two things?first, it upgrades your knowledge on the subject; and second, the innumerable, exciting examples help you hone your skills in SQL and PL/SQL. The highlight of the book is a clear yet incisive discussion of the basic features of Oracle 10g and the latest advanced features that come with Oracle 11g. The in-depth treatment of the subject in a lucid language will give you an enjoyable learning experience as you have always had with our previous books on Oracle. This comprehensive reference will help you learn the entire spectrum of SQL?from Views to Cube and Roll Up; from Case expressions to Variances and Correlation?and PL/SQL?from Collections to Object types; from Error handling to Triggers; from Object views to Rollback segments; from UNDO tablespace to Expression filter, and many more. All this, as the book zips through the material and does not blather on or repeat points made earlier?no doubt, every aspect is worth the price of the entire. This book will help you to: Dive into the world of SQL and PL/SQL programming in Oracle 11g Grasp all theoretical and practical concepts in programming Understand the advanced features of SQL, such as Analytical queries, multitable inserts, joins, Scalar subqueries, and key preserving Joins Understand the concept of the Server model in software Face OCP exams and interviews (for software professionals) Absorb advanced features in PL/SQL, such as control structures, collections, the LOB datatype, object types, error handling, triggers, object views, rollback segments, the UNDO tablespace, flashback queries, sequence and wrapper, the Expression filter, in addition to security and audit Printed Pages: 892. N° de ref. de la librería 53939

Cantidad: > 20

Hacer una pregunta a la librería

Detalles bibliográficos

Título: SQL and PL/SQL for Oracle 11g Black Book

Editorial: Dreamtech Press/Wiley India

Año de publicación: 2011

Encuadernación: Softcover

Condición del libro: New

Acerca de

Sinopsis:

This book, sql & pl/sql black book, brings to you the complete, latest account of sql and pl/sql for oracle. It gifts you two things-first, it upgrades your knowledge on the subject; and second the innumerable, exciting examples help you build a better skill in sql and pl/sql. The highlight of the book is a clear yet incisive discussion of the basic features of oracle 9i and the latest advanced features that come with oracle 10g. The in-depth treatment of the subject in a lucid language will give you an enjoyable learning experience as you have always had with our previous books on oracle. Unit - i: sql · introduction to sql · set operations · sql operators · aggregate functions and group by clause · updating and deleting data in existing table (dml) · views · assignment-i · assignment-ii · advanced queries · integrity constraints · analytical queries · understanding rollup and cube · understanding joins · scalar subqueries · case expressions · multitable insert and merge · regular expression · statistical functions · model queries · sql quiz unit - ii: pl/sql · pl/sql program features · pl/sql datatypes · understanding control structure · interaction with oracle · collections and records · lob, bfile, and dbms_lob · objects and object types · sample programs-i · sample programs-ii · error handling · subprograms in pl/sql · package · trigger (database) · autonomous transaction · important pl/sql packages · object views · transaction processing in oracle · locking in oracle · rollback segments · undo tablespace · invoker rights and nocopy clause · dependency tracking in oracle · flashback queries · sequence · pl/sql wrapper · oracle expression filter · server model for bill entry system · security and auditing · pl/sql questions

"Sobre este título" puede pertenecer a otra edición de este libro.

Descripción de la librería

Ver la página web de la librería

Condiciones de venta:

All books are new. We accept payments by the following methods:

  1. Credit Card: Visa, MasterCard, or American Express.
  2. PayPal.
  3. Bank Draft or Banker's Cheque.
  4. Bank/Wire Transfer.

Cheques may be made payable to BookVistas.

Books are shipped by DHL, FedEx, Aramex, Registered Air Mail, or Registered SAL (Surface Air
Lifted).

Condiciones de envío:

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.

Todos los libros de esta librería

Métodos de pago
aceptados por la librería

Visa Mastercard American Express Carte Bleue

PayPal Letra de Cambio Transferencia Bancaria