{"product_id":"9781449378769","title":"Oracle PL\/SQL Best Practices: Optimizing Oracle Code","description":"\u003cp\u003eIn this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL\/SQL language, distills his many years of programming, writing, and teaching about PL\/SQL into a set of PL\/SQL language \"best practices\"--rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors--and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues' ability) to maintain that code over time.\u003ci\u003eOracle PL\/SQL Best Practices\u003c\/i\u003e is a concise, easy-to-use reference to Feuerstein's recommendations for excellent PL\/SQL coding. It answers the kinds of questions PL\/SQL developers most frequently ask about their code:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eHow should I format my code?\u003c\/li\u003e\n\u003cli\u003eWhat naming conventions, if any, should I use?\u003c\/li\u003e\n\u003cli\u003eHow can I write my packages so they can be more easily maintained?\u003c\/li\u003e\n\u003cli\u003eWhat is the most efficient way to query information from the database?\u003c\/li\u003e\n\u003cli\u003eHow can I get all the developers on my team to handle errors the same way?\u003c\/li\u003e\n\u003c\/ul\u003eThe book contains 120 best practices, divided by topic area. It's full of advice on the program development process, coding style, writing SQL in PL\/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. It also contains a handy, pull-out quick reference card. As a helpful supplement to the text, code examples demonstrating each of the best practices are available on the O'Reilly web site.\u003ci\u003eOracle PL\/SQL Best Practices\u003c\/i\u003e is intended as a companion to O'Reilly's larger Oracle PL\/SQL books. It's a compact, readable reference that you'll turn to again and again--a book that no serious developer can afford to be without.","brand":"O'Reilly Media, Incorporated","offers":[{"title":"Default Title","offer_id":47128392138992,"sku":"9781449378769","price":10.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781449378769_p0.jpg?v=1763831703","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781449378769","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}