From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating a simple table

Creating a simple table - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Creating a simple table

“

- [Instructor] Inserting data into tables residing in your Oracle database is very easy and accomplished using the insert SQL command. When you insert data to a database table, you essentially add new rows to the table. So let's see an example in action. We will start by creating a table which we will use to insert new records into. So, in order to create a new table in the database, I'll type create table, specify the table name, for example, test_table1, and then, inside brackets, I'll specify the different column names and column data types for this table. So, for example, I can type col1 as the column name of the varchar2 data type, and I also can specify a length so, for example, 100. This means that col1, the first column in my table, is of varchar2 data type, and can store up to 100 characters. Adding another column can easily be done by typing comma and a name for my second column, for example, col2. This time, it's of the number data type, and I can also specify a length so…

Contents