Database Administration (MOSC)

MOSC Banner

column is not sorting after upgrade

edited Feb 24, 2010 5:16PM in Database Administration (MOSC) 7 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center