input is like
Type,Financial_ yr,Month,Amount
T1 ,2010 ,April,1000
T1 ,2010 ,May ,2000
T1 ,2010 ,June ,3000
T2 ,2011 ,May ,1500
T2 ,2011 ,July ,3500
T2 ,2011 ,Aug ,4000
My output wiil be like
Type,Financial_ yr,M1 ,M2 ,M3 ,Total_amount
T1 ,2010 ,1000 ,2000,3000,6000
T2 ,2011 ,1500 ,3500,4000,9000
kishore Roul
Last Activity: Mar 15 '11, 09:32 AM
Joined: Jan 21 '11
Location:
-
How to display one column values to multiple column values?
-
How to load data from/to utl file?
how to load data from utl file to oracle and how to load data from oracle to utl file -
How to retrive data without table name?
how to retrieve data witout table name -
Why we are using to_number function in this query?
query like
select * from emp where deptno=To_numbe r(10)
i think it is used for tune the query ..yes on no.
plz give me the relevant answer -
How to tune the query?
How to tune the query ?
Exp: if query like
select hiredate from emp
where to_char(hiredat e,'dd-mon-yyyy')<'05-05-1982'; -
How many varchar2 datatypes present in a table?
how many varchar2 data types present in a table?
Exp Emp table in scott user.
No activity results to display