Collections:
Insert a New Row into a Table in Oracle
How To Insert a New Row into a Table in Oracle?
✍: FYIcenter.com
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
⇒ Specify Default Values in INSERT Statements in Oracle
⇐ Set Up SQL*Plus Output Format in Oracle
2020-01-29, 1367👍, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...