Insert a New Row into a Table in Oracle


How To Insert a New Row into a Table in Oracle?



To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example:

INSERT INTO fyi_links VALUES (101, 
1 row created.

SELECT * FROM fyi_links;
   ID URL                      NOTES     COUNTS CREATED
----- ------------------------ -------- ------- ---------
  101 NULL           0 30-Apr-06


Specify Default Values in INSERT Statements in Oracle

Set Up SQL*Plus Output Format in Oracle

Understanding SQL DML Statements for Oracle

⇑⇑ Oracle Database Tutorials

2020-01-29, 1367👍, 0💬