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

 

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community OrclQA.com for developers and ask your question. It is FREE.

Vinish Kapoor

Follow

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

guest
0 Comments
Inline Feedbacks
View all comments