skip to content
Oracle SQL Developer 2.1. Preview this item
ClosePreview this item
Checking...

Oracle SQL Developer 2.1.

Author: Sue Harper
Publisher: Birmingham : Packt Pub., 2009.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
Design and Develop Databases using Oracle SQL Developer and its feature-rich, powerful user-extensible interface with this book and eBook.
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Software
Additional Physical Format: Print version:
Harper, Sue.
Oracle SQL Developer 2.1.
Birmingham : Packt Publishing, ©2009
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Sue Harper
ISBN: 9781847196279 1847196276
OCLC Number: 797916763
Notes: Writing your first statements.
Description: 1 online resource (694 pages)
Contents: 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.

Abstract:

Design and Develop Databases using Oracle SQL Developer and its feature-rich, powerful user-extensible interface with this book and eBook.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/797916763> # Oracle SQL Developer 2.1.
    a schema:Book, schema:CreativeWork, schema:MediaObject ;
    library:oclcnum "797916763" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/429571633#Place/birmingham> ; # Birmingham
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
    schema:about <http://id.worldcat.org/fast/1363816> ; # Oracle (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/429571633#Topic/database_design> ; # Database design
    schema:about <http://dewey.info/class/005.75/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/429571633#Topic/sql_computer_program_language> ; # SQL (Computer program language)
    schema:about <http://experiment.worldcat.org/entity/work/data/429571633#CreativeWork/oracle_computer_file> ; # Oracle (Computer file)
    schema:bookFormat schema:EBook ;
    schema:creator <http://viaf.org/viaf/29648637> ; # Sue Harper
    schema:datePublished "2009" ;
    schema:description "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."@en ;
    schema:description "Design and Develop Databases using Oracle SQL Developer and its feature-rich, powerful user-extensible interface with this book and eBook."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/429571633> ;
    schema:genre "Software"@en ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/429571633#CreativeWork/oracle_sql_developer_2_1> ;
    schema:name "Oracle SQL Developer 2.1."@en ;
    schema:productID "797916763" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/797916763#PublicationEvent/birmingham_packt_pub_2009> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/429571633#Agent/packt_pub> ; # Packt Pub.
    schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=946924> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=946924> ;
    schema:workExample <http://worldcat.org/isbn/9781847196279> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/797916763> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/429571633#CreativeWork/oracle_computer_file> # Oracle (Computer file)
    a schema:CreativeWork ;
    schema:name "Oracle (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/429571633#Topic/sql_computer_program_language> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://id.worldcat.org/fast/1363816> # Oracle (Computer file)
    a schema:CreativeWork ;
    schema:name "Oracle (Computer file)" ;
    .

<http://viaf.org/viaf/29648637> # Sue Harper
    a schema:Person ;
    schema:familyName "Harper" ;
    schema:givenName "Sue" ;
    schema:name "Sue Harper" ;
    .

<http://worldcat.org/entity/work/data/429571633#CreativeWork/oracle_sql_developer_2_1>
    a schema:CreativeWork ;
    rdfs:label "Oracle SQL Developer 2.1." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/797916763> ; # Oracle SQL Developer 2.1.
    .

<http://worldcat.org/isbn/9781847196279>
    a schema:ProductModel ;
    schema:isbn "1847196276" ;
    schema:isbn "9781847196279" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.