Coba alter parameter berikut ... SQL> ALTER SYSTEM SET _newsort_enabled=FALSE;
CMIIW, Bowo --- In [email protected], setijo agus <[EMAIL PROTECTED]> wrote: > > 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/
