Cargando…
Oracle SQL Developer 2.1.
Design and Develop Databases using Oracle SQL Developer and its feature-rich, powerful user-extensible interface with this book and eBook.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2009.
|
| Colección: | From technologies to solutions
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Oracle SQL Developer 2.1; Oracle SQL Developer 2.1; Credits; About the Author; Acknowledgement; About the Reviewers; Preface; What this book covers; I: Getting started; II: Delving a little deeper; III: Focus areas; Standards and assumptions; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 1. Getting Started with SQL Developer; Preparing your environment; Finding and downloading the software; Downloading and installing the Java Development Kit; Installing and starting SQL Developer; Working with different platforms; Microsoft Windows.
- Alternative platformsMac OS X; Linux; Migrating settings from a previous release; Maintaining your environment; Verifying the current release; Using Check for Updates; Managing the system folder and other files; Sharing preferences; Alternative installations of SQL Developer; Oracle JDeveloper; Oracle Database 11g; Troubleshooting; Removing extensions; Resetting shortcut keys; Reset the environment, do not reinstall the product; A quick overview; Sample schemas; Creating your first connection; Using basic commands in the SQL Worksheet; Browsing and updating data; Running reports.
- Navigating around SQL DeveloperManaging SQL Developer windows; Tiling windows; Splitting documents; Maximizing detail; Resetting the window layout; Finding more help; Summary; 2. Browsing and Editing Database Objects and Data; Browsing objects; Working with the Connections navigator; Opening connections; Working with objects; Filtering objects; Schema level filtering; Display editors; General display editors; Working with the display editors; Using the SQL display editor; Working with the data grids; Controlling the column display; Sorting the data; Filtering columns.
- More data grid context menusHighlighting data; Count Rows and the Single Record View; Save Grid as Report; Working with Updating Data Grids; Sorting and filtering data; Updating data; Working with LOBS in the data grid; Using flashback; Reviewing other database object nodes; Working with PL/SQL objects; Accessing objects you don't own; Other users; Synonyms and filters; Recycle Bin; Creating and updating database objects; Creating new objects; Creating tables; Early decisions; Adding constraints; Creating column sequences; Additional properties; Storage; Partitions; Creating views.
- Writing the SQL queryUsing the Quick-pick objects; Building the query using elements in the tree; Reviewing a few specific objects; Creating new users; Setting the privilege to create new objects; Editing objects: Putting context menus to work; Editing objects; Diving into context menus; Using context menus as utilities; Normalizing data; Triggers and sequences; Summary; 3. Working with the SQL Worksheet; Introducing the SQL Worksheet; Controlling the environment; Opening SQL Worksheets; Working with multiple worksheets; Switching connections; Getting started; Writing and executing commands.