Thursday, May 2, 2019

html link in sql

select  'Edit Project Information'  as "Edit Project", '<a href="f?p=' ||100||':'||3||':'||:APP_SESSION|| '">"Edit Project Information"</a>' as "Edit Project Information" , to_number('1') as slno  from dual
union all
select  'Edit Project Follow Up'    as "Edit Project",'<a href="f?p=' ||100||':'||20||':'||:APP_SESSION|| '">"Edit Project Follow Up"</a>' as "Edit Project Follow Up"  , to_number('2') as slno  from dual
union all
select  'Edit Project Contraction'  as "Edit Project",'<a href="f?p=' ||100||':'||5||':'||:APP_SESSION|| '">"Edit Project Contraction"</a>' as "Edit Project Contraction"  , to_number('3') as slno  from dual
union all
select  'Edit Project Sampling'     as "Edit Project" ,'<a href="f?p=' ||100||':'||12||':'||:APP_SESSION|| '">"Edit Project Sampling"</a>' as "Edit Project Sampling"  , to_number('4') as slno from dual
union all
select  'Edit Project Requirement'  as "Edit Project" ,'<a href="f?p=' ||100||':'||38||':'||:APP_SESSION|| '">"Edit Project Requirement"</a>' as "Edit Project Requirement" , to_number('5') as slno  from dual
union all
select  'Edit Project Projection'   as "Edit Project" ,'<a href="f?p=' ||100||':'||24||':'||:APP_SESSION|| '">"Edit Project Projection"</a>' as "Edit Project Projection"  , to_number('6') as slno from dual
union all
select  'Edit Project Approval'     as "Edit Project",'<a href="f?p=' ||100||':'||14||':'||:APP_SESSION|| '">"Edit Project Approval"</a>' as "Edit Project Approval"  , to_number('7') as slno  from dual
union all
select  'Edit Project Delivery'     as "Edit Project",'<a href="f?p=' ||100||':'||16||':'||:APP_SESSION|| '">"Edit Project Delivery"</a>' as "Edit Project Delivery"  , to_number('8') as slno  from dual
order by slno


Security

Required
Escape special characters

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...