facebook message wise time

select msg_id,
case
when to_char(to_date(wk_dt,'DD-MON-RR HH24:MI:SS'),'DD-MON-RR')=to_char(sysdate,'DD-MON-RR')
then to_char(to_date(wk_dt,'DD-MON-RR HH24:MI:SS'),'HH24:MI AM')
when trunc(sysdate - to_date(wk_dt,'DD-MON-RR HH24:MI:SS'))>=1 and trunc(sysdate - to_date(wk_dt,'DD-MON-RR HH24:MI:SS'))<=6
then to_char(to_date(wk_dt,'DD-MON-RR HH24:MI:SS'),' DY, HH24:MI AM')
when trunc(sysdate - to_date(wk_dt,'DD-MON-RR HH24:MI:SS'))>=7
then to_char(to_date(wk_dt,'DD-MON-RR HH24:MI:SS'),'DD-MON-RR, DY, HH24:MI AM')
end tt
from MSG_MESSENGER
--where msg_id=5

login page right side in oracle apex

Page level -> CSS -> inline CSS

.t-PageBody--login #wwvFlowForm {
    flex-direction: row-reverse;
}

.t-PageBody--login {
    overflow: hidden;
}



///

.t-PageBody--login #wwvFlowForm {
    flex-direction: row-reverse;
    overflow: hidden;
}

all multiple row in single row in oracle database function

create or replace function alpha_examall (p_st_dt date,p_end_dt date, P_div_cd varchar2,P_dept_cd varchar2, p_desg_cd varchar2)
return varchar2
as
cursor c1 is
select distinct EXAM_INFO.exam_name
from emp_mast,EMP_EDU,EXAM_INFO
where emp_mast.emp_id=EMP_EDU.emp_id
and EMP_EDU.EXAM_CD=EXAM_INFO.EXAM_CD
and emp_mast.div_cd=P_div_cd
and emp_mast.dept_cd=P_dept_cd
and emp_mast.desg_cd=P_desg_cd
and emp_mast.flag='R'
and emp_mast.conf_fg<>'4'
and to_date(emp_mast.resig_dt) between p_st_dt and p_end_dt;

v_ret  varchar2(200) := '';

begin
for r1 in c1 loop
v_ret := v_ret||r1.exam_name||', ';
end loop;
return v_ret;
exception
when others then
return 'err';
end;


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


create or replace function alpha_examall (P_INV_NO varchar2)
return varchar2
as
cursor c1 is
select distinct PRICE.P_NAME exam_name
from INVOICE_CHILD,PRICE
where INVOICE_CHILD.B_CODE=PRICE.B_CODE
and INVOICE_CHILD.INV_NO=P_INV_NO;

v_ret  varchar2(200) := '';

begin
for r1 in c1 loop
v_ret := v_ret||r1.exam_name||', ';
end loop;
return v_ret;
exception
when others then
return 'err';
end;