Region SQl query (Pl/Sql Function Body Returning Sql query) in oracle apex

See more:

Oracle

Dear friends,
I just want to know , how to create Reports or forms in SQl query(Pl/Sql Function Body Returning Sql query)

pls suggest me..

Region Form Sql Query Is :

select 
USERID,
DISPLAYNAME,
EMAILID,
LOGINNAME,
PASSWORDS,
usertypemaster.usertypename,
ISACTIVE,
'<a href="f?p=&APP_ID.:9:&SESSION.::NO::P9_USERID:'||USERID||'<br mode=" hold=" />">Edit</a>'||
' | '
||'<a href="java<!-- no -->script:functioncall('||USERID||');">Delete</a>' as ACTION 
from 
USERMASTER,
USERTYPEMASTER
where 
USERMASTER.USERTYPEID=USERTYPEMASTER.USERTYPEID
and
USERMASTER.DISPLAYNAME like (case  when :P8_FINDSYSTEM is null then USERMASTER.DISPLAYNAME else ('%' || :P8_FINDSYSTEM || '%') end) 
and
USERMASTER.USERTYPEID=( case
when :P8_SEARCHSYSTEM=5 then
USERMASTER.USERTYPEID 
else 
TO_NUMBER (:P8_SEARCHSYSTEM) 
end)
and USERTYPENAME <> 'Website Admin'

Please tell me how to create a form SQl query (Pl/Sql Function Body Returning Sql query)

regards,
Udayakumar