Can a formula column be obtained through a select statement?
Answer Posted / anil_abbireddy
Yes,
Ex:-
select empno,ename,sal,sal*10/100 hike from emp;
expl: here hike is the formula column obtained through
select statement
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
What is a user exit program in oracle reports?
What do you understand by oracle forms and why are they required?
how do u compile a form i.e .fmb file in Unix or in dos
if u want to delete all these detail block etc what will happen in form
What are the various configuration files that are used by oracle forms?
What is a matrix report and how many minimum groups are required to prepare the same?
difference between global n context sensitive segments?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
Explain how one can iterate through items and records in a specified block?
did u received a single file or multiple files
what are the new features introduced in oracle form services in 11g release 2?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
how report can be generated if we have the database designed in oracle 10g?