How to Insert Data in Table Using Toad?

How to Insert Data in Table Using Toad?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL / Toad
  • 1 min read

In Toad, there are multiple ways to insert data into a table. The following are the examples of how to insert data in table using Toad.

Insert Data into Oracle Table Using Toad Examples

1. Using EDIT command.

  1. In SQL Editor, type EDIT command followed by the table name and press ENTER.
  2. A data grid will display, then click on (+) button to add a blank row.

2. Using Schema Browser

  1. Click on the menu Database > Schema Browser.
  2. In the Table tab, find your table and click on it.
  3. On the right side, click on the data tab.
  4. Then click on the (+) button to add a blank row.

3. Using Insert Statement

  1. In SQL Editor, type an insert statement for your table and press F5 or F9 to execute to insert data into the table.
Insert into SCOTT.EMP
(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)
Values
(7369, 'SMITH', 'CLERK', 7902, 
TO_DATE('12/17/1980 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 800, 20);

Output

1 row created.

See also:

  1. Import CSV using Toad
  2. Recover SQL Editor Files in Toad