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