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] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> James, >> Where can I find info on "JDBC Metadata APIs for each view entity" >> >> From: James Taylor <[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> >> Reply-To: "[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>" < >> [email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> >> Date: Monday, August 24, 2015 at 3:04 PM >> To: user <[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> >> Subject: Re: select Dynamic column Name >> >> JDBC Metadata APIs for each view entity >> >
