Oracle Application Express Introduction | Oracle Apex Introduction | Components | Application builder | SQL Workshop | Team Development | Administration

 

Oracle Application Express

• Oracle Application Express is a web-based development and deployment tool that is available with Oracle database. It enables you to create data base- centrist web applications that are reliable, scalable, and secure. It has a number of built-in features and wizards that quicken your development process. Some of the key features are listed in the slide.
•  The tool has a user-friendly graphical interface. Using Oracle Application Express requires minimal programming knowledge.
•  The application definition is stored as metadata in the Oracle database tables. When you run your application, the Oracle Application Express engine assembles the pages from the database and displays them in your browser.
•  Oracle Application Express was first released in 2004 and was then called HTML DB.

 

Oracle Application Express Components:

 

The Oracle Application Express development environment consists of four components:

1. Application builder
2. SQL Work shop 
3. Team Development
4. Administration

 

1. Application builder: Is used to create the user interface of an application. You can

create application pages and use the built-in features to add reports, forms, charts,

calendars, and so on to an application. You can specify the database objects that the

application should interact with. Using the application builder, you can build database

applications and web sheet applications. You learn to create a database application in

the lesson titled “Building a Database Application,” and how to create a web sheet

application in the lesson titled “Building a Web sheet Application.

      2. SQL Work shop:

SQL Workshop is used to create and manage the database objects of an application.

You can browse the objects in your application schema. You can create database

objects such as tables, views, sequences, and so on. You can execute SQL commands

and run SQL scripts. You learn to use the SQL Workshop in the lesson titled “Interacting

with the Database by Using SQL Workshop.”

SQL Workshop is a tool in Application Express that you use to interact with the database objects. You can create, view, and edit database objects. You can also perform tasks such as loading and unloading data to and from database tables, generating data definition language (DDL) statements, and viewing reports.

The four main components of SQL Workshop are displayed in the slide: Object Browser, SQL.

Commands, SQL Scripts, and Utilities. You learn to use each of these components in this lesson.

• Object Browser: View, create, and modify objects.

• SQL Commands:

·         Run SQL statements to create, view, and edit objects.

·         Run PL/SQL code.

·         Save queries.

• SQL Scripts:

·         Run SQL scripts to create, view, and edit objects.

·         Run PL/SQL code.

·         Upload and save queries to a repository.

·         Transfer scripts to another workspace.

• Utilities: Create queries, load and unload data, and generate DLL statements.

 

Accessing SQL Workshop:

 

From the Oracle Application Express home page, you can access the SQL Workshop tool in two ways:

·         Click the SQL Workshop icon or the SQL Workshop tab, and then select the component that you want to access.

·         Click the down arrow on the SQL Workshop tab, and then select the component that you want to access from the drop-down menu 6.

 

Navigating in SQL Workshop:

 

·         From within any SQL Workshop component, if you want to go back to the SQL Workshop page, click the SQL Workshop tab or the SQL Workshop breadcrumb.

·         To navigate to a different SQL Workshop component, click the down arrow on the SQL Workshop tab and select the component that you want to access. You can also navigate to the component that you want to access by clicking the component’s icon from the Quick Links toolbar.

·         The schemas for your workspace are listed in the Schema drop-down list. You can change the schema for the current component by clicking the drop-down list and selecting a different schema.

 

To access Object Browser, click the Object Browser icon on the SQL Workshop page. You

can also select Object Browser from the drop-down menu on the SQL Workshop tab.

 

The Object Browser page consists of two areas:

•  Object Selection pane
  
•  Detail pane

•  Object Selection pane: You use this pane to select the database object that you want

to view. The objects are listed by type. You can use the object list to change the type of

objects listed. If any object has a red bar next to it in the Object Selection pane, it is

invalid.

•  Detail pane: This pane provides additional detailed information about the database

object that you selected in the Object Selection pane. You can click the tabs to view

information such as data, indexes, and constraints. This pane also contains many

manipulation options for the database object. You can click the appropriate button to edit

the object.

In addition to viewing database objects, you can create database objects by clicking the

Create button in Object Browser. You can also click the drop-down arrow on the create

button to select the type of object that you want to create.

3. Team Development: 

Team Development is Provides a development management tool that enables you to track new features, bugs, milestones, to-do tasks, and feedback.

4. Administration: 

 Administration is used to manage workspace users and services.