saya sedang coba 10gR2 di linux pakai centos 4.2, mengapa ya kalau saya select join group hasilnya kok nggak urut beda banget waktu pakai oracle 8.1.7
apakah ada yang perlu di set init paramaternya ? yang mana ? contoh kasus : 1.buat tabel CREATE TABLE EMPxx ( EMPNO NUMBER (4) NOT NULL, ENAME VARCHAR2 (30), JOB VARCHAR2 (15), DEPTNO NUMBER (2), CONSTRAINT PK_EMPNO PRIMARY KEY ( EMPNO ) ) ; INSERT INTO EMPxx ( EMPNO, ENAME, JOB, DEPTNO ) VALUES (1011, 'supriyanto', 'programmer', 20); INSERT INTO EMPxx ( EMPNO, ENAME, JOB, DEPTNO ) VALUES ( 1005, 'amirul ichwan', 'programmer', 30); INSERT INTO EMPxx ( EMPNO, ENAME, JOB, DEPTNO ) VALUES ( 1007, 'estuningsih', 'programmer', 40); INSERT INTO EMPxx ( EMPNO, ENAME, JOB, DEPTNO ) VALUES ( 1002, 'antoro', 'system analys', 20); INSERT INTO EMPxx ( EMPNO, ENAME, JOB, DEPTNO ) VALUES ( 1003, 'tatang', 'system analys', 20); commit; CREATE TABLE DEPTxx ( DEPTNO NUMBER (2) NOT NULL, DNAME VARCHAR2 (14), LOC VARCHAR2 (13) ) ; INSERT INTO DEPTxx ( DEPTNO, DNAME, LOC ) VALUES ( 20, 'research', 'dallas'); INSERT INTO DEPTxx ( DEPTNO, DNAME, LOC ) VALUES ( 10, 'accounting', 'new york'); INSERT INTO DEPTxx ( DEPTNO, DNAME, LOC ) VALUES ( 30, 'sales', 'chicago'); INSERT INTO DEPTxx ( DEPTNO, DNAME, LOC ) VALUES ( 40, 'operations', 'boston'); commit; untuk oracle 8i select e.DEPTNO from EMPxx e, DEPTxx d where e.DEPTNO = d.DEPTNO group by e.DEPTNO hasil : DEPTNO 20 30 40 untuk oracle 10Gr2 select e.DEPTNO from EMPxx e, DEPTxx d where e.DEPTNO = d.DEPTNO group by e.DEPTNO hasil : DEPTNO 30 20 40 terlihat hasil tidak urut / tidak sama dengan 8i -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
