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