All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class oracle.jdbc.driver.OracleResultSetMetaData

java.lang.Object
   |
   +----oracle.jdbc.driver.OracleResultSetMetaData

public class OracleResultSetMetaData

extends Object

implements ResultSetMetaData

getCatalogName(int)

What's a column's table's catalog name?

getColumnClassName(int)

Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column.

getColumnCount()

What's the number of columns in the ResultSet?

getColumnDisplaySize(int)

What's the column's normal max width in chars?

getColumnLabel(int)

What's the suggested column title for use in printouts and displays?

getColumnName(int)

What's a column's name?

getColumnType(int)

What's a column's SQL type?

The DBType structure holds the ORACLE type number (VARCHAR is 1) and we need to convert it to the Java type number (VARCHAR is 12).

getColumnTypeName(int)

What's a column's data source specific type name?

getPrecision(int)

What's a column's number of decimal digits? The semantic of get precision on non NUMERIC columns is weirdly defined by the JDBC test suite.

getScale(int)

What's a column's number of digits to right of decimal?

getSchemaName(int)

What's a column's table's schema?

getTableName(int)

What's a column's table name?

isAutoIncrement(int)

Is the column automatically numbered, thus read-only?

isCaseSensitive(int)

Does a column's case matter?

isCurrency(int)

Is the column a cash value?

isDefinitelyWritable(int)

Will a write on the column definitely succeed?

isNullable(int)

Can you put a NULL in this column?

isReadOnly(int)

Is a column definitely not writable?

isSearchable(int)

Can the column be used in a where clause?

isSigned(int)

Is the column a signed number?

isWritable(int)

Is it possible for a write on the column to succeed?

 public int getColumnCount() throws SQLException

What's the number of columns in the ResultSet?

Returns:

the number

 public boolean isAutoIncrement(int column) throws SQLException

Is the column automatically numbered, thus read-only?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

 public boolean isCaseSensitive(int column) throws SQLException

Does a column's case matter?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

 public boolean isSearchable(int column) throws SQLException

Can the column be used in a where clause?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

 public boolean isCurrency(int column) throws SQLException

Is the column a cash value?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

 public int isNullable(int column) throws SQLException

Can you put a NULL in this column?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

columnNoNulls, columnNullable or columnNullableUnknown

 public boolean isSigned(int column) throws SQLException

Is the column a signed number?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

 public int getColumnDisplaySize(int column) throws SQLException

What's the column's normal max width in chars?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

max width

 public String getColumnLabel(int column) throws SQLException

What's the suggested column title for use in printouts and displays?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

 public String getColumnName(int column) throws SQLException

What's a column's name?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

column name

 public String getSchemaName(int column) throws SQLException

What's a column's table's schema?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

schema name or "" if not applicable

 public int getPrecision(int column) throws SQLException

What's a column's number of decimal digits? The semantic of get precision on non NUMERIC columns is weirdly defined by the JDBC test suite.

 public int getScale(int column) throws SQLException

What's a column's number of digits to right of decimal?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

scale

 public String getTableName(int column) throws SQLException

What's a column's table name?

Returns:

table name or "" if not applicable

 public String getCatalogName(int column) throws SQLException

What's a column's table's catalog name?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

column name or "" if not applicable.

 public int getColumnType(int column) throws SQLException

What's a column's SQL type?

The DBType structure holds the ORACLE type number (VARCHAR is 1) and we need to convert it to the Java type number (VARCHAR is 12).

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

SQL type

See Also:

Types, DBType

 public String getColumnTypeName(int column) throws SQLException

What's a column's data source specific type name?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

type name

 public boolean isReadOnly(int column) throws SQLException

Is a column definitely not writable?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

 public boolean isWritable(int column) throws SQLException

Is it possible for a write on the column to succeed?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

 public boolean isDefinitelyWritable(int column) throws SQLException

Will a write on the column definitely succeed?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

 public String getColumnClassName(int column) throws SQLException

Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column. ResultSet.getObject may return a subclass of the class returned by this method.

Returns:

the fully-qualified name of the class that ResultSet.getObject to retrieve the value in the specified column. This is the class name used for custom mapping.

Throws: SQLException

if a database access error occurs

All Packages  Class Hierarchy  This Package  Previous  Next  Index