-
Book Overview & Buying
-
Table Of Contents
Oracle SQL Developer 2.1
By :
The SQL Worksheet is an independent working environment in SQL Developer that you can use to interact with the database, much as you would using a command line or SQL*Plus. Before we look at the features in the worksheet, we'll look at the worksheet environment, how to invoke it, and the preferences that control it.
It is important to be aware of the user that is connected to the database. In SQL*Plus, if you are connected as one user and want to query details for another user, you might:
Open a new SQL*Plus connection
Change the currently connected user
Query details in another schema by prefixing the object names with the new schema name (for example, while connected as OE, query an HR table using SELECT * FROM HR.EMPLOYEES;)
These alternatives are also true for the SQL Developer SQL Worksheet. By 'independent' we mean that objects created in the worksheet are not automatically reflected in the Connections navigator. If you execute a DDL command to create a...
Change the font size
Change margin width
Change background colour