DB tables

Constrain with cascade for foreign key(S)

select SVR_TASR_SEQ.nextval into :new.TASR_ID from dual;

select SVR_SITR_SEQ.nextval into :new.SITR_ID from dual;

select SVR_ROOR_SEQ.nextval into :new.ROOR_ID from dual;

select SVR_DEVN_SEQ.nextval into :new.DEVN_ID from dual;

select SVR_DEV_SEQ.nextval into :new.DEV_ID from dual;

 Steps   TABLE, SEQUENCE, TRIGGER

 Constraint: Primary, Foreign

Font Color

Codes script type="text/javascript">

var x = document.getElementsByTagName("SPAN");

var s;

if (x)

{

for (var i = 0; i <>

{

s = x[i];

if (s.style.color == "red" && s.style.fontWeight == "bold")

{

s.style.color = "blue";

}

}

}

Font Color:
in region footer>>>
Begin script type="text/javascript">
var x = document.getElementsByTagName("SPAN");
var s;
if (x)
{
for (var i = 0; i < s =" x[i];" color ="=" fontweight ="=" color = "blue" type="text/javascript">
var x = document.getElementsByTagName("SPAN");
var s;
if (x)
{
for (var i = 0; i < s =" x[i];" color ="=" fontweight ="=" color = "blue">

root of Tree

UPDATE SVR_DEVICES
SET SURPLUS_DATE = SYSDATE
WHERE DEV_ID = :P3_DEV_ID;











I founded old way only:

Select DEV_ID + 20000 id,

ROOM + 10000 PID,

HOST_NAME name,

'f?p=&APP_ID.:6:&SESSION.::NO::P6_DEV_DEV_ID:'||dev_ID AS link,

null AS a1,

null AS a2

from SVR_DEVICES

UNION

Select ROOR_ID + 10000 id,

SITR_SITR_ID PID,

ROOM name,

null AS link,

null AS a1,

null AS a2

from SVR_ROOMs_RF

union

select 0 ID,

0 PID,

'All Cities' name,

null AS link,

null AS a1,

null AS a2

from SVR_SITES_RF where rownum = 1

UNION

select SITR_ID ID,

0 PID,

city name,

null AS link,

null AS a1,

null AS a2

from SVR_SITES_RF

order by name

Email:

A) created a page with region
B) insert Page Items and a button
C) Entered the following code in the PL/SQL page process area.
DECLARE
l_id number;

BEGIN
l_id := APEX_MAIL.SEND(
p_to => :P11_EMAIL,
p_from => :P11_FROM,
p_subj => :P11_SUBJECT,
p_body => :P11_BODY);

COMMIT;
END;

Info With Attahcment
To Apex Mail
More Info

make sense But Need to Test
DECLARE
l_id number;
BEGIN
l_id := APEX_MAIL.SEND(
p_to => 'email@host.com',
p_from => 'email2@host.com',
p_subj => 'TEST',
p_body => 'SOME TEXT HERE',
p_body_html => ' ');
apex_mail.push_queue;
COMMIT;
END;

also note APEX_MAIL.SEND as apposed to htmldb_MAIL.SEND and similar apex_mail.push_queue
and the p_body_html field