Hi,
I have the following query.Ã, When I run this query in Oracle SQL it generates in the form of a report.Ã,Â
I want to know if I can get the same output when I run this query in a sql window in a datasource.
set headsep 1
column NUM format 1500
column LEVEL format 1500 word_wrapped
column PART_CODE format 1500 word_wrapped
column TOTAL_ITEMS format 1500 word_wrapped
break on NUM skip 1 on report
compute sum of TOTAL_ITEMS on NUM
set linesize 50
set pagesize 60
set newpage 0
select A.NUM, B.LEVEL, C.PART_CODE,
COUNT(C.ITEM) AS TOTAL_ITEMS
FROM
ITEM_DETAIL A, PART_LEVEL B,
PROD_DETAIL C, MASTER_DETAIL D
WHERE
A.ITEM_NO = D.ITEM_NO AND
B.LEVEL = D.LEVEL AND
C.PROD_ID = D.PROD_ID
GROUP BY
A.NUM, B.LEVEL, C.PART_CODE
ORDER BY
A.NUM ASC, B.LEVEL, C.PART_CODE ASC
Because I am getting the following error when I run it:
DS-DBMS-E400: UDA driver reported the following on connection 'source':
DMS-E-GENERAL, A general exception has occurred during operation 'execute immediate'.
ORA-00922: missing or invalid option
Plz help.
Thank you.
MP.
just go to the "SQL Helper" paste it and run it. The output you see is what you will get