Press "Enter" to skip to content

How to Insert Data in Table Using Toad?

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