Redirect To Another Page by URL syntext In Oracle Apex

##URL-Syntext##

--------------------------------------------------------------------------------

f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly

##URL Syntext Under Query##

--------------------------------------------------------------------------------

select 'f?p=' || :APP_ID || ':' || :APP_PAGE_ID || ':APP_SESSION' || '::::P1_ID:' || emp.empno as link_url from emp

or

select empno, ename, 'f?p=' || :APP_ID || ':26:' || :APP_SESSION || '::' || :DEBUG || ':26:P26_EMPNO:' || empno as edit_link from emp

or

select empno, ename,

apex_page.get_url ( p_page => '26', p_clear_cache => '26', p_items => 'P26_ID', p_values => empno ) as edit_link

from emp

##Get URL Syntext Under Query## 

---------------------------------------------------------------------------------

select apex_page.get_url( p_application => :APP_ID, p_page => :APP_PAGE_ID, p_session => :APP_SESSION, p_items => 'P1_ID', p_values => emp.empno ) as link_url from emp;

##PREPARE URL with session##

---------------------------------------------------------------------------------

APEX_UTIL.PREPARE_URL(p_url => 'f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly',p_checksum_type => 'SESSION'); APEX_UTIL.PREPARE_URL(p_url => 'f?p=' || l_app || ':1:'||l_session||'::NO::P1_ITEM:xyz',p_checksum_type => 'SESSION');

##PREPARE URL without session##

---------------------------------------------------------------------------------

htp.p(APEX_UTIL.PREPARE_URL(p_url => 'f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly'); 

htp.p(APEX_UTIL.PREPARE_URL(p_url => 'f?p=' || :APP_ID || ':10:'|| :APP_SESSION ||'::NO::P10_ITEM:ABC');

##Javascript call url##

----------------------------------------------------------------------------------

javascript:popupURL('f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly')

javascript:popupURL('f?p=&APP_ID.:189:&APP_SESSION.:::189:')

##PLSQL Report call Model Page##

v_url := APEX_UTIL.PREPARE_URL ('f?p='|| :APP_ID|| ':340:'|| :APP_SESSION|| '::NO::P340_LATITUDE,P340_LONGITUDE:'|| i.M_LATITUDE ||','||i.M_LONGITDE||'');

#Model Page Open by SQL Query#

----------------------------------

 select ename,

 case when empno is not null then 

'<a href="'|| APEX_UTIL.PREPARE_URL('f?p='|| :APP_ID|| ':540:'|| :APP_SESSION|| '::NO:::') ||'">'|| ename ||'</a>'

end link

from emp

Open window

-----------------------------------

javascript:window.open('f?p=&APP_ID.:249:&SESSION.:::::','_blank');

javascript:window.open('f?p=&APP_ID.:1:&SESSION.:::1:P1_ID:'+$v("P844_ID")+','_blank');