Re: Obtain information about columns in views

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 28 Nov 2007 17:30:29 -0800 (PST)
Message-ID: <25ebbb55-6f88-4302-a2e4-9dd3ede0a3df@b15g2000hsa.googlegroups.com>

On Nov 28, 9:17 am, niimrod <niim..._at_gmx.de> wrote:
> Does anyone know a query I can run against the DBA_xxx views to get
> the names of the columns in
> a view? For tables exist SYS.ALL_TAB_COLUMN, but thers's nothing ike
> thsi for views.
> Normally I would use "desc" but I'm working with thin-jdbc where desc
> doesn't work.
>
> Thanks.
>
> niimrod

Hi,

You can always use ResultSetMetaData to get the column names for any ResultSet...

C:\java>type getRstMD.java
import java.sql.*;

public class getRstMD {
  public static void main(String args[]) throws java.sql.SQLException{

        try {
      Class.forName("oracle.jdbc.driver.OracleDriver");
      Connection con =

DriverManager.getConnection("jdbc:oracle:thin:@192.168.1. 51:1521/test1","rep","rep");

      Statement stm = con.createStatement();
      ResultSet rst = stm.executeQuery("select * from all_tables");
      ResultSetMetaData rsMetaData = rst.getMetaData();
      for (int i = 1; i <= rsMetaData.getColumnCount(); i++) {
        System.out.println(rsMetaData.getColumnName(i) + "\t\t" +

rsMetaData.get
ColumnTypeName(i));

      }
      con.close();

    }
    catch (Exception e) {

          e.printStackTrace();
        }

  }
}

C:\java>java getRstMD

OWNER           VARCHAR2
TABLE_NAME              VARCHAR2
TABLESPACE_NAME         VARCHAR2
CLUSTER_NAME            VARCHAR2
IOT_NAME                VARCHAR2
STATUS          VARCHAR2
PCT_FREE                NUMBER
PCT_USED                NUMBER
INI_TRANS               NUMBER
MAX_TRANS               NUMBER
INITIAL_EXTENT          NUMBER
NEXT_EXTENT             NUMBER
MIN_EXTENTS             NUMBER
MAX_EXTENTS             NUMBER
PCT_INCREASE            NUMBER
FREELISTS               NUMBER
FREELIST_GROUPS         NUMBER
LOGGING         VARCHAR2
BACKED_UP               VARCHAR2
NUM_ROWS                NUMBER
BLOCKS          NUMBER
EMPTY_BLOCKS            NUMBER
AVG_SPACE               NUMBER
CHAIN_CNT               NUMBER
AVG_ROW_LEN             NUMBER
AVG_SPACE_FREELIST_BLOCKS               NUMBER
NUM_FREELIST_BLOCKS             NUMBER
DEGREE          VARCHAR2
INSTANCES               VARCHAR2
CACHE           VARCHAR2
TABLE_LOCK              VARCHAR2
SAMPLE_SIZE             NUMBER
LAST_ANALYZED           DATE
PARTITIONED             VARCHAR2
IOT_TYPE                VARCHAR2
TEMPORARY               VARCHAR2
SECONDARY               VARCHAR2
NESTED          VARCHAR2
BUFFER_POOL             VARCHAR2
ROW_MOVEMENT            VARCHAR2
GLOBAL_STATS            VARCHAR2
USER_STATS              VARCHAR2
DURATION                VARCHAR2
SKIP_CORRUPT            VARCHAR2
MONITORING              VARCHAR2
CLUSTER_OWNER           VARCHAR2
DEPENDENCIES            VARCHAR2
COMPRESSION             VARCHAR2
DROPPED         VARCHAR2

C:\java>

HTH, Steve Received on Wed Nov 28 2007 - 19:30:29 CST