Home » Developer & Programmer » Reports & Discoverer » Scatter Chart (10G Developer, 10G Database , Windows Server 2008)
Scatter Chart [message #674866] Wed, 20 February 2019 00:27
arfanalam
Messages: 1
Registered: February 2019
Junior Member
Dear All,
Hope you all doing well,please help me out.

CREATE TABLE SCATTER_DATA 
(
  UC_NO VARCHAR2(20) 
, X_P_START NUMBER 
, X_P_END NUMBER 
, Y_P_START NUMBER 
, Y_P_END NUMBER 
)
/

INSERT INTO "SCATTER_DATA" (UC_NO, X_P_START, X_P_END, Y_P_START, Y_P_END) VALUES ('UC 1', '1', '3', '1', '4')
/
INSERT INTO "SCATTER_DATA" (UC_NO, X_P_START, X_P_END, Y_P_START, Y_P_END) VALUES ('UC 2', '4', '5', '1', '3')
/

CREATE TABLE EMP 
(
  CODE NUMBER 
, NAME VARCHAR2(20) 
, UC_NO VARCHAR2(20) 
)
/


INSERT INTO "TTIME"."EMP" (CODE, NAME, UC_NO) VALUES ('1', 'ABC 1', 'UC 1')
/
INSERT INTO "TTIME"."EMP" (CODE, NAME, UC_NO) VALUES ('2', 'ABC 2', 'UC 1')
/
INSERT INTO "TTIME"."EMP" (CODE, NAME, UC_NO) VALUES ('3', 'ABC 3', 'UC 1')
/
INSERT INTO "TTIME"."EMP" (CODE, NAME, UC_NO) VALUES ('4', 'ABC 4', 'UC 2')
/

SELECT E.CODE,
  E.NAME,
  E.UC_NO,
  ROUND(DBMS_RANDOM.VALUE(S.X_P_START,S.X_P_END),2) X_POSITION,
  ROUND(DBMS_RANDOM.VALUE(S.Y_P_START,S.Y_P_END),2) Y_POSITION
FROM EMP E,
  SCATTER_DATA S
WHERE S.UC_NO=E.UC_NO
/

Please guide me how to plot this data on picture


/foru/forum/fa/14036/0/
  • Attachment: MAP1.jpg
    (Size: 18.06KB, Downloaded 2118 times)
Previous Topic: ORA-24323 Value not allowed in the Report Builder
Next Topic: Oracle Graph Report Issue
Goto Forum:
  


Current Time: Thu Mar 28 18:50:58 CDT 2024