Oracle Application Express Tutorial: Building an Application demonstrates how to build a working application for managing projects and tasks using some of the
| Previous PDF | Next PDF |
[PDF] Tutorial: Building an Application - Oracle Help Center
For this tutorial, you must have access to an Oracle Application Express environment, an account with development privileges, and the Packaged App Sample
[PDF] Oracle® Application Development Framework Tutorial (101310)
This tutorial is for J2EE developers who use Oracle Application Development Framework (ADF) to build Web applications Structure The tutorial consists of the
[PDF] Oracle® Application Development Framework
This tutorial is for Java EE developers who use Oracle Application Development Framework (ADF) to build Web applications Structure The tutorial consists of
[PDF] Oracle Application Express Application Builder - Oracle Help Center
caused by use of this software or hardware in dangerous applications Oracle and Java are registered trademarks of Oracle and/or its affiliates Other names
[PDF] Application Builder Users Guide - Oracle Help Center
Logging In To Oracle Application Express as a Developer training content, including Oracle by Example (OBE), demos, and tutorials To access the Oracle
[PDF] Tutorial: Building an Application - Oracle Help Center
Oracle Application Express Tutorial: Building an Application demonstrates how to build a working application for managing projects and tasks using some of the
[PDF] App Builder Users Guide - Oracle Help Center
Oracle Application Express App Builder User's Guide, Release 18 1 If you use this software or hardware in dangerous applications, then you shall be
[PDF] Oracle Database Application Express Advanced Tutorials
Oracle Database Application Express Advanced Tutorials, Release 3 0 B28842- 01 Copyright © 2003, 2007, Oracle All rights reserved Primary Authors: Anne
[PDF] oracle awr report
[PDF] oracle care policies and procedures
[PDF] oracle cloud infrastructure 2019 certified architect associate
[PDF] oracle cloud infrastructure architect associate dumps
[PDF] oracle cloud infrastructure architect associate workshop (student guide)
[PDF] oracle cloud infrastructure architect associate workshop (student guide) pdf
[PDF] oracle cloud infrastructure study guide pdf
[PDF] oracle cloud login
[PDF] oracle cloud policies
[PDF] oracle cloud services agreement
[PDF] oracle cloud services program documentation
[PDF] oracle content and experience cloud
[PDF] oracle content cloud documentation
[PDF] oracle data processing agreement
boldfaceBoldface type indicates graphical user interface elements associated
with an action, or terms defined in text or the glossary.italicItalic type indicates book titles, emphasis, or placeholder variables for
which you supply particular values. monospaceMonospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.EBA_PROJECTS
Demo Projects
EBA_PROJECTS
Projects
Project Costs
Project Status
eba_projectsMaintain project details
This application is used to maintain projectdetails for the team. Projects include milestones, where you candefine due dates. Tasks can be defined against a milestone ordirectly against the project. As well as tracking dates, thisapplication also tracks budget, for the project, and costs againsteach task.
0 99991000
4
Maintain Project
3CARD_LINK
select © © card_modifiers , apex_page.get_url( p_page => ©4©, p_clear_cache => ©4©, p_items => ©P4_ROWID©, p_values => rowid ) card_link , © © card_color , © © card_icon , apex_string.get_initials(name) card_initials , name card_title , description card_text , ©Budget ©|| to_char(budget,©L99G999©) card_subtextfrom EBA_PROJECTS
Validation successful
Status
select description d, id rfrom EBA_PROJECT_STATUSorder by display_order - Select Status -EBA_PROJECT_STATUS
display_orderAudit Details
P4_ROWID
Show Completed Date
3 3 status_ID=3)P4_COMPLETED_DATE
Completed Date is Not Null
P4_COMPLETED_DATE
#LABEL# must have some value.P4_STATUS_ID
3Completed Date is not Forward Dated
:P4_COMPLETED_DATE <= SYSDATE :ITEM_NAMESYSDATE
#LABEL# cannot be forward datedP4_COMPLETED_DATE
EBA_PROJECTS
EBA_PROJECT_MILESTONES
EBA_PROJECT_TASKS
5Milestones
5050
EBA_PROJECT_MILESTONES
NAMEEBA_PROJECTS
EBA_PROJECTS
PROJECT_ID
Project Name
select NAME d, ID rfrom EBA_PROJECTSorder by NAMEProject Name
Project
- Select Project - NameMilestone
EBA_PROJECT_TASKS
EBA_PROJECTS_TASKS
6 Tasks 7Update Task
ID IDȑTasks
EBA_PROJECT_MILESTONES
PROJECT_ID
MILESTONE_ID
Milestone Name
MILESTONE NAME
select NAME d, ID rfrom EBA_PROJECT_MILESTONESorder by NAMEPROJECT_ID
MILESTONE_ID
PROJECT NAME
Project
MILESTONE NAME
Milestone
NAMEȑ
START_DATEȑ
END_DATEȑ
COSTȑ
IS_COMPLETE_YN
ȑTask
DD-MON-YYYY
_YNComplete
select ID, PROJECT_ID, MILESTONE_ID, NAME, DESCRIPTION, ASSIGNEE, START_DATE, END_DATE, COST, decode(is_complete_yn, ©Y©, ©Yes©, ©No©) IS_COMPLETE_YN, CREATED, CREATED_BY, UPDATED, UPDATED_BY from EBA_PROJECT_TASKS
decode Y Yes NoEBA_PROJECT_TASKS
PROJECT NAME
MILESTONE NAME
Project
Milestone
Task select distinct ASSIGNEE as d, ASSIGNEE as r from EBA_PROJECT_TASKS order by 1Complete
ȑProject Budgets and Costs
Costsselect p.name, sum(cost) valuefrom eba_project_tasks t, eba_projects pwhere p.id = t.project_idgroup by p.nameorder by 1
EBA_PROJECT_TASKS
EBA_PROJECTS
where (p.id) (t.project_id) group byPROJECT_ID
p.nameBudgets
600Incomplete Tasks
select p.name project, m.name milestone, m.due_date, t.name task, t.start_date, t.end_datefrom eba_projects p, eba_project_milestones m, eba_project_tasks t
where p.id = m.project_idand p.id = t.project_idand t.milestone_id = m.id (+)and nvl(t.is_complete_yn, ©N©) = ©N©
EBA_PROJECT_TASKS
8Task Overview
IS_COMPLETE
COSTIS_COMPLETE_YN
ȑComplete
select ID, PROJECT_ID,MILESTONE_ID, NAME, DESCRIPTION, ASSIGNEE, START_DATE, END_DATE, COST, decode(is_complete_yn, ©Y©, ©Yes©, ©No©) IS_COMPLETE_YN, CREATED, CREATED_BY, UPDATED, UPDATED_BY from EBA_PROJECT_TASKS
80fa-table-pointer