{"title":"Jonathan Gennick","description":null,"products":[{"product_id":"sql-pocket-guide-book-jonathan-gennick-9780596005122","title":"SQL Pocket Guide","description":"SQL (Standard Query Language) is the universal standard when it comes to querying and updating databases. It's also rich and complex, with so many features that even the most experienced programmers only make use of a small percentage of them. Why is that? Well naturally, when you're deep into your work, you want to avoid distractions. And it's easy to get distracted when you pull your favorite reference book off the shelf. Your solution is the SQL Pocket Guide--a seamless, fast syntax lookup that won't divert you from the task at hand. Concise and easy-to-use, this little book is the portable companion to O'Reilly's SQL in a Nutshell. This unique reference can be a major help to programmers who use SQL in their day-to-day work. Not just an endless collection of syntax diagrams, this small guide addresses the language's complexity head on and leads by example. If you need to look up the syntax for a particular statement, you'll find helpful examples of the technique. You can then combine several techniques for your own SQL statements. The book covers the three most commonly used database products: Oracle, IBM's DB2, and Microsoft's SQL Server. It's a concise reference to frequently used SQL statements and commonly used SQL functions. The SQL Pocket Guide is written for programmers and database administrators who are already familiar with SQL (Structured Query Language) but want to utilize more of the language's features and syntax than they typically do. The book is small enough to always keep close by, and concise enough that you can look up the syntax you need quickly without having to wade through a lot of text. O'Reilly's Pocket References and Guides have become a favorite among programmers everywhere. By providing a wealth of important details in a succinct, well-organized format, these handy books deliver just what you need when you're hard at work. When you've reached a sticking point and need to get to a solution quickly, the new SQL Pocket Guide is the book you'll want to have.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49523044843793,"sku":"GOR001470475","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49614683144465,"sku":"GOR003058517","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":49803423842577,"sku":"CIN0596005121G","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50357833990417,"sku":"CIN0596005121A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50967043277073,"sku":"CIN0596005121VG","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0596005121.jpg?v=1750847689"},{"product_id":"oracle-regular-expressions-pocket-reference-book-jonathan-gennick-9780596006013","title":"Oracle Regular Expressions Pocket Reference","description":"Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level. They provide a powerful way to select data that matches a pattern, as well as to manipulate, rearrange, and change that data. This concise pocket guide is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49531374633233,"sku":"GOR005920112","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":49875309003025,"sku":"CIN0596006012G","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":51004822389009,"sku":"NIN9780596006013","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0596006012.jpg?v=1750977217"},{"product_id":"oracle-sql-plus-pocket-reference-book-jonathan-gennick-9780596008857","title":"Oracle SQL Plus Pocket Reference","description":"The Oracle SQLPlus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to:     Differentiate between SQL and SQLPlus Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQLPlus Specify SQLPlus commands and format elements Tune SQL queries  The new third edition of this book has been updated for Oracle Database 10g to include information on both SQLPlus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.With its quick-reference format and compact size, the Oracle SQLPlus Pocket Reference follows in the long line of successful pocket references offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQLPlus, the bestselling Oracle SQLPlus: The Definitive Guide.Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49535974932753,"sku":"GOR002764158","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50356611383569,"sku":"CIN0596008856VG","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50358013329681,"sku":"CIN0596008856A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":51734284992785,"sku":"CIN0596008856G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53490713526545,"sku":"GOR007974386","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0596008856.jpg?v=1751104447"},{"product_id":"oracle-sql-plus-pocket-reference-book-jonathan-gennick-9781565929418","title":"Oracle SQL*Plus Pocket Reference","description":"This pocket reference offers reference information that should help you use SQL Plus, Oracle's interactive query tool. It summarizes all of the SQL Plus syntax, including the syntax for new Oracle8i release 8.1.6 features. It describes interacting with SQL Plus, selecting data, formatting reports with SQL Plus, and tuning SQL queries. It also contains quick references to the SQL Plus commands and format elements.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49542404505873,"sku":"GOR003120907","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49594758201617,"sku":"GOR003745077","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50422920708369,"sku":"CIN1565929411VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1565929411.jpg?v=1751213660"},{"product_id":"sql-pocket-guide-book-jonathan-gennick-9780596526887","title":"SQL Pocket Guide","description":"A reference to frequently used SQL statements and commonly used SQL functions, this work helps programmers, database administrators, and everyone who uses SQL in their day-to-day work.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49553289740561,"sku":"GOR003197779","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":49983654265105,"sku":"CIN0596526881G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50162974195985,"sku":"CIN0596526881VG","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50358259810577,"sku":"CIN0596526881A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":51528409219345,"sku":"GOR003038296","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0596526881.jpg?v=1751040655"},{"product_id":"sql-pocket-guide-book-jonathan-gennick-9781449394097","title":"SQL Pocket Guide","description":"For programmers and database administrators who use SQL in their day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language's complexity, and covers key aspects of SQL used in Oracle, DB2, SQL Server, MySQL, and PostgreSQL.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49555682033937,"sku":"GOR004350173","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":49692820439313,"sku":"CIN1449394094G","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":49763810869521,"sku":"CIN1449394094VG","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50293793620241,"sku":"CIN1449394094A","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":50427034239249,"sku":"GOR008294274","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":50760076394769,"sku":"GOR006571213","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1449394094.jpg?v=1751272976"},{"product_id":"oracle-sqlplus-book-jonathan-gennick-9781565925786","title":"Oracle SQLPlus","description":"This book is the definitive guide to SQL*Plus. If you want to take best advantage of the power and flexibility of this popular Oracle tool, you need this book. SQL*Plus is an interactive query tool that is ubiquitous in the Oracle world. It is present in every Oracle installation and is available to almost every Oracle developer and database administrator. SQL*Plus has been shipped with Oracle since at least version 6. It continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. It is still the only widely available tool for writing SQL scripts. Despite this wide availability and usage, few developers and DBAs know how powerful SQL*Plus really is. This book introduces SQL*Plus, includes a quick reference to all of its syntax options, and, most important, provides chapters that describe, in step-by-step fashion, how to perform all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus -- and maybe some they didn't realize they COULD perform with SQL*Plus. You will learn how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, customize your SQL*Plus environment, and use the SQL*Plus administrative features (new in Oracle8i). This book is an indispensable resource for readers who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and a quick reference for every user.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49558574563601,"sku":"GOR003454496","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51739368456465,"sku":"CIN1565925785VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53574162317585,"sku":"GOR003313492","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":53642190127377,"sku":"GOR004953674","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1565925785.jpg?v=1751276518"},{"product_id":"definitive-guide-book-jonathan-gennick-9780596007461","title":"Definitive Guide","description":"Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user. The new second edition of Oracle SQL*Plus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe some you didn't realize you could perform. With Oracle SQL*Plus: The Definitive Guide, you'll expertly:  write and execute script files  generate ad hoc reports  extract data from the database  query the data dictionary tables  customize an SQL*Plus environment  and much more It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction. This book is truly the definitive guide to SQL*Plus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49584990322961,"sku":"GOR003528541","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50356564033809,"sku":"CIN0596007469G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51004711862545,"sku":"NIN9780596007461","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51330307784977,"sku":"CIN0596007469VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":51342214562065,"sku":"GOR007114672","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":52969472983313,"sku":"GOR010916840","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0596007469.jpg?v=1751073174"},{"product_id":"sams-teach-yourself-pl-sql-in-21-days-book-jonathan-gennick-9780672317989","title":"Sams Teach Yourself PL\/SQL in 21 Days","description":"Sams Teach Yourself PL\/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL\/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL\/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL\/SQL, Dynamic SQL within PL\/SQL, use of invoker's rights, autonomous transactions, interfacing PL\/SQL with Java, PL\/SQL Bulk Binds, parameter passing by reference, and advanced Querying.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49615313076497,"sku":"GOR001488902","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":49789025288465,"sku":"CIN0672317982A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":50267804827921,"sku":"GOR001932791","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":52104720089361,"sku":"CIN0672317982G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":52104722186513,"sku":"CIN0672317982VG","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0672317982.jpg?v=1751262897"},{"product_id":"oracle-net8-configuration-and-troubleshooting-book-jonathan-gennick-9781565927537","title":"Oracle Net8 Configuration and Troubleshooting","description":"Net8 is the fundamental Oracle technology that allows Oracle services and clients to communicate with each other over a network. Net8 is most often used to connect client software to Oracle database servers. It may also be used to connect database servers to one another, allowing communication between distributed databases. This practical guide provides the information that readers, especially database administrators, need to know in order to install configure, tune, and troubleshoot Net8. It discusses how Oracle's network architecture, products, and name resolution methods work, and it provides the details of client and server configuration using a variety of Oracle protocols and networking products, including: the Oracle Internet Directory (OID), Oracle's implementation of the standard Lightweight Directory Access Protocol (LDAP) - this directory can be used to maintain a central repository of net service names that can be referenced by all clients; Oracle Names, a networking component used mainly in earlier versions of Oracle, that allows net service names to be defined centrally; Multi-Threaded Server (MTS), an environment in which the client connections share access to a pool of shared server processes; and Oracle Connection Manager, a Net8 component that acts much like a router and provides protocol conversion, connection concentration, and access control. The book also describes the utilities Oracle provides to help manage a Net8 environment; these include the Listener Control Utility (lsnrctl), the Oracle Names Control Utility (namesctl), the Oracle Connection Manager Control Utility (cmctl), tnsping, and Net8 Assistant. In addition, it provides a variety of networking troubleshooting techniques and commonly encountered Net8 configuration problems, and provides complete syntax for all networking files and commands.","brand":"WoB","offers":[{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":49799832109329,"sku":"CIN1565927532VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1565927532.jpg?v=1750926564"},{"product_id":"oracle-sql-plus-pocket-reference-book-jonathan-gennick-9780596004415","title":"Oracle SQL*Plus Pocket Reference","description":"SQL*Plus is available at every Oracle site - from the largest data warehouse to the smallest single-user system - and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This pocket reference offers quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for the Oracle9i release. This book boils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide, into an accessible summary and works as a vital companion to the larger book. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. This 2nd edition includes many new features for Oracle9i (e.g., COALESCE function, searched CASE expressions, new table join syntax, partition operations, MERGE statement, and syntax changes in existing SQL*Plus statements such as ACCEPT, DESRIBE, HELP, and SET) It also adds sections on basic SQL (a much-requested feature): INSERT, DELETE, UPDATE, SELECT, and transaction management. The pocket reference size is especially appropriate for this particular subject, since Oracle SQL*Plus is used on every possible platform, it's particularly convenient to be able to carry a small book around from office computer to home computer to laptop.","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49939660243217,"sku":"CIN0596004419G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":49996759499025,"sku":"CIN0596004419VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0596004419.jpg?v=1750880703"},{"product_id":"oracle-8i-dba-s-for-dummies-book-jonathan-gennick-9780764546235","title":"Oracle 8i DBA's For Dummies","description":"New Internet functionality and support for Linux make Oracle8i a milestone release, and this authoritative guide explains all the tools and techniques administrators need to master this potent new database. Some of the new features covered include an embedded Java Virtual Machine, expanded data warehousing capabilities, and enhanced DBA tools. You'll discover SQL Plus basics and tools on your way to finding out more about fine-tuning performance and WebDB strategies. The CD-ROM includes a sample Oracle 8i database, sample scripts, and SQLPlus references.","brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":51565806780689,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":51565806846225,"sku":"GOR002107040","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0764546236.jpg?v=1750979258"}],"url":"https:\/\/www.worldofbooks.com\/collections\/author-books-by-jonathan-gennick.oembed","provider":"World of Books ","version":"1.0","type":"link"}