Module: OCI8::Metadata

Defined in:

lib/oci8/metadata.rb,
ext/oci8/metadata.c

Overview

OCI8 can describe database object’s metadata.

user objects

OCI8#describe_any(object_name)

table or view

OCI8#describe_table(table_name, table_only = false)

view

OCI8#describe_view(view_name)

procedure

OCI8#describe_procedure(procedure_name)

function

OCI8#describe_function(function_name)

package

OCI8#describe_package(package_name)

type

OCI8#describe_type(type_name)

synonym

OCI8#describe_synonym(synonym_name, check_public_also = false)

sequence

OCI8#describe_sequence(sequence_name)

schema

OCI8#describe_schema(schema_name)

database

OCI8#describe_database(database_name)

The name can be supplied as ‘OBJECT_NAME’ or ‘SCHEMA_NAME.OBJECT_NAME’. For example: ‘emp’, ‘scott.emp’.

Retrieving Column Datatypes for a Table

conn = OCI8.new('ruby', 'oci8')
table = conn.describe_table('EMPLOYEES')
table.columns.each do |col|
  if col.char_used
    col_width = col.char_size
  else
    col_width = col.data_size
  end
end

Defined Under Namespace

Classes: ArgBase, Argument, Base, Collection, Column, Database, Function, List, Package, ProcBase, Procedure, Schema, Sequence, Synonym, Table, Type, TypeArgument, TypeAttr, TypeMethod, TypeResult, Unknown, View