Functional Index
  • latinlyricslatinlyrics June 2011
    HI

    Can anyone tell me how to see the detials of a functional index column. At the moment it only appears as SYS......

    Also when I describe a table and click on the index tab I seem to only be able to see standard indexes and not custom indexes.

    Thanks for your Help.


  • MarcusMarcus June 2011
    What about the results of the

    SELECT * FROM ALL_INDEXES

    query?

    Can you see any interest information(s)?
  • latinlyricslatinlyrics June 2011

    HI MArcus

     

    Thanks but perhaps I didnt explain my question clearly.

    When I describe a table and look at the indexes or I query the index columns all functional indexes are displayed as virtual columns... for example TRUNC("ACTUAL_SHIPMENT_DATE") will display as SYS_NC00350$. I would like to see the functional statement displayed rather than SYS_NC00350$.

    I have also noticed that when I describe a table and go to the index tab the custom indexes do not display.

     

    Does Dreamcoder have the funtionality to resolve these 2 issues?

     

    Thanks for your help

  • MarcusMarcus June 2011
    Hi latinlyrics,

    I don't know if Dreamcoder has any suitable functionalities to solve the issues that you explain. But I ask you some informations about the results of the query SELECT * FROM ALL_INDEXES: if this query does not expose, by one or more column combination, the information that you need, I think that is very hard, for Dreamcoder, to recognize the informations you need!

Add a Comment
Why do a donation?
The development of such an applications requires an important amount of time and resources. Your continued donations will allow us to continue the development and maintenance.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

In this Discussion

Tagged