Search This Blog

Friday, December 7, 2018

Delete Row From Classic/ IR Report in Oracle Apex



Due to time limitation here I just share the code. For details you can see the given Video under the post.

SELECT ROWID,   
EMPNO ID,   
EMPNO,   
ENAME,   
JOB,   
ename MGR,   
HIREDATE,   
SAL,   
COMM,
DEPTNO
FROM EMP_T

=============================
<span class="t-Icon fa fa-trash-o" aria-hidden="true"></span>
=============================
id='#ID#' class="delete t-Button t-Button--danger t-Button--simple t-Button--small" title="Delete Employee: #ENAME#"
=============================
this.triggeringElement.id
=============================
begin
delete emp_t where empno=:P10_NEW ;
end;
=============================
alert("Employee #"+$v("P10_New")+"removed.");
=============================

1 comment:

Split A String By Coma (,)

Step 1.  create or replace type split_tbl as table of varchar2(32767); Step 2. create or replace function split (     p_list varchar2,...