Oracle问题。 [英] Oracle question.
问题描述
亲爱的先生,
Iam Oracle开发人员(D2k),我在开发查询时遇到问题.....
让我解释一下详细信息,
报告是医生这一年的收入。
i已经开发了查询,但是给出了类似的信息:
收入类型医生姓名金额
----------------------------- -------------------------------
咨询umesh km 5000
>
这个用于,总时间。
但是,我想打印,几个月明智,
喜欢:
收入类型医生姓名jan feb mar 4月................. dec
--------------- -------------------------------------------------- ---------------------------------------
你可以帮我解决这个问题.......
我的查询看起来像:
Dear sir,
Iam Oracle developer(D2k), i have a problem in developing the query.....
let me explain in detail,
Report is Revenues for the year of Doctors.
i have develope the query, which give out but like:
Revenue type doctor name Amount
------------------------------------------------------------
consultation umesh k.m 5000
this for, total period.
but, i want to print, months wise,
like:
Revenue type doctor name jan feb mar april................. dec
--------------------------------------------------------------------------------------------------------
can u plz, help me out this problem.......
my query looks like:
推荐答案
这属于Oracle论坛,请确保在发布代码时使用代码标记。我这次会为你添加它们。
This belongs in the Oracle forum and please make sure to use code tags when posting code. I will add them in for you this time.
你好,
i已经构建了一个查询,这给了医生月度明智,我想要总结并放置在它旁边。
查询输出为:
revenuetype医生jan feb mar apr ......... ..dec
--------------------------------------- -------------------------------------------------- ---------------
咨询chandu 235 300 205 500 169.
但我想如下
revenuetype医生jan feb mar apr ........... dec Total
------------- -------------------------------------------------- --------------------------------------------------
咨询chandu 235 300 205 500 169.总和
使用此查询,我想在Reports6i中开发报告。
>
PLZ,任何人都可以帮忙....
chandra ......
Hello,
i have built a query, which gives amount of doctor monthly wise, I want to sum and place beside it.
query output as:
revenuetype doctor jan feb mar apr ...........dec
--------------------------------------------------------------------------------------------------------
consultation chandu 235 300 205 500 169.
but i want as follows
revenuetype doctor jan feb mar apr ...........dec Total
-----------------------------------------------------------------------------------------------------------------
consultation chandu 235 300 205 500 169. sum
by using this query, i want to develop a report in Reports6i.
plz, can anyone help out....
chandra......
您现在使用的查询是什么?
Pilgrim。
Hi,
What is the query you are using now?
Pilgrim.
这篇关于Oracle问题。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!