The SQL editor will show the database objects in
this section. Open the schema of interest and within that the tables or views
list to see the database objects you can use. Each item in the tree has
different behavior. The action menu presented in the menu bar but also when you
right click the item shows the actions you can perform on that object. You can
drag and drop items into the SQL text area. You can also right click an item and
select an action. You can generate most used SQL statements from this menu.
Typically the database objects list shows the following details:
Schemas
This is the container where all your and other users database objects
reside.
-Schema
Within schemas you find the list of schemas / users. Some database
types can only have one schema so the items will be titled "Current
Schema" From the actions menu can can describe all tables and
views.
--Tables
The tables list shows all tables found in the database. Available
actions: -Select: create a select * statement for all tables in the
list -Create: shows the table creation wizard -Count rows in all
tables -Describe all tables -Sample rows from all tables
--Views
The tables list shows all tables found in the database. Available
actions: -Select: create a select * statement for all tables in the
list -Count rows in all views -Describe all views -Sample rows
from all views
Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
