Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, Oracle SQL Recipes is there at your side. Example-based, providing quality solutions to everyday problems Respects your time by putting solutions first and keeping discussions short Solves the most commonly encountered SQL problems What you'll learn Recognize common query patterns and apply their corresponding solutions. Solve common reporting problems such as sorting rows into buckets. Troubleshoot SQL performance problems. Create and manage database objects such as tables, indexes, and views. Work with XML and tree-structured data. Take advantage of analytic functions, regular expressions, hierarchical query support, and other powerful aspects of Oracle SQL. Who is this book for? Oracle SQL Recipes is written for developers and database administrators who write SQL to run against an Oracle database. It is further written for those whose time is precious, and who just wish for a good example to help them get on with their work. If you want to spend your time writing SQL rather than reading about it, then this is the right book for you. About the Apress Recipes Series Apress Recipes series books are carefully selected compendiums of solutions and techniques to help you solve the difficulties that regularly beset developers when they are learning a new language or technology. The recipes are short, and each provides a step-by-step explanation and working code example that allows
"Sinopsis" puede pertenecer a otra edición de este libro.
Grant Allen has worked in the IT field for over 20 years, as a CTO, enterprise architect, and database administrator. Grant's roles have covered private enterprise, academia and the government sector around the world, specialising in global-scale systems design, development, and performance. He is a frequent speaker at industry and academic conferences, on topics ranging from data mining to compliance, and technologies such as databases (DB2, Oracle, SQL Server, MySQL), content management, collaboration, disruptive innovation, and mobile ecosystems like Android. His first Android application was a task list to remind him to finish all his other unfinished Android projects. Grant works for Google, and in his spare time is completing a Ph.D on building innovative high-technology environments. Grant is the author of Beginning DB2, and lead author of Oracle SQL Recipes and The Definitive Guide to SQLite.
"Sobre este título" puede pertenecer a otra edición de este libro.
Librería: HPB-Red, Dallas, TX, Estados Unidos de America
Paperback. Condición: Very Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or limited writing/highlighting. We ship orders daily and Customer Service is our top priority! Nº de ref. del artículo: S_422333015
Cantidad disponible: 1 disponibles
Librería: Better World Books, Mishawaka, IN, Estados Unidos de America
Condición: Very Good. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Nº de ref. del artículo: 47108613-75
Cantidad disponible: 1 disponibles
Librería: Blue Vase Books, Interlochen, MI, Estados Unidos de America
Condición: good. The item shows wear from consistent use, but it remains in good condition and works perfectly. All pages and cover are intact including the dust cover, if applicable . Spine may show signs of wear. Pages may include limited notes and highlighting. May NOT include discs, access code or other supplemental materials. Nº de ref. del artículo: BVV.1430225092.G
Cantidad disponible: 1 disponibles
Librería: Lakeside Books, Benton Harbor, MI, Estados Unidos de America
Condición: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books! Nº de ref. del artículo: OTF-Y-9781430225096
Cantidad disponible: Más de 20 disponibles
Librería: Kennys Bookshop and Art Galleries Ltd., Galway, GY, Irlanda
Condición: New. This book combines the problem/solution approach of the popular SQL Cookbook with the Oracle focus of the successful Mastering Oracle SQL book to offer a solid, solution-oriented reference on Oracle SQL recipes for advanced developers and administrators. Num Pages: 576 pages, biography. BIC Classification: UNSB. Category: (P) Professional & Vocational. Dimension: 234 x 192 x 31. Weight in Grams: 1014. A Problem-solution Approach. 572 pages, 1, black & white illustrations. Cateogry: (P) Professional & Vocational. BIC Classification: UNSB. Dimension: 234 x 192 x 31. Weight: 1014. . 2009. 2009th Edition. Paperback. . . . . Nº de ref. del artículo: V9781430225096
Cantidad disponible: 15 disponibles
Librería: Revaluation Books, Exeter, Reino Unido
Paperback. Condición: Brand New. 1st edition. 500 pages. 9.25x7.50x1.30 inches. In Stock. Nº de ref. del artículo: x-1430225092
Cantidad disponible: 2 disponibles
Librería: Ria Christie Collections, Uxbridge, Reino Unido
Condición: New. In. Nº de ref. del artículo: ria9781430225096_new
Cantidad disponible: Más de 20 disponibles
Librería: Chiron Media, Wallingford, Reino Unido
PF. Condición: New. Nº de ref. del artículo: 6666-IUK-9781430225096
Cantidad disponible: 10 disponibles
Librería: THE SAINT BOOKSTORE, Southport, Reino Unido
Paperback / softback. Condición: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days. Nº de ref. del artículo: C9781430225096
Cantidad disponible: Más de 20 disponibles
Librería: Kennys Bookstore, Olney, MD, Estados Unidos de America
Condición: New. This book combines the problem/solution approach of the popular SQL Cookbook with the Oracle focus of the successful Mastering Oracle SQL book to offer a solid, solution-oriented reference on Oracle SQL recipes for advanced developers and administrators. Num Pages: 576 pages, biography. BIC Classification: UNSB. Category: (P) Professional & Vocational. Dimension: 234 x 192 x 31. Weight in Grams: 1014. A Problem-solution Approach. 572 pages, 1, black & white illustrations. Cateogry: (P) Professional & Vocational. BIC Classification: UNSB. Dimension: 234 x 192 x 31. Weight: 1014. . 2009. 2009th Edition. Paperback. . . . . Books ship from the US and Ireland. Nº de ref. del artículo: V9781430225096
Cantidad disponible: 15 disponibles