Skip to main content

014 Building an Application part 08 Interactive Grid [Oracle Apex 5 1 Tu...





Oracle Apex 5 1 Tutorial
Building an Application part 08 Interactive Grid (IG)

Oracle Documentation:
https://docs.oracle.com/database/apex-5.1/AETUT/AETUT.pdf

My Blog: 
https://abuelenain.blogspot.com/

Scripts:
http://www.mediafire.com/file/vcdfwvxfi545juf/apex51-demo-basic-3760632.zip



SQL query:
select ID
, NAME
, DESCRIPTION
, PROJECT_LEAD
, COMPLETED_DATE
, STATUS
, CREATED
, CREATED_BY
, UPDATED
, UPDATED_BY
, (select count('x')
from demo_milestones m
where m.project_id =
p.id
) milestones
, (select count('x')
from demo_tasks t
where t.project_id =
p.id
) tasks
from DEMO_PROJECTS p

·      
Developing the Projects Pages
·      
Updating the SQL Query and
Displayed Columns
·      
Adding Names to the Project Lead
Column with a Shared LOV
·      
Updating the Appearance of the
Projects Report Page


·      
Customizing the Projects Report
Columns

Comments

Popular posts from this blog

Oracle APEX - Tabular form datepicker month and year selector

Customize LOGIN PAGE Using css! Oracle Apex

body{font-family: 'Droid Arabic Kufi', sans-serif; font-size:1.3rem;} .t-PageBody--login .t-Body { background-image: url(#WORKSPACE_IMAGES#BG.jpeg); background-position: center center; background-repeat:  no-repeat; background-attachment: fixed; background-size:  cover; background-color: #45484d; background-color: -moz-linear-gradient(top, #45484d 0%, #000000 100%); background-color: -webkit-linear-gradient(top, #45484d 0%,#000000 100%); background-color: linear-gradient(to bottom, #45484d 0%,#000000 100%); } body .t-Login-title , .t-Login-region {     background-color: rgba(128, 152, 180, 0.51); color: #F8F8F8 } .t-Login-body {     text-align: right; } .popup {   z-index: 10; margin:100px auto; display:block; text-align:center; -moz-box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */ -webkit-box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */ -o-box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */ box...

Oracle APEX 20.2 Patch p32006852_2020_Generic Installation