column numbers scroll

[Babo]

i'm running 8.0.01480.
if i do "describe" on a table i get a window with the column number, column name, type ,etc.

Problem:
if the columns do not fit in the window i scroll the roller and the sequence numbers of columns update.
i can't really call it a bug, cause i can argue it myself ,
but it's very inconvenient - i want to know what's the column number is , but once i move the roller - it gets updated...
Please advise.

 

[Marco Kalter]

The column number is an absolute number, and therefore it scrolls. If you need a relative number you will need to subtract 2 absolute column numbers.

 

[Babo]

Marco,
>..you will need to subtract 2 absolute column numbers.
how do i do this ?

 

[Marco Kalter]

Maybe I am missing your point. Can you provide an example?

 

[Babo]

sure.

create table Tbl_
(
  LN_KEY                     NUMBER not null,
  VERSION_NUM                NUMBER(3) not null,
  TRAN_KEY                   NUMBER,
  CUTOFF_DT                  DATE,
  SVCR_RPTD_LN_GRP_NUM       VARCHAR2(50),
  REGULATED_LOAN_FLAG        VARCHAR2(1),
  ORIGINATOR_BORROWER_ID     VARCHAR2(50),
  INSRT_DATE                 DATE not null,
  BORROWER_RESIDENT_CD       VARCHAR2(10),
  INSRT_USR_ID               VARCHAR2(30) not null,
  BORROWER_CLASS_CD          VARCHAR2(50),
  LAST_CHG_UPD_DATE          DATE not null,
  ORIGINATOR_PROPERTY_ID     VARCHAR2(50),
  LAST_CHG_USR_ID            VARCHAR2(30) not null,
  CREDIT_SCR_PROVIDER_CD     VARCHAR2(50),
  CREDIT_SCR_TYPE_CD         VARCHAR2(50),
  CREDIT_SCR_DT              DATE,
  CREDIT_SCR_VALUE_NUM       NUMBER,
  LOAN_SECURITIZE_DT         DATE,
  MONTHLY_DEBT_PMT_AMT       NUMBER(24,2),
  SUBSIDY_AMT                NUMBER(24,2),
  SECLIEN_SNR_BAL_AMT        NUMBER(24,2),
  SNR_EXTERNAL_BAL_AMT       NUMBER(24,2),
  PARI_PASSU_AMT             NUMBER(24,2),
  SUBORD_LIEN_AMT            NUMBER(24,2),
  RETAINED_AMT               NUMBER(24,2),
  RETAINED_DT                DATE,
  MAX_DRAW_AMT               NUMBER(24,2),
  OTH_ADVANCES_DT            DATE,
  CURR_DRAW_AMT              NUMBER(24,2),
  SUBSIDY_MONTH_CNT          NUMBER,
  PREPAY_AMT                 NUMBER(24,2),
  PREPAY_DT                  DATE,
  PREPAY_CUM_PENALTY_AMT     NUMBER(24,2),
  PREPAY_CUM_AMT             NUMBER(24,2),
  PREPAY_ANNUAL_MAX_PCT      NUMBER(24,2),
  ADJ_RATE_IDX_CD            VARCHAR2(50),
  CUR_MARGIN_RT              NUMBER(10,4),
  SUB_INT_RATE_FREQ_ADJ_NUM  NUMBER,
  INDEXED_FORCL_VAL_AMT      NUMBER(24,2),
  CLTV_RATIO_PCT             NUMBER(10,4),
  UPDT_APPRAIS_VAL_AMT       NUMBER(24,2),
  UPDT_APPRAIS_DT            DATE,
  UPDT_APPRAIS_TYP_CD        VARCHAR2(50),
  UPDT_APPRAIS_CONF_NUM      VARCHAR2(50),
  UPDT_APPRAIS_PROV_NAME     VARCHAR2(50),
  LOAN_ADV_APPRAIS_VAL_AMT   NUMBER(24,2),
  ADDTNL_VAL_AMT             NUMBER(24,2),
  PROP_TRANSFR_DECLASS_CNT   NUMBER,
  CURR_DELINQ_STAT_CD        VARCHAR2(3),
  RESTRUCTURE_FLAG           VARCHAR2(1),
  ARREAR_MONTH_CNT           NUMBER,
  PREV_1M_TOT_ARREAR_AMT     NUMBER(24,2),
  PREV_2M_TOT_ARREAR_AMT     NUMBER(24,2),
  PERF_ARRANGE_DT            DATE,
  LITIGATION_FLAG            VARCHAR2(1),
  REDEEM_ARREAR_MONTH_CNT    NUMBER,
  FORCL_AMT                  NUMBER(24,2),
  FORCL_SALE_DT              DATE,
  FORCL_SALE_INT_ARREARS_AMT NUMBER,
  INTENSIVE_CARE_FLAG        VARCHAR2(1),
  RECOV_PERIOD_COST_AMT      NUMBER(24,2),
  NET_PRIN_PERIOD_RECOV_AMT  NUMBER(24,2),
  NET_INT_PERIOD_RECOV_AMT   NUMBER(24,2),
  OTHER_RECOV_AMT            NUMBER(24,2),
  MIG_RECOV_PERIOD_AMT       NUMBER(24,2),
  RECOV_AMT                  NUMBER(24,2),
  PROG_NEGL_RECOV_AMT        NUMBER(24,2),
  DEBT_FORGIVENESS_FLAG      VARCHAR2(1),
  CREDIT_EVENT_FLAG          VARCHAR2(1),
  CREDIT_EVENT_DT            DATE,
  ORIGINATOR_NAME            VARCHAR2(50),
  PRIM_SVCR_NAME             VARCHAR2(50),
  PERF_RPT_DATE_KEY          NUMBER not null
)

now, click on the name -> select "describe".
i have a 21 columns displayed in the "describe" window.
first column is "LN_KEY", second column is "VERSION_NUM" and last displayed (21st) is "SUBSIDY_AMT".

If i scroll down to see the column "SECLIEN_SNR_BAL_AMT", which should be a 22nd column, the numbers to the left of the column list, do _not_ scroll together with the rest of the content of the "describe" window. As a result the "VERSION_NUM" becomes "1" and the "SECLIEN_SNR_BAL_AMT" has "21" displayed.

as i said - i do not think it's a bug, though i think its a new behavior. But i would rather see the column numbers scroll with the rest of the content. So the view on the displayed data is consistent.
Why?
well, i see no value in this new behavior - say if i want to see how many columns are in the table - i would have to write a sql now. Or if i need to see what's the seq number of particular column is - also can't do anymore..
Let me know.

 

[Marco Kalter]

The column numbers scroll just fine for me. Can you update to the current 8.0.4 version and try again?

 

[Babo]

perrrrrrfect!
in this latest version 804.1514 the numbers scroll together with the rest of the content of the window.

I DLed the latest version and installed it over the existing one. It even preserved the license info. Sweet!
I'm one happy camper now

thank you Marco!