Pl Sql Commands

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...

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.


Platforms: Windows, Mac, Linux

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

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

Interbase Express SQL Monitor is a useful application that was designed in order to provide developers with a simple means of profiling and tracking SQL commands. Commands are monitored for program that is connected to remote/local database server through Interbase Express components. It's...


Platforms: Windows

Foxy SQL Free is a database script and query tool designed for DB professionals. It allows you to execute SQL commands and queries against any database. Supported DB: Oracle, MS SQL, IB, DB2, MySQL, PostgreSQL, Firebird, Sybase ASE and more. Key features: access to a lot of different databases,...


Platforms: Windows, Mac

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.


Platforms: ALL

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

SQL Language Module for BBEdit provides syntax coloring of SQL commands in BBEdit.


Platforms: Mac

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

FmPro Worksheet - A free graphical utility for sending SQL commands to FileMaker 7 databases. FmPro Worksheet enables FileMaker 7 database developers to use libraries of SQL commands to speed development of FileMaker 7 solutions. FileMaker 7 developers can utilize all SQL commands supported by...


Platforms: Windows, Mac

The SQLite library includes a small command-line utility SQLite3 that will allow you to manually enter and execute SQL commands against an SQLite3 database. This document provides a brief introduction on how to use sqlite3. To start the SQLite3 program, just type "sqlite3" followed by the name...


Platforms: Windows

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

OleDBCmd allows you to execute SQL commands against an OleDB Database, eg a Microsoft Access database, an Excel spreadsheet, etc. This can be a powerful adjunct to LGX Report (see www.freereporting.com) as it allows database creation to be scripted rather than manually creating a database with...


Platforms: Windows

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

About iSQL-Viewer - Scripting support using JPython and the IBM BSF framework - A guided query builder for creating simple and complex SQL queries - Enhanced object viewing for images, HTML, and other binary format files - A friendly SQL console for executing SQL statements - Batch processing...


Platforms: Mac

doSQL() is a PHP4 script that can dump data back from a SQL text file (generated by backupDB() (also available on this site), phpMyAdmin, or similar) to a new database, or run any number of SQL commands in batch mode. Detailed progress reporting, including time remaing, processing rate (text and...


Platforms: Windows, Mac, *nix, PHP, BSD Solaris

SQLite Full Text Search implements a User Defined Function (UDF) that adds full text search SQL commands to SQLite.This User Defined Function allows to execute a simple full text search queries against the text fields of SQLite database tables.


Platforms: PHP