32.web Based Data Retrieval & Manipulation
32.web Based Data Retrieval & Manipulation
ABSTRACT
Web Based Data Retrieval & Manipulation is an industry-standard tool for application
development. Using Web Based Data Retrieval & Manipulation , developers can interact with
any back end software (i.e. Oracle, MS-SQL Server, MS-Access, My-SQL etc). The Web Based
Data Retrieval & Manipulation can be used to build, test, and debug PL/SQL packages,
procedures, triggers, and functions. Web Based Data Retrieval & Manipulation users can create
and edit database objects such as tables, views, indexes, constraints, and users. Web Based Data
Retrieval & Manipulation 's SQL Editor provides an easy and efficient way to write and test
scripts and queries, and its powerful data grids provide an easy way to view and edit data related
to any DBMS/RDBMS tool.
The requirements of a database application developer will vary from project to project. On a
large team where DBAs manage the DDL, a developer may spend 90% of development time
coding and testing SELECT queries to issue from 3GL or 4GL application code. In such an
environment, a developer might be concerned only with viewing the DDL and database code. On
smaller teams, a developer might be responsible for maintenance of the development schema,
movement of test data between schemas, writing procedure code, populating tables from legacy
sources, and more. Web Based Data Retrieval & Manipulation facilitates all of these needs.
For example if you are working with oracle, you don't have to be a PL/SQL expert to access
database objects with Web Based Data Retrieval & Manipulation . You can view the Oracle
Dictionary, tables, indexes, stored procedures, and more - all through a multi-tabbed browser.
Web Based Data Retrieval & Manipulation utilizes direct Oracle OCI calls for full access to the
Oracle API.
Advanced editing features save time and increase productivity. Code can be created from
shortcuts and code templates. You can even create your own code templates.
Create, browse, or alter objects (tables, views, indexes, etc.) including Oracle8 TYPE
objects
Graphically build, execute, and tune queries
Edit and Debug PL/SQL and profile "stored procedures" including functions, packages,
& Manipulationnn:
Web Based Data Retrieval & Manipulationnn:
and triggers
Search for objects
Find and fix database problems with constraints, triggers, extents, indexes, and grants
System Requirement Specification:
Hardware Requirements:
& Manipulationnn: