- Wells, Rosemary
- Neuro-Linguistic Programming
- S
- New Mexico
- Casper, Susan
- Ford, Richard
- Precision Instruments
- Ukraine
- Gay & Lesbian
- Moran, Daniel Keys
- Biblical
- Bridge
- Oceania
- Methodology
- Secondary
- Brookmyre, Christopher
- Pearce, Philippa
- Dewar, Isla
- Wales
- Tolkien
- Food & Farming
- Software Testing
- Learning Materials
- Beatrix Potter
- Reproduction
- Inter-war Period 1919-1938
- General AAS
- SSL & OpenSSL
- General AAS
- Company
- Some of our other sites:
- Books
- Clothing, Shoes and Accessories
- Baby Clothes and Accessories
- Cosmetics, Beauty Products and Fragrances
- Cellphones, Call Plans and Accessories
- Video Games
- DVDs
- Electronics, Gadgets and Computers
- Health and Personal Care
- Home and Garden
- Home DIY
- Jewelry
- Magazines and Newspapers
- Music Downloads
- Musical Instruments
- Office Equipment and Supplies
- Software and Games
- Sporting Goods
- Toys and Games
- Watches
- UK Books
- UK Video Games
- UK Home and Garden
- UK Electronics, Gadgets and Computers
- UK Baby Clothes and Accessories
- UK Software and Games
- UK Sporting Goods
- UK Toys and Games
Books : Computing & Internet : Software & Graphics : Business & Home Office : Home Office Databases : Databases : Oracle : PL & SQL
-
-
-
-
-
Steven Feuerstein has condensed years of accumulated wisdom and experience into a series of some 120 Oracle PL/SQL Best Practices, these being hints and tips covering a range of topics, all aimed at producing readable and maintainable PL/SQL code, particularly in the context of working in a PL/SQL development team.
While many of the principles involved could apply equally to any structured programming language, Feuerstein addresses the challenges of applying these principles in the PL/SQL programming environment and backs this up with simple code examples.
Some of these best practices are more important that others however Feuerstein identifies the benefits and importance of each best practice and has separately listed the more important (no. 1: "establish and follow clear rules for how to write SQL in your application"--followed by guidelines on how to achieve this).
While this book will probably be of most benefit to the programmer new to PL/SQL, it still contains programming tips and tricks likely to be of use to the experienced PL/SQL programmer too. --Michael O'Connor
-
-
-
-
-
-
-
-
This small slim volume is a concise guide to using Oracle's SQL*Plus tool which acts as a front-end to the SQL querying language. Oracle SQL*Plus Pocket Reference does not attempt to teach you how to use the language but provides a quick reference to the commands available and the ways in which they can be pressed into service.
It's terse but informative, as befits a pocket guide, and so small that the usually entertaining O'Reilly colophon is omitted--which is a shame. The first half covers basic interactions such as string handling and naming variables, moving on to deal with selecting data, formatting reports and tuning SQL statements plus a section on formatting elements that let you do almost anything with number and date displays, including showing dates with a BC or AD indicator. In the tuning section there is brief coverage of execution plans for SQL statements and of how to tune the Oracle optimiser that puts those plans into operation. The second half forms the SQL command reference section, everything from ACCEPT to WHENEVER.
This eminently pocketable reference book would be invaluable for jogging the memory in those odd moments of blankness-- and it's almost palmable if you're shy about admitting fallibility. --Mark Whitehorn
-
-
-
-
-
-
Oracle SQL*Loader: The Definitive Guide certainly lives up to the promise of its title. What this book doesn't tell you about Oracle's high performance data loading utility is unlikely to be found elsewhere--from the possible permutations of command line syntax and options to the fine detail of what each option means.
This book serves both as an introduction to SQL*Loader and as an in-depth reference to its use and behaviour. Having said that, it's perhaps debatable whether the relatively straightforward SQL*Loader merits the treatment it receives here and it's likely that the single chapter coverage in the Oracle Utilities manual, or any number of Oracle DBA reference books, will suffice for the average or occasional SQL*Loader user.
However, it will be a useful addition to the bookshelf of the regular SQL*Loader user, or for those where getting the most out of SQL*Loader is an issue. --Michael O'Connor
-





















