Insert a New Row into a Table in Oracle

Q

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

✍: FYIcenter.com

A

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, 
  'http://dev.fyicenter.com', 
  NULL,
  0,
  '30-Apr-2006');
1 row created.

SELECT * FROM fyi_links;
   ID URL                      NOTES     COUNTS CREATED
----- ------------------------ -------- ------- ---------
  101 http://dev.fyicenter.com NULL           0 30-Apr-06

 

Understanding SQL DML Statements for Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 140👍, 0💬