Module: STACI::Metadata

Defined in:

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

Overview

STACI has methods to obtain information about database objects such as tables, views, procedures, functions ans so on. The obtained data are called metadata and retrived as an instance of STACI::Metadata::Base’s subclass.

List of methods which return STACI::Metadata::Base.

• STACI#describe_any(object_name)

• STACI#describe_table(table_name, table_only = false)

• STACI#describe_view(view_name)

• STACI#describe_procedure(procedure_name)

• STACI#describe_function(function_name)

• STACI#describe_package(package_name)

• STACI#describe_type(type_name)

• STACI#describe_synonym(synonym_name, check_public_also = true)

• STACI#describe_sequence(sequence_name)

• STACI#describe_schema(schema_name)

• STACI#describe_database(database_name)

• STACI::Metadata::Type#map_method

• STACI::Metadata::Type#order_method

• STACI::Metadata::Type#collection_element

List of methods which return an array of STACI::Metadata::Base.

• STACI::Cursor#column_metadata

• STACI::Metadata::Database#schemas

• STACI::Metadata::Schema#all_objects

• STACI::Metadata::Schema#objects

• STACI::Metadata::Table#columns

• STACI::Metadata::Package#subprograms

• STACI::Metadata::Procedure#arguments

• STACI::Metadata::Function#arguments

• STACI::Metadata::Type#type_attrs

• STACI::Metadata::Type#type_methods

• STACI::Metadata::TypeMethod#arguments

Example:

conn = STACI.new('username/passord')
table = conn.describe_table('scott.emp')
table.columns.each do |col|
  puts "#{col.name} #{col.data_type_string}"
end

Defined Under Namespace

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