The most basic SQL statement in Oracle

OracleHow to display all current user tables

Show all tables of a user (for example, Scott, uppercase is required)

Select table_name from all_tables where owner = 'Scott ';

Show all current user tables

Select * From user_tables

Display All Tables of the current database

Select * From tab;

Displays information about all columns in a table.

Select * From user_tab_columns where table_name in ('order _ status2 ');

Display the space name of the current data table

You can use sys User Login

Select tablespace_name from dba_tables where table_name = upper ('name of the table you operated ')

The displayed tablespace_name is the name of the tablespace you are currently operating on.

Run the Statement of the local SQL file (the file used in learning is number. SQL)

SQL> @ C:/number. SQL

Insert Date

Insert into order_status2 values (00001, 'good', to_date ('201312', 'yyyymmdd'), 2, to_date ('20170101', 'yyyymmdd '));

Add columns and set default values

Alter table order_status2 add initially_created date default sysdate not null;