column is not sorting after upgrade
select distinct T1.fldcolumn,T1.week,T1.fldcolumn_1,T1.site_loc, RTRIM(
TO_CHAR(T1.dbid) )
from
history_test T1 where T1.dbid <> :"SYS_B_00" and (T1.dbid in (:"SYS_B_01",
:"SYS_B_02",:"SYS_B_03",:"SYS_B_04",:"SYS_B_05",:"SYS_B_06",:"SYS_B_07",
:"SYS_B_08",:"SYS_B_09",:"SYS_B_10",:"SYS_B_11",:"SYS_B_12",:"SYS_B_13",
:"SYS_B_14"))
we recently upgraded the database to 10.2.0.4 from 10.1.0.2 before we are getting o/p of above query sorted with T1.week column now we are not getting the sorted output column(week) can u tell me what i have to do its automatically sort (Week) column
from
history_test T1 where T1.dbid <> :"SYS_B_00" and (T1.dbid in (:"SYS_B_01",
:"SYS_B_02",:"SYS_B_03",:"SYS_B_04",:"SYS_B_05",:"SYS_B_06",:"SYS_B_07",
:"SYS_B_08",:"SYS_B_09",:"SYS_B_10",:"SYS_B_11",:"SYS_B_12",:"SYS_B_13",
:"SYS_B_14"))
we recently upgraded the database to 10.2.0.4 from 10.1.0.2 before we are getting o/p of above query sorted with T1.week column now we are not getting the sorted output column(week) can u tell me what i have to do its automatically sort (Week) column
0