Pl Sql Powered

Here's a slick way to display table Selects in your PL/SQL via DBMS_OUTPUT without using any INTO variables.

In the Oracle database there are two PL/SQL APIs to send mails: UTL_SMTP and UTL_MAIL. But there is no package which is able to retrieve messages from a mailbox on a server. The here provided package MAIL_CLIENT closes this gap.

The Log & Dbug Library is an open source PL/SQL library, useful to log/debug your programs in the development phase and trace their activity and performances in production. It is ideal to improve your efficiency and code quality.


Platforms: Windows, Mac, Linux

Oracle PL/SQL executing OS Commands project contains the PL/SQL packages OS_COMMAND, FILE_TYPE and FILE_PKG which enable an Oracle database developer to interact with the operating system or with ordinary files. Oracle provides out-of-the-box only limited functionality for accessing the file...


Platforms: *nix

OraRep is a PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance, providing you with an overview on your instance(s), some hints for performance tuning, and more. It has been tested with Oracle 8.1.7, 9.0.1, and 9.2. The script...


Platforms: *nix

OraTau PLD Plug-in is Allround Automations PL/SQL Developer plugin. The plugin aims to higher simplification and increase of productivity and comfort while working with RDBMS Oracle via PL/SQL Developer. Give OraTau PLD a try to fully assess its capabilities! for WindowsAll


Platforms: Windows

SwisSQL - Oracle to SQL Server Edition is an Automated Migration tool to convert Oracle PL/SQL stored procedures into equivalent Microsoft SQL Server Transact SQL code. It automates more than 90% of the Oracle PL/SQL code conversion into Transact SQL with very minimal manual intervention. SwisSQL...


Platforms: Windows

PL/JSON is a generic JSON object written in PL/SQL. Using PL/SQL object syntax, users instantiate a JSON objects and then add members, arrays and additional JSON objects. This object type can store JSON data, in Oracle, persistently.


Platforms: Windows, Mac, Linux

MuSQL is designed to simultaneously execute your SQL queries, DML statements, PL/SQL blocks, and entire SQL*Plus scripts in multiple Oracle databases quickly and effortlessly. Take MuSQL for a test drive to see what it's really capable of!


Platforms: Windows, XP, 2003, Windows Vista

dbForge Studio for Oracle Express is a free software that provides basic functionality for working with schema objects, user accounts, SQL scripts, and queries. - PL SQL editor with syntax highlight, bookmarks, and text search - Visual editors for schema objects - Object Viewer window - Security...


Platforms: Windows

TOAD® empowers developers and DBAs to be more productive by providing an intuitive graphical user interface to Oracle. TOAD is a powerful, low-overhead tool that makes PL/SQL development faster and easier and simplifies database administration tasks. Advanced editors allow users to work on...


Platforms: Windows

DreamCoder for Oracle Free Edition is a free powerful Integrated Development Environment (IDE) and administration tool for Oracle Databases. With the intuitive DreamCoder's GUI increase your code quality and reduce the development process time. DreamCoder for Oracle you will easily be able...


Platforms: Windows

Alchemist's best-in-class features for working with XML, XSL, XSLT, XPath, SQL/XML, code generation, database to XML mapping and many other XML technologies. Alchemist is a product that provides the necessary infrastructure to build pieces of reusable software or aplications. The product is...


Platforms: Windows

SQLite + SP is a specially developed extension for SQLite that allows you to create your own functions in PL/SQL. Now you can make ue of this handy and accessible extensions to create the functions you need in no time at all.


Platforms: Windows

DreamCoder for Oracle Enterprise Freeware is a comprehensive tool for developing and managing an Oracle database. This product increases the productivity and quality of development teams and database administrators. In DreamCoder for Oracle you will find different tools and modules to manage and...


Platforms: Windows

Catnap is a lightweight Java persistence layer which stores and retrieves objects from an Oracle database using PL/SQL packages.


Platforms: Windows, Mac, Linux

This software provides PL/SQL packages for defining and measuring business tasks utilizing Oracle's extended SQL tracing mechanism.


Platforms: Windows, Mac, Linux

PL/SQL packages to perform Oracle 11g tasks within a very few number of lines : dump/load LOBs, compute CRC, get Mime Type from a BLOB, send XMPP messages, list directory contents as a table, interact with Twitter,deal with QrCodes, ...


Platforms: Windows, Mac, Linux

Creates really cool and useful hypermaps from SQL database schema, consists of a small PL/SQL metadata extractor and a Python (or C) postprocessor file.


Platforms: Windows, Mac, Linux

Generates syntax highlighted HTML for almost all (including ASP,Aspect-J,AWK,C++,C#,COBOL,CSS,FreeMarker,Groovy,HTML,INI,Java,JavaScript,JSP,Makefile,Pascal,Perl,PHP,PL-SQL,Properties,Python,RTF,Smalltalk,TeX,VBScript,Velocity,XML,XSL) languages.


Platforms: Windows, Mac, Linux