class OCI8::Metadata::Database

  • OCI8#describe_database(database_name)
    This is returned by:
    Metadata for a database.

def autocommit_ddl

:ac_ddl and :no_ac_ddl
Is autocommit mode required for DDL statements? Values are 
def autocommit_ddl
  case attr_get_ub1(OCI_ATTR_AUTOCOMMIT_DDL)
  when 0; :ac_ddl
  when 1; :no_ac_ddl
  end
end

def catalog_location

:cl_start and :cl_end
Position of the catalog in a qualified table. Values are 
def catalog_location
  case attr_get_ub1(OCI_ATTR_CATALOG_LOCATION)
  when 0; :cl_start
  when 1; :cl_end
  end
end

def charset_id

database character set Id 
def charset_id
  attr_get_ub2(OCI_ATTR_CHARSET_ID)
end

def charset_name

database character set name 
def charset_name
  __charset_name(charset_id)
end

def cursor_commit_behavior

statement without re-preparing it
application can still re-execute the
[:cursor_closed] cursors are closed on COMMIT, but the
operation
[:cusror_open] preserve cursor state as before the commit
the database. Values are:
How a COMMIT operation affects cursors and prepared statements in 
def cursor_commit_behavior
  case attr_get_ub1(OCI_ATTR_CURSOR_COMMIT_BEHAVIOR)
  when 0; :cusror_open
  when 1; :cursor_closed
  end
end

def inspect # :nodoc:

:nodoc: 
def inspect # :nodoc:
  "#<#{self.class.name}:(#{obj_id}) #{obj_name} #{version}>"
end

def list_schemas

List of schemas in the database 
def list_schemas
  __param(OCI_ATTR_LIST_SCHEMAS)
end

def locking_mode

:lock_delayed
Locking mode for the database. Values are :lock_immediate and 
def locking_mode
  case attr_get_ub1(OCI_ATTR_LOCKING_MODE)
  when 0; :lock_immediate
  when 1; :lock_delayed
  end
end

def max_catalog_namelen

Maximum length of a catalog (database) name 
def max_catalog_namelen
  attr_get_ub1(OCI_ATTR_MAX_CATALOG_NAMELEN)
end

def max_column_len

Maximum length of a column name 
def max_column_len
  attr_get_ub4(OCI_ATTR_MAX_COLUMN_LEN)
end

def max_proc_len

Maximum length of a procedure name 
def max_proc_len
  attr_get_ub4(OCI_ATTR_MAX_PROC_LEN)
end

def ncharset_id

database national language support character set Id 
def ncharset_id
  attr_get_ub2(OCI_ATTR_NCHARSET_ID)
end

def ncharset_name

database national language support character set name 
def ncharset_name
  __charset_name(ncharset_id)
end

def nowait_support

:nw_supported and :nw_unsupported
Does database support the nowait clause? Values are 
def nowait_support
  case attr_get_ub1(OCI_ATTR_NOWAIT_SUPPORT)
  when 0; :nw_supported
  when 1; :nw_unsupported
  end
end

def savepoint_support

:sp_supported and :sp_unsupported
Does database support savepoints? Values are 
def savepoint_support
  case attr_get_ub1(OCI_ATTR_SAVEPOINT_SUPPORT)
  when 0; :sp_supported
  when 1; :sp_unsupported
  end
end

def schemas

array of Schema objects in the database 
def schemas
  @schemas ||= list_schemas.to_a
end

def version

database version 
def version
  attr_get_string(OCI_ATTR_VERSION)
end