Murach's Oracle SQL and PL/SQL
How to use Oracle SQL Developer and other tools

This chapter presents Oracle SQL Developer, a graphical tool that makes it easy to work with database objects and to build and run SQL statements.
Chapter 2 How to use Oracle SQL Developer and other tools
How to work with an Oracle database 48
How to start and stop the database service 48
How to use the Database Home Page 50
How to use SQL*Plus 52
How to use SQL Developer to work with a database 54
How to create a database connection 54
How to export or import database connections 54
How to navigate through the database objects 56
How to view the column definitions for a table 58
How to view the data for a table 58
How to edit the column definitions 60
How to use SQL Developer to run SQL statements 62
How to enter and execute a SQL statement 62
How to work with the Snippets window 64
How to handle syntax errors 66
How to open and save SQL statements 68
How to enter and execute a SQL script 70
How to use the SQL Reference manual 72
How to view the manual 72
How to look up information 72


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.