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, 1586🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...