Hi James, Would you mind if you can elaborate more what you mean by underlying schema changes?
I am asking this because we are having a service which fetches columns from system catalog. If you can tell how It will affect then I shall fallback jdbc metadataapi. Thanks, Satya On 27-Aug-2015 8:26 pm, "James Taylor" <[email protected]> wrote: > Use these standard JDBC APIs: > http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html > > Querying directly against the SYSTEM.CATALOG is not recommended as > underlying schema changes may impact you. > > Thanks, > James > > On Thursday, August 27, 2015, Ns G <[email protected]> wrote: > >> Hi James, >> >> I think we can get the dynamic column names from SYSTEM.CATALOG table. >> Using as co-related sub query we can use in select statement and fetch >> details. Isn't this an option to consider? Do you see anything wrong with >> this approach? >> >> Thanks, >> Satya >> On 27-Aug-2015 7:28 pm, "Manjee, Sunile" <[email protected]> >> wrote: >> >>> James, >>> Where can I find info on "JDBC Metadata APIs for each view entity" >>> >>> From: James Taylor <[email protected]> >>> Reply-To: "[email protected]" <[email protected]> >>> Date: Monday, August 24, 2015 at 3:04 PM >>> To: user <[email protected]> >>> Subject: Re: select Dynamic column Name >>> >>> JDBC Metadata APIs for each view entity >>> >>
