pl sql

Tidycode Pl Sql Formatter 2.5.0
This software allows you to tidy, beautify or format your Pl/Sql code in a batch file or Dos prompt. In other words, it is a command line tool that can be built in your programming environment. It can be used in most free or commercial editors/IDEs. It also contains a tool Experimenter which? more>> <<less
License:Demo
License:Trial
ClearSQL 2.1.3
A powerful tool for quick syntax checking and formatting PL/SQL code more>>
ClearSQL allows you to pre-process your PL/SQL source code so you can write some code that needs to be portable across multiple Oracle Server versions or maintain a module that is being used for different clients.
ClearSQL is a powerful and flexible tool for formatting PL/SQL code. It beautifies code, adds readability to it by consistent indentation. The artfully built visual layout of your code will reveal and reinforce the logical structure of your program, clearly showing its structure and intent.
License:Shareware
PL/SQL Developer 7.1.5
Handle PL/SQL program units with this integrated development environment. more>>
PL/SQL Developer 7.1.5 provides users with an integrated development environment for developing, testing, debugging, and optimizing Oracle PL/SQL stored-program units such as packages, triggers, and so on. The program features context-sensitive help and database-object descriptions. Also included is a full-featured integrated debugger, a multi-session/multi-threaded environment, a code assistant, a template library, a macro library, and a command window.
Previous versions added integration with Oracle HTML manuals; Synonyms, Users, Roles, and Object Privileges in the Object Browser; and user-defined shortcut keys for all functions. Other previous improvements include the Code Navigator with Code Contents, Hyperlink Navigation and Browse buttons, the Table and Sequence definition editors, conditional break points, version-control integration, enhanced template functionality, enhanced SQLPlus compatibility for the Command window, and more.
This update includes a new Project concept, HTML Reports, Export & Compare User Objects tools, XML support, Query Export in CSV, TSV, XML, and HTML format, substitution variables, HTP output, PL/SQL Trace, and more.
Oraspeed SQL Editor 3.8.0
Using this Oracle IDE you can write and test Queries. Create, Compile, Execute and Debug your PL/SQL Programs. Execute Anonymous PL/SQL Blocks. Create/Edit Database object using advanced wizards. TKProf, PL/SQL Profiler, Parent Child Tables Data Explorer, Built-in reports, BLOB Editor, Oraspeed Security Module, Multithreading and much more. This database tool can improve your productivity multifold. more>>
Oraspeed SQL Editor 3.8.0 functions as an application for writing and testing Queries. Create, Compile, Execute and Debug your PL/SQL Programs. Execute Anonymous PL/SQL Blocks. Create/Edit Database object using advanced wizards. TKProf, PL/SQL Profiler, Parent Child Tables Data Explorer,Built-in reports, BLOB Editor, Session Manager,Oraspeed Security Module, Multitthreading, File Auto Recover and much more
Major Features:
- Improve your productivity multifold regardless of whether you are a Programmer or Application Developer or Business Analyst or DBA.
- Have features like SQL Editor, PLSQL Editor, PLSQL Profiler, PLSQL Debugger, TKProf saving your time.
- Include easy to use Oracle debugger.
- Have handy SQLNet.ora Editor and TNSNames.ora Editor.
- Have Advanced Templates module helping maintain your project standards using Oraspeed.
- Writing SQL or PL/SQL is so easy with features like Intellisense, Programmable keys, Syntax Highlighting, Declared Variables List, Oracle functions List, Schemas(Users) List, Objects List and much much more.
Enhancements: Minor bug fixes
Requirements: none
Create, Compile, Execute and Debug your PL/SQL Programs. Execute Anonymous PL/SQL Blocks. Create/Edit Database object using advanced wizards. Oraspeed SQL Editor 3.6.5 - Zenopsys TechnologiesLicense:Trial
License:shareware
Oraspeed - Create, Compile, Execute and Debug your PL/SQL Programs. Execute Anonymous PL/SQL Blocks. Create/Edit Database object using advanced wizards. TKPr. OraspeedLicense:Shareware
AlligatorSQL 1.12
AlligatorSQL the debugging IDE for RDBMS. more>> This product offers a simple way to manage stored objects in an Oracle 8i, MySql, Interbase, Birdstep RDM server and PostgreSQL database. With simple clicks you can create, modify or drop objects in the databases. No knowledge about special DDL is needed. The mutlithreaded browser lets you navigate through your datas quick and easy. The integrated profiler provides you analysing your PL/SQL Code. The debugger lets you debug your PL/SQL sourcecode simple and efficient..<<less
is needed.Version 1.0The integrated Profiler provides you analysing your PL/SQL Code. The PL/SQL to C Converter will raise the speed of your PL/SQL Code up to 100 times faster.The Debugger letsLicense:Shareware

Oraspeed - SQL Editor 2.8.4
Using this Oracle IDE you can write and test Queries. Create, Compile, Execute and Debug your PL/SQL Programs. Execute Anonymous PL/SQL Blocks. Create/Edit Database object using advanced wizards. TKPr more>>
This database tool can improve your productivity multifold regardless of whether you are a Programmer or Application Developer or Business Analyst or DBA. Features like SQL Editor, PLSQL Editor, PLSQL Profiler, PLSQL Debugger, TKProf will save your time. Oracle debugger is so easy to use. SQLNet.ora Editor and TNSNames.ora Editor can be very handy. Writing SQL or PL/SQL is so easy with features like Intellisense, Programmable keys, Syntax Highlighting, Declared Variables List, Oracle functions List, Schemas(Users) List, Objects List and much much more.

Introduction to Oracle: SQL and PL/SQL 8.00.05
Prepare for the Introduction to Oracle SQL and PS/SQL (1Z0-001) certification exam. more>> <<less

Tidycode Pl/Sql Formatter 2.4.0
This software formats Pl/Sql programs in a Dos prompt or in a GUI. more>>
In other words, it is a command line tool that can be built in your programming environment. You can use this software in most free or commercial editors/IDEs.
It also contains a tool Experimenter which provides an alternative user interface to the formatter. In this way, the command line switches of the formatter can be tried out/determined quickly and easily.
Main features:
- indents Pl/Sql depending on block level
- quantity of indent can be specified for each block level independently
- uppercase, lowercase or capitalized keywords/identifiers
- Sql formatting options
- indention with spaces or tabs or tabs and spaces
- clipboard can be used as a source and destination of the formatting
- slightly compact code (removal of redundant space)
- very compact code (all padding spaces are removed e.g. around operations +-)
- formats lists in brackets
- aligns assignments vertically
- simple syntax checking
- handles sqlplus scripts as well
- backs up original code and keeps old versions of code
Version restrictions:
- 30-day trial period
License:Shareware
SQL Designer 1.3
executes, tests and debugs SQL and PL/SQL statements . more>>
1Z0-147 Oracle DBA9i PL/SQL 8.03.05
Pass 1Z0-147 for OCP DBA9i PL/SQL certificati more>> PrepKit OCP DBA9i PL/SQL 1Z0-147, Oracle9i: Program with PL/SQL is an interactive software application that helps you learn, tracks your progress, identifies areas for improvements and simulates the actual exam. This PrepKit contains 3 interactive practice tests with over 280 challenging questions guaranteed to comprehensively cover all the objectives for the 1Z0-147: Oracle DBA9i PL/SQL exam. With detailed analysis for each question, over 94 study notes, interactive quizzes, tips and technical articles, this PrepKit ensures that you get a solid grasp of core technical concepts to ace your certification exam. Our PrepKits help you get certified. You save both, time and money. As a matter of fact, we do better than that. Each PrepKit is backed by money back guarantee. So, if you dont get certified in the first attempt, we will return your money..<<less
dbXpert 8
dbXpert for Oracle is an easy to use database development and administration tool for Oracle database. It helps developers and DBAs get the job done quickly and efficiently.Features: SQL Workspace; PL/SQL Debugger; Object Browser; Procedure Builder; Query Builder; Top Session Browser; Performance Monitor; Data Export/Import and other DBA tools. more>>
dbXpert - Major Enhancements:
Multi-Tabbed SQL Workspaces with Separated Resultsets,
Multi-SQL Statements and Separated Resultsets
Direct Edit of LOB, Nested Table, or Object
Output Bind Variable support LOB and PL/SQL Cursor
Multiple Split Views
Automatric Brace Match Highlight
Column Selection and Manipulation
Regular Expression Searching
SmarTab
Enhanced Editor Properties Setting
etc.
dbXpert for Oracle is an easy to use database development and administration tool for Oracle database. It helps developers and database administrators get the job done quickly and efficiently.
SQL Workspace
Object Browser
Data Browser
PL/SQL Debugger
Query Builder
Instance Performance Dashboard
Recycle Bin for Flashback Table (Oracle 10g)
Database Administration Tools ...
Enhancements:
Version 8
more features, performance improved
System Requirements:Oracle SQL*Net<<less

Oracle Reports Barcode PLL with PL/SQL S 1.2
Add barcodes to Oracle Reports more>> Add barcodes to Oracle Reports with this library. The barcode library is a PLL file of subprograms that format data from fields in the report to barcode fonts. It works cross-platform on Windows, Linux and Unix. Code 128, GS1-128, Postnet, Planet, Interleaved 2 of 5, ITF, UPC-A, EAN-13, and EAN-8 are supported. The bar-code library is royalty-free when used with one of our barcode fonts<<less

SwisSQL - SQL Server to Oracle Migration Tool 3.5
Automated migration tool to convert SQL Server Transact SQL to Oracle PL/SQL more>> <<less
License:Shareware
License:shareware

uCertify OCP DBA9i PL/SQL - 01Z0-001 Exam 8.01.05
uCertify OCP DBA9i PL/SQL - 01Z0-001 Exam is a program showing you how to learn, manage your progress, identify areas for enhancing the actual exam. more>> <<less

uCertify OCP DBA9i PL/SQL - 1Z0-007 8.03.05
PrepKit OCP DBA9i PL/SQL 1Z0-007, Introduction to Oracle9i: SQL is an interactive software application that helps you learn, tracks your progress, identifies areas for improvements and more>>
This PrepKit contains 3 interactive practice tests with over 280 challenging questions guaranteed to comprehensively cover all the objectives for the 1Z0-007: Oracle OCP DBA9i Introduction to SQL exam.
With detailed analysis for each question, over 105 study notes, interactive quizzes, tips and technical articles, this PrepKit ensures that you get a solid grasp of core technical concepts to ace your certification exam.
Major Features:
- This test is appropriate for you if you have experience in Oracle Databases and want to work as a Database Administrator (DBA). This test is suitable for you if you are a medium to advanced level database administrator.
- The Introduction to Oracle9i: SQL test 1Z0-007 validates your skills and knowledge in the field of Oracle Database technology. It tests your skills that include Writing Basic SQL Select Statements, Manipulating Data, Creating and Managing Tables and Creating Other Database Objects.
- This test consists of multiple-choice questions. There are no case study type questions and the test is not adaptive. You will be required to attempt approximately 52 questions in 120 minutes. To pass, you need a score of 71%.

