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
Escape special characters
No comments:
Post a Comment