.. -*- coding: utf-8; -*-

.. include:: HEADER.rst

==================

 Oracle database.

==================

.. contents::

Oracle database development environment.

========================================

  http://en.wikipedia.org/wiki/Oracle_SQL_Developer

                Integrated development environment (IDE) for working with

                SQL/PLSql in Oracle databases.

  http://en.wikipedia.org/wiki/SQL*Plus

                An Oracle database client that can run SQL and PL/SQL commands

                and display their results.

  http://en.wikipedia.org/wiki/Oracle_Forms

                Is a software product for creating screens that interact with an

                Oracle database. It has an IDE including an object navigator,

                property sheet and code editor that uses PL/SQL.

  http://en.wikipedia.org/wiki/Oracle_JDeveloper

                JDeveloper is a freeware IDE supplied by Oracle Corporation. It

                offers features for development in Java, XML, SQL and PL/SQL,

                HTML, JavaScript, BPEL and PHP.

  http://en.wikipedia.org/wiki/Oracle_Reports

                Oracle Reports is a tool for developing reports against data

                stored in an Oracle database.

Информация о таблицах в БД Oracle.

==================================

Список таблиц::

  select * from user_tables;

Занимаемый размер таблиц и индексов::

  select segment_name, segment_type, sum(bytes) from user_extents

    group by segment_name, segment_type order by sum(bytes);

  select sum(bytes) from user_extents;

Список индексов по таблицам::

  select * from user_indexes order by table_name;

Список размеров индексов по таблицам::

  select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes

    left outer join user_extents on user_extents.segment_name = table_name

    group by index_name, table_name

    order by table_name;

Список ограничений::

  select * from user_constraints;

Используемое пространство таблиц::

  select distinct tablespace_name from user_tables;