Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - Creating tables in oracle database
Creating tables in oracle database
Creating tables in oracle can be operated through sql statements or graphical interfaces.

I. sql statement:

Create? Table? test

(id? int,

Name? varchar 2( 10)); Second, the graphical interface:

Take PL/SQL as an example:

1. Log in to the specified database.

2. Find the table option in the list on the left, right-click and select New.

3. Under the General tab, fill in the table name and select the tablespace.

4. Under the Columns tab, fill in the field name and type, and then click Apply to save.