How to Insert Data using Oracle SQL Developer

The INSERT DML command introduces new rows of data into an SQL table. INSERT is under the Create domain of the CRUD acronym. When using the Oracle SQL Developer IDE, instead of writing an INSERT INTO command, there are visual elements within the IDE interface which help facilitate an INSERT operation. Continue reading to learn how with a simple example…

Choose Table To Insert Data Into

In the left-hand pane of SQL Developer (not shown) double-click on the table, you want to INSERT data into. A new dashboard will appear containing several different tabs.

Shown below is the dashboard view and table description for table STAGE_WALKING_STATS::

oracle-sql-developer-table-dashboard
Table description

The Constraints tab has information about any constraints on the table. In this example, table STAGE_WALKING_STATS has a PRIMARY KEY constraint on the DAY_WALKED column:

oracle-sql-developer-table-constraints
SQL Developer table constraints tab.

Insert A Single Row Using the Add Data Icon

To INSERT a row of data, click the Add Data icon which appears as a green plus symbol on top of a document:

oracle-sql-developer-table-data-insert-icon
Add data icon.

Fill out the necessary fields’ values in the data row provided for each row you wish to INSERT. In the below example, I enter in all the column values for a single row of data:

oracle-sql-developer-insert-data-row
Inserting a row of data using data tab.

To complete the INSERT, commit any newly added row(s). Simply click the Commit icon (noted by the Red arrow in the screenshot below) which appears as a green check mark on the well-known database container symbol:

oracle-sql-developer-commit-data-row
Commit new inserts with commit icon button.

If the INSERT is successful and no errors arise, SQL Developer displays a message indicating the successful commit:

oracle-sql-developer-commit-success-message
Successful commit message.

Consider making a small donation on my behalf as I continue to provide valuable content here on my blog. Thank you!


Insert Multiple Rows Using the Add Data Icon

It is absolutely possible to INSERT multiple rows at a time using Oracle SQL Developer. As you fill out and complete a row of data, press TAB on the keyboard. SQL Developer generates a new blank row automatically. Fill out these rows’ – and any subsequent rows – column data values and proceed with committing the new rows:

oracle-sql-developer-multi-row insert
Inserting multiple rows using Oracle SQL Developer data tab

Same as in the single row example, commit the data without any issues, and you will receive a committed successfully message. (Note: These 2 steps are not shown for this particular example. See the previous single-row INSERT section above for the same information, as they are identical. )

orracle-sql-developer-saved-data
Present data in the table from successful INSERTs.

Table Constraints Are Enforced When Inserting Data

Any table constraints are honored even when using the visual elements of Oracle SQL Developer to INSERT data. Since a row with the DAY_WALKED column date value of ’29-APR-21′ already exists in the STAGE_WALKING_STATS table, attempting to INSERT an additional row with that value fails due to the PRIMARY KEY constraint on the DAY_WALKED column:

oracle-sql-developer-insert-tab
Attempting to insert an additional record

Instead of a committed successfully message, Oracle SQL Developer returns a unique constraint violation error as shown in this screenshot:

Oracle-SQL-Developer-Error-Message
Insert error message.

Additional Posts That May Interest You

And it is as easy as that to INSERT rows of data into a table using Oracle SQL Developer.

If you see any mistakes in the code or have questions or comments, feel free to add them in the comments section of the post. Thank you for reading.

Like what you have read? See anything incorrect? Please comment below and thank you for reading!!!

A Call To Action!

Thank you for taking the time to read this post. I truly hope you discovered something interesting and enlightening. Please share your findings here, with someone else you know who would get the same value out of it as well.

Visit the Portfolio-Projects page to see blog post/technical writing I have completed for clients.



To receive email notifications (Never Spam) from this blog (“Digital Owl’s Prose”) for the latest blog posts as they are published, please subscribe (of your own volition) by clicking the β€˜Click To Subscribe!’ button in the sidebar on the homepage! (Feel free at any time to review the Digital Owl’s Prose Privacy Policy Page for any questions you may have about: email updates, opt-in, opt-out, contact forms, etc…)

Be sure and visit the “Best Of” page for a collection of my best blog posts.


Josh Otwell has a passion to study and grow as a SQL Developer and blogger. Other favorite activities find him with his nose buried in a good book, article, or the Linux command line. Among those, he shares a love of tabletop RPG games, reading fantasy novels, and spending time with his wife and two daughters.

Disclaimer: The examples presented in this post are hypothetical ideas of how to achieve similar types of results. They are not the utmost best solution(s). The majority, if not all, of the examples provided, is performed on a personal development/learning workstation-environment and should not be considered production quality or ready. Your particular goals and needs may vary. Use those practices that best benefit your needs and goals. Opinions are my own.

Hey thanks for commenting! Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.