Class: OCI8::Metadata::Database
Overview
Metadata for a database.
This is returned by:
-
OCI8#describe_database(database_name)
Instance Method Summary collapse
-
#autocommit_ddl ⇒ Object
Is autocommit mode required for DDL statements? Values are
:ac_ddl
and:no_ac_ddl
. -
#catalog_location ⇒ Object
Position of the catalog in a qualified table.
-
#charset_id ⇒ Object
database character set Id.
-
#charset_name ⇒ Object
database character set name.
-
#cursor_commit_behavior ⇒ Object
How a COMMIT operation affects cursors and prepared statements in the database.
-
#inspect ⇒ Object
:nodoc:.
-
#locking_mode ⇒ Object
Locking mode for the database.
-
#max_catalog_namelen ⇒ Object
Maximum length of a catalog (database) name.
-
#max_column_len ⇒ Object
Maximum length of a column name.
-
#max_proc_len ⇒ Object
Maximum length of a procedure name.
-
#ncharset_id ⇒ Object
database national language support character set Id.
-
#ncharset_name ⇒ Object
database national language support character set name.
-
#nowait_support ⇒ Object
Does database support the nowait clause? Values are
:nw_supported
and:nw_unsupported
. -
#savepoint_support ⇒ Object
Does database support savepoints? Values are
:sp_supported
and:sp_unsupported
. -
#schemas ⇒ Object
array of Schema objects in the database.
-
#version ⇒ Object
database version.
Methods inherited from Base
#obj_id, #obj_link, #obj_name, #obj_schema
Instance Method Details
#autocommit_ddl ⇒ Object
Is autocommit mode required for DDL statements? Values are :ac_ddl
and :no_ac_ddl
1878 1879 1880 1881 1882 1883 |
# File 'lib/oci8/metadata.rb', line 1878 def autocommit_ddl case attr_get_ub1(OCI_ATTR_AUTOCOMMIT_DDL) when 0; :ac_ddl when 1; :no_ac_ddl end end |
#catalog_location ⇒ Object
Position of the catalog in a qualified table. Values are :cl_start
and :cl_end
1851 1852 1853 1854 1855 1856 |
# File 'lib/oci8/metadata.rb', line 1851 def catalog_location case attr_get_ub1(OCI_ATTR_CATALOG_LOCATION) when 0; :cl_start when 1; :cl_end end end |
#charset_id ⇒ Object
database character set Id
1805 1806 1807 |
# File 'lib/oci8/metadata.rb', line 1805 def charset_id attr_get_ub2(OCI_ATTR_CHARSET_ID) end |
#charset_name ⇒ Object
database character set name
1895 1896 1897 |
# File 'lib/oci8/metadata.rb', line 1895 def charset_name __charset_name(charset_id) end |
#cursor_commit_behavior ⇒ Object
How a COMMIT operation affects cursors and prepared statements in the database. Values are:
:cusror_open
-
preserve cursor state as before the commit operation
:cursor_closed
-
cursors are closed on COMMIT, but the application can still re-execute the statement without re-preparing it
1837 1838 1839 1840 1841 1842 |
# File 'lib/oci8/metadata.rb', line 1837 def cursor_commit_behavior case attr_get_ub1(OCI_ATTR_CURSOR_COMMIT_BEHAVIOR) when 0; :cusror_open when 1; :cursor_closed end end |
#inspect ⇒ Object
:nodoc:
1909 1910 1911 |
# File 'lib/oci8/metadata.rb', line 1909 def inspect # :nodoc: "#<#{self.class.name}:(#{obj_id}) #{obj_name} #{version}>" end |
#locking_mode ⇒ Object
Locking mode for the database. Values are :lock_immediate
and :lock_delayed
1887 1888 1889 1890 1891 1892 |
# File 'lib/oci8/metadata.rb', line 1887 def locking_mode case attr_get_ub1(OCI_ATTR_LOCKING_MODE) when 0; :lock_immediate when 1; :lock_delayed end end |
#max_catalog_namelen ⇒ Object
Maximum length of a catalog (database) name
1845 1846 1847 |
# File 'lib/oci8/metadata.rb', line 1845 def max_catalog_namelen attr_get_ub1(OCI_ATTR_MAX_CATALOG_NAMELEN) end |
#max_column_len ⇒ Object
Maximum length of a column name
1826 1827 1828 |
# File 'lib/oci8/metadata.rb', line 1826 def max_column_len attr_get_ub4(OCI_ATTR_MAX_COLUMN_LEN) end |
#max_proc_len ⇒ Object
Maximum length of a procedure name
1821 1822 1823 |
# File 'lib/oci8/metadata.rb', line 1821 def max_proc_len attr_get_ub4(OCI_ATTR_MAX_PROC_LEN) end |
#ncharset_id ⇒ Object
database national language support character set Id
1810 1811 1812 |
# File 'lib/oci8/metadata.rb', line 1810 def ncharset_id attr_get_ub2(OCI_ATTR_NCHARSET_ID) end |
#ncharset_name ⇒ Object
database national language support character set name
1900 1901 1902 |
# File 'lib/oci8/metadata.rb', line 1900 def ncharset_name __charset_name(ncharset_id) end |
#nowait_support ⇒ Object
Does database support the nowait clause? Values are :nw_supported
and :nw_unsupported
1869 1870 1871 1872 1873 1874 |
# File 'lib/oci8/metadata.rb', line 1869 def nowait_support case attr_get_ub1(OCI_ATTR_NOWAIT_SUPPORT) when 0; :nw_supported when 1; :nw_unsupported end end |
#savepoint_support ⇒ Object
Does database support savepoints? Values are :sp_supported
and :sp_unsupported
1860 1861 1862 1863 1864 1865 |
# File 'lib/oci8/metadata.rb', line 1860 def savepoint_support case attr_get_ub1(OCI_ATTR_SAVEPOINT_SUPPORT) when 0; :sp_supported when 1; :sp_unsupported end end |
#schemas ⇒ Object
array of Schema objects in the database
1905 1906 1907 |
# File 'lib/oci8/metadata.rb', line 1905 def schemas @schemas ||= list_schemas.to_a end |
#version ⇒ Object
database version
1800 1801 1802 |
# File 'lib/oci8/metadata.rb', line 1800 def version attr_get_string(OCI_ATTR_VERSION) end |