TOAD Pocket Reference for Oracle (Pocket Reference (O'Reilly))

by PatrickMcGrath (Author), JimMcDaniel (Author)

• Used

  Paperback
  2002

  $9.81

  The Tool for Oracle Application Developers (TOAD) is a popular graphical user interface for the Oracle database that allows programmers to build, test, debug, an format their code within an interactive development environment. With the easy-to-use TOAD interface, changes that once took hours can be done in just minutes. TOAD allows developers to browse their database tables, procedures and object types, use code templates, and shows errors. It also simplifies database administration by providing a way for DBAs to graphically browse and change database characteristics. For many Oracle users, only a lack of documentation prevents them from using TOAD to be as effective and productive as possible. As the only printed documentation for TOAD, the TOAD for Oracle Pocket Reference supplies much needed coverage of TOAD's many features and options. The book offers database developers and administrators with quick access to TOAD feature summaries, hot keys, productivity tips and tricks, and much more. The book covers: an introduction to TOAD and its main program functions; Schema Browser: quickly navigate and manage database objects (tables, privileges, etc.) , even those in multiple data bases; SQL Editor and Data Grid: edit and run SQL using hot keys, custom code templates, auto-correct, and type-ahead features; quickly find and fix syntax errors; tune SQL as it's being built; perform auto-trace and conversion functions; procedure editor and debugger: work on multiple files in parallel using version control, debug files, etc. DBA Module: compare and synchronize database schemas, manage space, administer security, import/export data, tune databases, etc. This reference should help Oracle programmers and DBAs realize the full power of their favourite productivity tool.