How To Enter a New Row into a Table Interactively?
Submitted by: AdministratorIf 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:
► Double-click on the table name TIP.
► Click the Data tab in the object view.
► Click the Insert Row icon, the + sign.
► Enter ID as: 101.
► Enter SUBJECT as: Backup #1.
► Click the Commit Changes icon.
You know the new row is inserted, because the log area shows you:
INSERT INTO "HR"."TIPS" (ID, SUBJECT) VALUES ('101', 'Backup #1')
Commit Successful
Submitted by: Administrator
► Double-click on the table name TIP.
► Click the Data tab in the object view.
► Click the Insert Row icon, the + sign.
► Enter ID as: 101.
► Enter SUBJECT as: Backup #1.
► Click the Commit Changes icon.
You know the new row is inserted, because the log area shows you:
INSERT INTO "HR"."TIPS" (ID, SUBJECT) VALUES ('101', 'Backup #1')
Commit Successful
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | How To Use Values from Other Tables in UPDATE Statements using Oracle? |
☺ | What Is Input Buffer in SQL*Plus? |
☺ | How To Run SQL*Plus Commands in SQL Developer? |
☺ | How To Create a Stored Procedure in Oracle? |
☺ | What Is an Oracle User Account? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |