© Ben Brumm 2019
Ben BrummBeginning Oracle SQL for Oracle Database 18chttps://doi.org/10.1007/978-1-4842-4430-2_15

15. Adding Data to a Table

Ben Brumm1 
(1)
Melbourne, VIC, Australia
 

The database we have been working on so far has three tables: employee, office, and sales_meeting. Only one of these tables has any data in it: the employee table. Adding data to a table is a separate step to creating the table.

Earlier in the book, when you added data to the employee table, you used the menu options within SQL Developer. You did this when you set up the table, and when you added more data to the table. However, just as we learned that creating a table can be done with a statement, adding data can also be done with an SQL statement.

The reasons for using ...

Get Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.