|
|
| Re: How can i use formula column and place holder column? [message #188902 is a reply to message #178622] |
Tue, 22 August 2006 05:46  |
rana.irfan@arzootex.com
Messages: 15
Registered: June 2006
Location: Faisalabad.
|
Junior Member |
|
|
hi,
SELECT ALL EMP.EMPNO, EMP.ENAME,
EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO
FROM EMP
Now we Required Department Name against Emp.DeptNo.
for this we required Formula column.
function CF_1Formula return Char is
A varchar2(50);
begin
select Dname Into A from Dept
where deptno=:deptno;
Return A;
end;
Placeholder.
Click placeholders column and put in query and then
function CF_1Formula return Char is
A varchar2(50);
begin
select Dname Into A,:CP_1 from Dept
where deptno=:deptno;
Return A;
end;
Note :CP_1 is placeholder column that is used as a variable.
sorry for my weak English writing.
Regards,
Rana Irfan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
