Tuesday, April 08, 2008

DB Oracle Database Development and maintenance IDE Tools

DB Oracle Database Development and maintenance IDE Tools:

1. DBORCHESTRA

Features of DBORCHESTRA:

http://www.dborchestra.com/index.php
SQL Tool - Object Browser
Simple point and click interface to your SQL Table, Views, Stored Procedures. Point and click SQL code generation.

SQL Tool - SQL Editor
A versatile SQL query tool with integrated viewer. Auto generate SQL Update, Delete, Insert scripts from a SQL Select.

SQL Tool - Data Export and Import
Execute SQL queries and export data directly to Excel or delimited files. Import data from Excel or delimited files to create new tables or update existing tables.

SQL Tool - Data Comparison and Synchronization
Compare tables and auto build SQL scripts to keep databases in-sync.

SQL Tool - Schema Comparison and Synchronization
Compare SQL schemas to keep databases in-sync across builds or versions.

Othere PL/SQL, SQL and Database Develpment Resources(Oracle, MySQL and SQL Server):

http://www.sqlinfo.net/

Below are the featured examples of SQL Server SQL, Oracle SQL and MySQL SQL.

Data Access / Database Access - SQL Server
SQL Server - SQL Select
SQL Server - SQL Update
SQL Server - SQL Insert
SQL Server - SQL Delete
SQL Server SQL Functions
SQL Server - substring function
SQL Server - Upper and Lower functions
SQL Server - RTRIM and LTRIM functions
SQL Server Stored Procedures
SQL Server - Select stored procedure
SQL Server - Update stored procedure
SQL Server - Insert stored procedure
SQL Server - Delete stored procedure
SQL Server SQL View
SQL Server - Introduction to SQL Views
SQL Server-Creating SQL Tables / SQL Managing Tables
SQL Server - Create SQL Table
SQL Server - Foreign Key Constraint
SQL Server SQL Data Types
SQL Server -Add / Alter SQL Column
SQL Server -Drop SQL Table
Data Access / Database Access - Oracle
Oracle - SQL Select
Oracle - SQL Update
Oracle - SQL Insert
Oracle - SQL Delete
Oracle SQL Functions
Oracle - substring function
Oracle - Upper and Lower functions
Oracle - RTRIM and LTRIM functions
Oracle Stored Procedures
Oracle - Select stored procedure
Oracle - Update stored procedure
Oracle - Insert stored procedure
Oracle - Delete stored procedure
Oracle SQL View
Oracle - Introduction to SQL Views
Oracle - Creating SQL Schema / Managing SQL Schema
Oracle - Create SQL Table
Oracle - Foreign Key Constraint
Oracle SQL Data Types
Oracle - Add / Alter SQL Column
Oracle - Drop SQL Table
Data Access / Database Access - MySQL
MySQL - SQL Select
MySQL - SQL Update
MySQL - SQL Insert
MySQL - SQL Delete
MySQL SQL Functions
MySQL - substring function
MySQL - Upper and Lower functions
MySQL - RTRIM and LTRIM functions
MySQL Stored Procedures
MySQL - Select stored procedure
MySQL - Update stored procedure
MySQL - Insert stored procedure
MySQL - Delete stored procedure
MySQL SQL View
MySQL - Introduction to SQL Views
MySQL - Creating SQL Tables / Managing SQL Tables
MySQL - Create SQL Table
MySQL - Foreign Key Constraint
MySQL SQL Data Types
MySQL - Add / Alter SQL Column
MySQL - Drop SQL Table
MySQL and Java
Simple data access api for MySQL
JDBC driver for MySQL

No comments: