Collections:
Enter a New Row Interactively in Oracle
How To Enter a New Row into a Table Interactively in Oracle?
✍: FYIcenter.com
If you don't like to use the INSERT statement to enter a new row into a table, you can use the object view to enter it interactively. Follow the steps below to enter new row into table TIP:
You know the new row is serted, because the log area shows you:
INSERT INTO "HR"."TIPS" (ID, SUBJECT) VALUES ('101', 'Backup #1') Commit Successful
⇒ Report View in SQL Developer in Oracle
⇐ Create a Table Interactively in Oracle
2018-10-08, 1432🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...