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, 3470🔥, 0💬
Popular Posts:
How To Revise and Re-Run the Last SQL Command in Oracle? If executed a long SQL statement, found a m...
What Are the Basic Features of a Trigger in SQL Server? Since a SQL Server trigger is a really an ev...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What Are the Basic Features of a Trigger in SQL Server? Since a SQL Server trigger is a really an ev...
Where to find reference information and tutorials on MySQL database functions? I want to know how to...