Monday , May 20 2024

Tables In Oracle Database

In today’s article, we will be examining Tables In Oracle Database, which are the simplest structures in which data is stored.

There are 8 types.

We can learn detailed information about tables and columns from the views below.

Tables and indexes should be stored in different tablespace.

If we want to write comments about tables and columns, we run the command below.

We can give a default value for a column when creating a table. It is especially used in columns containing dates.

In this case, when we query, the result comes as follows.

The reason for this is that we say fill in the blank with the ” sign.

If we want it to be history;

In this case, when we query, the result comes as follows.

A table can be created using virtual column as follows.

GENERATED ALWAYS can also be created without using the AS keyword.

However, when the GENERATED ALWAYS AS keyword is used, data is not stored on the virtual column.

When the table is queried with Select, virtual column values ​​are generated.

Another important issue when creating a table is the word LOGGING/NOLOGGING.

If LOGGING is used, a redo log is generated for each DML operation on the table. If NOLOGGING is used, log production is not done in some cases.

If the tablespace belonging to the table is nologging and nothing is specified when creating the table, NOLOGGING is applied to the table.

The LOGGING status of a table is changed as follows.

Loading

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories