Home arrow Oracle arrow Page 3 - How to Use the Oracle SQL Developer Tool

Verifying objects in the database - Oracle

Now there is a standalone graphic user interface that you can use to develop your SQL with Oracle databases. The many things you do in Oracle 10G XE can also be carried out with the Oracle SQL Developer. It is expected to enhance productivity in your Oracle applications.

TABLE OF CONTENTS:
  1. How to Use the Oracle SQL Developer Tool
  2. Connecting to databases
  3. Verifying objects in the database
  4. Creating a SQL Query
By: Jayaram Krishnaswamy
Poor Best
Rating: starstarstarstarstar / 40
February 28, 2007

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Expand the Tables node to view all the tables that exist. Expand the NorthEmployees table and you can click any column and modify some of the properties as shown.

You may click on any table to see the data it contains as shown in the next picture.

This way you can see all related Information for the table like the columns, Data, Constraints, etc.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
   

ORACLE ARTICLES

- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator
- Using the IN and BETWEEN Operators on Tables
- Clauses and Logical Operators for Retrieving...
- Limiting Rows When Retrieving Table Data
- Using Scalar Functions for Retrieving Data
- Retrieving Data with String and Arithmatic E...
- Coding the SELECT Statement
- Oracle Releases iPad Virtual Desktop and Exa...
Find More Oracle Articles


© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 7 - Follow our Sitemap

Dev Shed Tutorial Topics: