Search Results for "excel database"

A set of utilities and libraries, enhancing standard system PL/SQL packages in the Oracle Database. Attention!!! we moved to GitHub: https://github.com/oramake/oramake-framework Includes: - a utility for creating, developing and documenting program modules in Oracle DB; - a utility for watching the DB size and tracing Oracle sessions ( put pkg_ProcessMonitor.setSqlTrace() before your code and you then receive an email with 10046 events trace file); - logging feature ( similar to log4j, extending limit of PL/SQL Exception message length to 32K); - easy working with files; - flexibly customized scheduler ( similar to cron); - creating Microsoft Excel xml-files; - sending and receiving email messages ( implementation of smtp and pop3 protocols); - a PL/SQL interface for jdbc access ( existing libraries for accessing MS Sql Server, Sybase, DB2 from Oracle DB); - an interface for accessing Subversion; - a utility for parsing CSV and other text files.

It is a tool to help programmers to check your databases and generate code so easily. Lists the tables and views of databases, MySQL, Oracle and Sybase. Load Data from Excel 97-2003 files, exports the data from the table to Excel 97-2003 file. Generate Stored Procedures from table to insert, update, delete, query and paging. Generates code JSF2.0 (Action) and PrimeFaces (xhtml) from the table, code for Struts 1.3, etc.

DSQL ("Dynamic" SQL) is a scripting language for SQL, aka Perl for JDBC. It allows rapid development of code to perform database programming, data warehousing and import/export from databases, XML, Excel, etc.