Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews DB Oracle Interviews:Concepts and ArchitectureData AccessDatabase ArchitectureDatabase ManagementDatabase Security OracleDistributed ProcessingFlexfieldForms ReportsGeneral OracleMemory ManagementMTO-SAP Financial AccountingOCIOracle AOLOracle AROracle Backup RecoveryOracle D2KOracle DatabaseOracle Database DeveloperOracle DB OptimizationOracle DBAOracle DeveloperOracle ETLOracle Forms 3.0Oracle Forms 4.0Oracle GLOracle PL-SQLOracle RMANOracle ScenariosOracle SecurityOracle SQLOracle System ArchitectureOracle Technology Network (OTN)Programmatic ConstructsRAC (Real Application Clusters)SQL Plus
Copyright © 2018. All Rights Reserved
Oracle Database Interview Question:
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
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.