How To Open Oracle 10g After Installation

Creating an Awarding Using Oracle Database 10g Express Edition

This tutorial shows yous how to create an application using Oracle Database 10grand Limited Edition (XE).

Approximately 30 minutes

This tutorial covers the post-obit topics:

	Overview
	Prerequisites
	Saving SQL for Use in Applications
	Creating a Report Drill Downwardly
	Calculation a Tabular Form
	Editing Application Objects
	Applying a New Theme
	Summary
	Larn More

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This activity loads all screenshots simultaneously, so response fourth dimension may be slow depending on your Internet connection.)

Note: Alternatively, yous can identify the cursor over an individual icon in the following steps to load and view only the screenshot associated with that footstep. You can hide an individual screenshot by clicking information technology.

Oracle Application Express is installed in Oracle Database 10g Limited Edition every bit the principal tool for managing the database and building Web-based applications.  Oracle Application Express is a rapid web application development tool for the Oracle database.  Using just a web browser and limited programming experience, you can develop professional applications that are both fast and secure.  The deployed applications crave only a browser and admission to an Oracle database running Application Express.

Back to Topic Listing

Before you perform this tutorial, you should:

1.	Download and install Oracle Database 10g Express Edition from OTN.
2.	Open a SQL*Plus window and login as SYS or SYSTEM. Execute the following argument: alter user hr identified by hour account unlock;

Back to Topic List

In this topic, y'all create a query that joins three tables using the Query Architect. Perform the following steps:

i.	Select Showtime > Programs > Oracle Database 10g Limited Edition > Become to Database Domicile Page.
2.	To log in to XE, enter the following details, and click Login. Username: hour Countersign: hr
3.	To create your query, click the down arrow next to SQL > Query Architect and then select Create.
four.	Select Departments.
5.	Select Locations.
half-dozen.	Select Countries.
7.	You need to create a bring together betwixt the tables so that yous can query the data. Select DEPARTMENTS.LOCATION_ID.
8.	With the column selected, elevate and drib your mouse on the LOCATIONS.LOCATION_ID column.
9.	A line that joins DEPARTMENTS and LOCATIONS is displayed. At present you want to create another join between LOCATIONS and COUNTRIES. Select LOCATIONS.COUNTRY_ID and elevate information technology to COUNTRIES.COUNTRY_ID.
10.	The join is created betwixt LOCATIONS and COUNTRIES. Now y'all select the columns you want to select when the query is run. Select the checkboxes in forepart of each of the post-obit columns and and so click Run. DEPARTMENTS.DEPARTMENT_ID DEPARTMENTS.DEPARTMENT_NAME LOCATIONS.Urban center LOCATIONS.STATE_PROVINCE COUNTRIES.COUNTRY_NAME
11.	The results are shown. Yous want to save this query so yous can utilise it in your application later in this tutorial. Click Relieve.
12.	Enter Section Locations for the name and click Save.
13.	The query is now saved. Click Domicile to return to the XE Home Page.

Back to Topic List

Now yous can create an Application using Awarding Builder that contains ii reports and a form. Perform the following steps:

1.	From the XE Dwelling house page, click the down pointer next to Application Builder > Create Awarding and then select Create Application.
2.	Enter Hour Awarding for the Proper name and click Next.
iii.	Click the Report Page Type.
four.	You want to use the query you created in the previous topic. Select SQL Query for Page Source, enter Departments for the Page Name and click Query Builder.
v.	Click the Saved SQL tab.
6.	Select the saved SQL link Section Locations.
seven.	The Query definition is shown. Click Return.
8.	The SQL is shown in the Query expanse. Click Add together Page.
9.	You lot are now going to create another page. Click the Study and Form Page Type.
10.	Select Departments (1), and then select the up arrow for Table Proper name.
11.	Select the EMPLOYEES table.
12.	Click Add Folio.
13.	Select the EMPLOYEES Page Name link for Folio ii.
fourteen.	Select DEPARTMENT_NAME for the Link Cavalcade, select DEPARTMENT_ID for the Parent Report Cavalcade 1, select the DEPARTMENT_ID for the Report Cavalcade, deselect Use Theme-Specific edit push and click Apply Changes.
15.	Select the Departments Page Name link for Page ane.
16.	Change the Show parameter for DEPARTMENT_ID to No and click Apply Changes.
17.	You have created all the pages necessary at this signal. Click Side by side > .
eighteen.	You want one set of tabs. Click Adjacent >.
19.	There are no shared components. Click Next > .
20.	Accept the default Authentication and Language Blazon and click Next > .
21.	Accept the default Theme and click Side by side > .
22.	You are ready to create your awarding. Click Create.
23.	Your application, Login page and 3 user-defined pages take been created. Click Run Awarding.
24.	The login Page appears. Enter hr for the Username and Password and click Login.
25.	The Listing of Departments (Report) is shown. Select one of the Department links.
26.	A List of Employees (Report) for the Department is shown. Select the Edit icon in front of ane of the Employees.
27.	The data of the Employee (Course) is displayed.

Back to Topic List

You can besides create a Tabular Grade on an existing page. Perform the following steps:

1.	From the developer links at the bottom of the page, click Edit Page 3.
two.	To create a new folio, click Create > .
3.	Make sure Region on this Page is selected, and click Next >.
4.	To specify the component that is going to be added to the folio, select the Form choice. Click Side by side >.
5.	Select the Tabular Form option, and click Side by side >.
6.	Click Next >.
vii.	Select the upwardly arrow to select a table.
8.	Select the JOB_HISTORY (table) link.
9.	Click Next >.
x.	Shift-select all the columns and click Next >.
xi.	Select EMPLOYEE_ID for the Primary Key column 1 and click Next >.
12.	Select the Existing sequence pick. This results in a new Sequence selection list beingness displayed. From the Selection drib-down list, select EMPLOYEES_SEQ and click Side by side >.
13.	The columns on the class that are updateable are listed and selected. Click Adjacent >.
14.	Change the Region Title to Job History and make sure the Page is set up to 3. Then, click Next >.
xv.	Take the default buttons to be created. Click Next >.
xvi.	Change When Cancel Button Pressed Co-operative to this Folio to 2 and click Next >.
17.	Review your choices and click Finish.
eighteen.	In order for this form to only show the tasks for a item project, you demand to add a where clause to the SELECT statement in the Projects region. Click Edit Page .
nineteen.	Under Regions, click the Job History report link.
20.	Click the Source link.
21.	Add together the following WHERE clause at the terminate of the SELECT statement. Then click the Height pointer. WHERE EMPLOYEE_ID = :P3_EMPLOYEE_ID
22.	Click Employ Changes.
23.	To see the new page that displays all the projects, click the Run Page 3 ( )icon.
24.	The Form is now shown with the list of Jobs an Employee has had.

Back to Topic List

Although the Primary-Detail grade is fully functional, the looks tin can exist improved. Perform the following tasks in this topic:

To do all this, perform the post-obit steps:

1.	Click the Prove Edit Links link.
2.	Click the Edit icon ( ) to the correct of Hire Date.
three.	Under the Page Item department, select Appointment Picker (DD-MON-YY) from the Display As drib-down listing. Click Use Changes.
four.	Refresh your browser. Notice that the Calendar icon appears next to the Hire Date field. Click the Calendar icon.
5.	The agenda widget appears. Click Close.
half-dozen.	Click the Edit Folio 3 Link.
seven.	You lot can also create a Named LOV that is referenced past the Job Id field. By creating it as a Named LOV, it tin can be used by other pages in the application too. Under the Listing of Values department on the correct, click the Create icon ( ).
8.	For Create List of Values, go on the default value From Scratch, and click Adjacent >.
nine.	For Name, enter jobid. For Type, change to Dynamic. And then click Next >.
10.	For the query , enter the following: select job_title d, job_id r from jobs guild by 1 Click Create List of Values.
eleven.	To return to the page, click the Run Page iii icon at the top right.
12.	Click the Edit icon ( ) to the right of Job Id .
13.	Click the LOV link.
xiv.	Nether the List of Values section, select JOBID from the Named LOV drop-downward list. Click the Top icon ().
15.	Under the Page Detail section, select Select Listing from the Display As drop-down listing. Click Employ Changes.
sixteen.	Click the Refresh button in your browse and notice that yous know have a driblet downward listing for Job Id. Select the arrow to see the list of Jobs to choose from.
17.	Click Hibernate Edit Links.

Back to Topic List

When you created the application, yous selected the red theme. Y'all can change the look and feel of the application by changing the theme. Y'all first create a new theme by selecting one from the Repository. To employ a new theme, perform the post-obit steps:

1.	Click the Edit Application link from the Developer Links at the lesser of the page.
2.	Click the down arrow next to Shared Components > User Interface > Themes.
three.	To create a new theme, click Create > .
4.	Have the default From the Repository and click Next >.
v.	From the Theme options, select the Theme ten pick. Click Next >.
6.	Click Create.
7.	To switch to the Sand theme, click Switch Theme.
8.	For Switch to Theme, make certain 10. Sand is selected. Click Adjacent >.
9.	Notice that the page displays the compatibility between the two themes. This utility checks whether at that place is a template in the new theme to supplant each of the templates in the current theme. The check marks in the Status column point that the templates are compatible. Click Side by side >.
10.	To confirm the theme switch, click Switch Theme.
11.	To see the new theme, click the Run Page iii icon ( ) at the top right of the page.
12.	The color scheme has changed. Click the Departments breadcrumb.
thirteen.	Discover that the entire appearance of your awarding has changed.

Back to Topic List

In this tutorial, you learned how to:

	Create and modify a table
	Create an awarding
	Add and edit a Tabular form
	Edit application objects and change the theme

Back to Topic List

To larn more than about Awarding Express Development and how to customize the application you built in this tutorial, refer to the following:

Back to Topic List

Place the cursor over this icon to hide all screenshots.

Source: https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/269211.htm

Posted by: kimberlincren1949.blogspot.com

Share this post