Add Extra Display Column in IG - Interactive Grid

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 1982
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Add Extra Display Column in IG - Interactive Grid

Post by admin »

1. Write an SQL as below,

select EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO,
(select d.dname from dept d where d.deptno = emp.deptno) DEPT_NAME
from EMP
IG1.PNG
2. Keep all settings default and now click this DEPT_NAME column under IG and change the property to Query Only.
ig2.PNG
You do not have the required permissions to view the files attached to this post.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests