Creating and Managing Tables - Oracle PL SQL Course - Lesson 12 | SQL courses

Duration: 19:44 min

Summary: Tables are the most important object the Oracle database. These objects stored the data in the tabular format (columns and rows) and can have relationships with other tables. This video explains the CREATE OR REPLACE command to create tables and its columns. The definition of a table requires the name of the table and the specification of the columns’ names and datatypes. The examples showed include the creation, modification and removal of tables, the TRUNCATE command and also some discussion about the basic datatypes and the scenarios where a table can be renamed and have its columns changed or removed.