Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler is the latest product offering from the Oracle Database Tools group. SQL Developer Data Modeler is an independent, standalone product with a full spectrum of data and database modeling tools and utilities, including modeling for Entity Relationship Diagrams (ERD), Relational (database design), Data Type and Multi-dimensional modeling, full forward and reverse engineering and DDL code generation. The Data Modeler imports from and exports to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of design rules.

Oracle SQL Developer Data Modeler can connect to any supported Oracle Database and is platform independent. A read-only SQL Developer Data Modeler Viewer is also available for download. The viewer allows users to open models created in the Data Modeler.

Click here for Oracle® SQL Developer Data Modeler User's Guide



Oracle® SQL Developer Data Modeler


Note: For download you require free OTN account. If you do not have one, read this for creating one account for you.


For more information visit Oracle website.

Puzzler from Steven Feuerstein (July 2009)

New Puzzler from Steven Feuerstein (July 2009)

TEST YOUR PL/SQL KNOWLEDGE
Which of the following identifiers is the name of the implicit cursor attribute that allows you to find out how many rows were updated by each individual statement processed by the FORALL statement?

• SQL%ROWCOUNT
  
• SQL%FORALL_ROWCOUNT
  
• SQL%BULK_ROWCOUNT
  

To Understand about SQL%BULK_ROWCOUNT click here.

For subscribing to more Puzzlers from Steve and to answer to Steve click here.