Learn how to use the CREATE TABLE command in Oracle to create a new database table and specify the columns and data types for the 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, for example, five digits.…
Note: This training course is appropriate for beginning database developers with no prior experience with SQL or Oracle.
- Using Oracle SQL*Developer, the free development environment
- Selecting data from tables
- Filtering data
- Using functions to manipulate data
- Joining data from tables
- Creating tables
- Updating values
- Truncating data
- Grouping and ordering result sets
- Working with primary keys
- Checking constraints
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
1. Introduction to SQL
2. Preparing the Course Environment
Downloading the course VM2m 16s
3. Using Oracle SQL Developer
4. Basic SELECT Queries
5. String, Number, and Date Functions
6. Joining Table Data
7. Manipulating Data
8. Grouping Data
9. Advanced Topics
Next steps1m 33s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.