Two errors that continuously dog developers and dba's alike are ORA-06550 and ORA-06502. These are due to code issues within the PL/SQL that has been developed and a good explanation of the same is available at the locations below.
ORA-06502 :Text: PL/SQL: numeric or value error
Tuesday, September 08, 2009
Wednesday, July 08, 2009
Oracle Introduces Oracle SQL Developer Data Modeler
Oracle's New SQL Developer Data Modeller Enables Data Modeling, Design and Development for Oracle Database, Delivering Comprehensive Capabilities to Ease Data Model Development. Data models are powerful communication aids that are used when initiating projects and consolidating or updating existing projects.
Oracle SQL Developer Data Modeler delivers a spectrum of data and database modeling capabilities spanning:
Visual entity relationship modeling – Supports both Barker and Bachman notations so developers can switch between models to suit the audience’s needs or create and save different visual displays;
Forward engineering ERDs to relational models – Transforms all rules and decisions made at the conceptual level to the relational model, where details are further refined and updated;
Separate relational and physical models – Enables developers to develop a single relational model for different database versions or different databases such as Oracle Database, IBM DB2 V7 and V8 for Linux, UNIX and Windows and OS/390 mainframe, and Microsoft SQL Server 2000 and 2005; and,
Full spectrum of physical database definitions – Supports physical definitions such as partitions, roles, and tablespaces for specific database versions for multi-database, multi-vendor support leading to improved developer consistency and productivity.
The new tool integrates seamlessly with Oracle SQL Developer – Oracle’s popular graphical tool for database development – to let developers open and view previously developed designs as well as query, run and write reports against the reporting repository.
Oracle SQL Developer Data Modeler is available for all editions of Oracle Database 11g and runs on Windows, Linux and Mac OS X. The tool is also available for Oracle Database 10g.
Oracle SQL Developer Data Modeler delivers a spectrum of data and database modeling capabilities spanning:
Visual entity relationship modeling – Supports both Barker and Bachman notations so developers can switch between models to suit the audience’s needs or create and save different visual displays;
Forward engineering ERDs to relational models – Transforms all rules and decisions made at the conceptual level to the relational model, where details are further refined and updated;
Separate relational and physical models – Enables developers to develop a single relational model for different database versions or different databases such as Oracle Database, IBM DB2 V7 and V8 for Linux, UNIX and Windows and OS/390 mainframe, and Microsoft SQL Server 2000 and 2005; and,
Full spectrum of physical database definitions – Supports physical definitions such as partitions, roles, and tablespaces for specific database versions for multi-database, multi-vendor support leading to improved developer consistency and productivity.
The new tool integrates seamlessly with Oracle SQL Developer – Oracle’s popular graphical tool for database development – to let developers open and view previously developed designs as well as query, run and write reports against the reporting repository.
Oracle SQL Developer Data Modeler is available for all editions of Oracle Database 11g and runs on Windows, Linux and Mac OS X. The tool is also available for Oracle Database 10g.
Subscribe to:
Posts (Atom)