APEX18 of 30: Create interactive report (IR). Modify LOV code. Format phone display with LOV.
If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files used in this video series. https://sites.google.com/view/db-krei...
APEX 18.1 video 18 of 30: Create an interactive report based on SQL. The SQL code combines data from two tables and uses an inner join. Copy an LOV and modify the code. Use an LOV to format a phone number column.
SQL code for interactive report:
select PERSONS.PERS_ID,
FNAME,
MNAME,
LNAME,
ADDR,
ZIP,
PHONE_NUM,
STATUS,
ROLE,
SUPV_ID,
BEGIN_DATE,
END_DATE,
PERSONS.DATE_CREATED,
PERSONS.DATE_MODIFIED
from PERSONS
inner join EMPLOYEES
on PERSONS.PERS_ID = EMPLOYEES.PERS_ID
where status = 'Active'
SQL for phone format:
select substr(phone_num,1,3)||'.'||substr(phone_num,4,3)||'.'||
substr(phone_num,7,4) as phone,
phone_num
from persons
order by 1
Watch video APEX18 of 30: Create interactive report (IR). Modify LOV code. Format phone display with LOV. online without registration, duration hours minute second in high quality. This video was added by user J Kreie Database 05 November 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,585 once and liked it 16 people.