SQL & PL/SQL

Hi to all,

I need to give a break up from the front end. For that I cannot use the SQL Break command

SELECT "DEPARTMENT"."DESCRIPTION" AS DEPARTMENT,
"BUDGET"."COST_CODE",
"BUDGET"."GL_CODE",
"BUDGET"."DESCRIPTION",
sum("BUDGET"."AMOUNT") over (partition by "DEPARTMENT"."DESCRIPTION") as amount,
"DIVISION"."DESCRIPTION",
"GENERAL_LEDGER"."ACCOUNT_DESCRIPTION",
"BUDGET"."DEPARTMENT_CODE",
"COST_CENTRE"."DESCRIPTION",
"BUDGET"."FINANCIAL_START_YEAR",
"BUDGET"."FINANCIAL_END_YEAR",
"BUDGET"."FINANCIAL_MONTH",
"BUDGET"."DIVISION_CODE",
"DEPARTMENT"."DEPARTMENT_CODE"
FROM "BUDGET",
"DIVISION",
"GENERAL_LEDGER",
"DEPARTMENT",
"COST_CENTRE"
WHERE ( "BUDGET"."DIVISION_CODE" = "DIVISION"."DIVISION_CODE" ) and
( "GENERAL_LEDGER"."DIVISION_CODE" = "DEPARTMENT"."DIVISION_CODE" ) and
( "BUDGET"."GL_CODE" = "GENERAL_LEDGER"."GL_CODE" ) and
( "DEPARTMENT"."DEPARTMENT_CODE" = "BUDGET"."DEPARTMENT_CODE" ) and
( "DEPARTMENT"."DIVISION_CODE" = "COST_CENTRE"."DIVISION_CODE" ) and
( "BUDGET"."COST_CODE" = "COST_CENTRE"."COST_CODE" ) and
( ( "BUDGET"."FINANCIAL_START_YEAR" = 2007 ) AND
( "BUDGET"."FINANCIAL_END_YEAR" = 2008 ) )
ORDER BY "DEPARTMENT"."DESCRIPTION" ASC
/

My result should be like below.. How to achive the below one without the SQL BREAK command

DEPARTMENT COST GL_CODE DESCRIPTION AMOUNT 'TEC ACCOUNT_DESCRIPTION DEPARTMENT_CODE DESCRIPTION FINANCIAL_START_YEAR FINANCIAL_END_YEAR FI DIVISION_CODE DEPARTMENT_CODE
--------------- ---- ---------- -------------------- ---------- ---- -------------------- --------------- -------------------- -------------------- ------------------ -- ------------- ---------------
Administration 55 831301 sf 5157 tech OTHER FEES (Statutor 1 QUALITY 2007 2008 88 1
y Auditors )

55 831201 budget 5157 tech TAX AUDIT FEES 1 QUALITY 2007 2008 88 1
03 831101 budget for sales 5157 tech STATUTORY AUDIT FEES 1 PROJECT 2007 2008 88 1

Information Tec 55 441101 Budget for system pu 978 tech SUNDRY DEBTORS CONTR 2 QUALITY 2007 2008 88 2
hnology rchase OL A/C-BILLS

07 831201 budget 978 tech TAX AUDIT FEES 2 SYSTEM ADMINISTRATIO 2007 2008 88 2
N

DEPARTMENT COST GL_CODE DESCRIPTION AMOUNT 'TEC ACCOUNT_DESCRIPTION DEPARTMENT_CODE DESCRIPTION FINANCIAL_START_YEAR FINANCIAL_END_YEAR FI DIVISION_CODE DEPARTMENT_CODE
--------------- ---- ---------- -------------------- ---------- ---- -------------------- --------------- -------------------- -------------------- ------------------ -- ------------- ---------------

Information Tec 03 831101 Budget for others 978 tech STATUTORY AUDIT FEES 2 PROJECT 2007 2008 88 2
hnology


Management 02 831201 Budget for Audit 8000 tech TAX AUDIT FEES 4 HUMAN RESOURCE 2007 2008 88 4

Marketing 03 831101 Budget for tax 86085 tech STATUTORY AUDIT FEES 3 PROJECT 2007 2008 88 3
02 441101 budget for marketing 86085 tech SUNDRY DEBTORS CONTR 3 HUMAN RESOURCE 2007 2008 88 3
OL A/C-BILLS



Please help me in this regard