| Author |
Message |
    
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 130
Registered: 05-2006
Posted From: 206.195.19.50
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 15, 2008 - 11:51 am: | 
   |
http://www.dba-oracle.com/sf_ora_00937_not_a_singl e_group_group_function.htm |
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 129
Registered: 05-2006
Posted From: 206.195.19.50
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 15, 2008 - 11:50 am: |
|
SQL Error: ORA-00937: not a single-group group function |
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 128
Registered: 05-2006
Posted From: 206.195.19.50
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 15, 2008 - 11:05 am: |
|
Error at Command Line:73 Column:17
Error report:
SQL Error: ORA-01790: expression must have same datatype as corresponding expression
01790. 00000 - "expression must have same datatype as corresponding express |
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 126
Registered: 05-2006
Posted From: 206.195.19.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Friday, July 11, 2008 - 9:46 am: |
|
WHENEVER SQLERROR EXIT SQL.ERROR
CLEAR BREAKS
CLEAR COLUMNS
CLEAR BUFFER
SET SPACE 0
SET HEADING On
SET NEWPAGE 1
SET PAGESIZE 80
SET FEEDBACK off
SET RECSEP OFF
SET TERMOUT OFF
SET LINESIZE 600
SET ECHO OFF
SET TRIMSPOOL ON
-- Declare variables
COL factor NEW_VALUE fr
-- Obtain values for variables
SELECT (&1*100) factor
FROM DUAL
;
SET VERIFY OFF;
SPOOL C:\monthly\out\bok_by_day_usd_&1..xls
SELECT
'THE BANK OF KOREA' name_client ||chr(9)||
TO_CHAR(b.CLOSE_BUS_DATE,'DD-MON-YY') date_asof || chr(9)||
TO_CHAR(sum(HOLDING_FACE),'999,999,999,999') holding_face_value,
TO_CHAR(sum(HOLDING_MARKET),'999,999,999,999') holding_market_value,
TO_CHAR(sum(LENDING_FACE),'999,999,999,999') lending_face_value,
TO_CHAR(sum(LENDING_MARKET),'999,999,999,999') lending_market_value,
TO_CHAR(sum(COLLATERAL_AMOUNT),'9999,999,999,999') collateral_amount,
round(SUM(LENDING_MARKET)/sum(HOLDING_MARKET)*100, 2) utilization_rate,
round(SUM(COLLATERAL_AMOUNT)/sum(LENDING_MARKET)*1 00, 2) Collateral_rate,
round(TO_CHAR(SUM(GROSS_EARNINGS),'999,999,999,999 '), 2) investment_proceeds,
round((SUM(DECODE(collateral_type_code,'1',GROSS_E ARNINGS,0))/sum(decode(collateral_type_code,'1',CO LLATERAL_AMOUNT,0)))*&fr, 2) investment_yield,
round(TO_CHAR(SUM(REBATE),'999,999,999,999'), 2) rebate_amount,
round((SUM(REBATE)/sum(decode(collateral_type_code ,'1',COLLATERAL_AMOUNT,0)))*&fr, 2) rebate_rate,
round(TO_CHAR(SUM(NET_EARNINGS),'999,999,999.99'), 1) total_earning,
round((SUM(NET_EARNINGS)/sum(LENDING_MARKET))*&fr, 2) total_rate_return,
round(TO_CHAR(SUM(BANK_FEE),'999,999,999.99'), 1) bank_fee,
round(TO_CHAR(SUM(CLIENT_EARNINGS),'999,999,999.99 '), 2) customer_income,
round(SUM(CLIENT_EARNINGS)/sum(HOLDING_MARKET)*&fr , 2) net_rate_return
FROM gsl.bok_mtd b,
gsl.summary_process_date s
where b.close_bus_date BETWEEN '01-dec-2007' AND '31-dec-2007'
--WHERE b.close_bus_date BETWEEN month_start_date AND month_to_process
AND affiliate IN ('BOZ')
HAVING SUM(holding_face) > 0
GROUP BY
b.CLOSE_BUS_DATE
UNION
SELECT
'THE BANK OF KOREA' name_client,
'Daily AVG',
to_char(SUM(HOLDING_FACE/TO_NUMBER(TO_CHAR(MONTH_T O_PROCESS,'DD'))),'999,999,999,999') holding_face_value,
to_char(SUM(HOLDING_MARKET/TO_NUMBER(TO_CHAR(MONTH _TO_PROCESS,'DD'))),'999,999,999,999') holding_market_value,
to_char(SUM(LENDING_FACE/TO_NUMBER(TO_CHAR(MONTH_T O_PROCESS,'DD'))),'999,999,999,999') lending_face_value,
to_char(SUM(LENDING_MARKET/TO_NUMBER(TO_CHAR(MONTH _TO_PROCESS,'DD'))),'999,999,999,999') lending_market_value,
to_char(SUM(COLLATERAL_AMOUNT/TO_NUMBER(TO_CHAR(MO NTH_TO_PROCESS,'DD'))),'9999,999,999,999') collateral_amount,
round(SUM(LENDING_MARKET)/sum(HOLDING_MARKET)*100, 2) utilization_rate,
round(SUM(COLLATERAL_AMOUNT)/sum(LENDING_MARKET)*1 00, 2) Collateral_rate,
round(to_char(SUM(GROSS_EARNINGS/TO_NUMBER(TO_CHAR (MONTH_TO_PROCESS,'DD'))),'999,999,999,999'), 2) investment_proceeds,
round((sum(decode(collateral_type_code,'1',GROSS_E ARNINGS,0))/sum(decode(collateral_type_code,'1',CO LLATERAL_AMOUNT,0)))*&fr, 2) investment_yield,
round(to_char(SUM(REBATE/TO_NUMBER(TO_CHAR(MONTH_T O_PROCESS,'DD'))),'999,999,999,999'), 2) rebate_amount,
round((sum(REBATE)/sum(decode(collateral_type_code ,'1',COLLATERAL_AMOUNT,0)))*&fr, 2) rebate_rate,
round(to_char(SUM(NET_EARNINGS/TO_NUMBER(TO_CHAR(M ONTH_TO_PROCESS,'DD'))),'999,999,999.99'), 1) total_earning,
round((sum(NET_EARNINGS)/sum(LENDING_MARKET))*&fr, 2) total_rate_return,
round(to_char(SUM(BANK_FEE/TO_NUMBER(TO_CHAR(MONTH _TO_PROCESS,'DD'))),'999,999,999.99'), 1) bank_fee,
round(to_char(SUM(CLIENT_EARNINGS/TO_NUMBER(TO_CHA R(MONTH_TO_PROCESS,'DD'))),'999,999,999.99'), 2) customer_income,
round((sum(CLIENT_EARNINGS)/sum(HOLDING_MARKET))*& fr, 2) net_rate_return
FROM gsl.bok_mtd b,
gsl.summary_process_date s
where b.close_bus_date BETWEEN '01-dec-2007' AND '31-dec-2007'
--WHERE b.close_bus_date BETWEEN month_start_date AND month_to_process
AND AFFILIATE IN ('BOZ')
HAVING SUM(holding_face) > 0
;
spool off;
exit; |
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 113
Registered: 05-2006
Posted From: 206.195.19.42
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, July 07, 2008 - 12:53 pm: |
|
tingespari |
Tingari_xx
Mudiripoyina Bewarse
Username: Tingari_xx
Post Number: 5844
Registered: 08-2006
Posted From: 205.157.110.11
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 03, 2008 - 11:08 am: |
|
racha ba
mana gang andarini piluvu, dongalu paripotaru malli
For everything , there is a first time and next time |
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 109
Registered: 05-2006
Posted From: 206.195.19.51
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 03, 2008 - 11:02 am: |
|
Error(7,22): PLS-00215: String length constraints must be in range (1 .. 32767) |
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 107
Registered: 05-2006
Posted From: 206.195.19.51
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 03, 2008 - 10:52 am: |
|
Rachespari |
Sinnodu
Mudiripoyina Bewarse
Username: Sinnodu
Post Number: 5245
Registered: 05-2005
Posted From: 192.223.226.6
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 03, 2008 - 10:52 am: |
|
endi eeh arachakam ikkada 
Dont show me ur attitude.I have got my own |
Tingari_xx
Mudiripoyina Bewarse
Username: Tingari_xx
Post Number: 5843
Registered: 08-2006
Posted From: 205.157.110.11
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 03, 2008 - 10:46 am: |
|
billeswari
For everything , there is a first time and next time |
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 104
Registered: 05-2006
Posted From: 206.195.19.51
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 03, 2008 - 10:00 am: |
|
 |
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 103
Registered: 05-2006
Posted From: 206.195.19.51
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, July 03, 2008 - 9:59 am: |
|
tingu nee XX lo Darren XXX |
Tingari_xx
Mudiripoyina Bewarse
Username: Tingari_xx
Post Number: 5816
Registered: 08-2006
Posted From: 205.157.110.11
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, July 02, 2008 - 3:47 pm: |
|
ee karra billa olu
For everything , there is a first time and next time |
Karra_billa
Pilla Bewarse
Username: Karra_billa
Post Number: 102
Registered: 05-2006
Posted From: 206.195.19.42
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, July 02, 2008 - 3:39 pm: |
|
tingeswari |
Yamakantri
Kurra Bewarse
Username: Yamakantri
Post Number: 1720
Registered: 07-2007
Posted From: 68.13.123.88
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, June 15, 2008 - 8:37 pm: |
|
SCJP cheddam anukuntunna.. scjp lo 3 types ichadu SE 1.4,SE 5.0 and SE 6.. ee 3 lo edo okati clear chesthe next level ki vellocha.. 1.4 ante only basic syntax and structure but SE 6 applications run cheyyatam vunnayi..
already chesina bewarses or telisina bewarses koncham help plz..
"I'm king of the world!" |
|
|
