Toad create records/datasets

Does toad oracle have any tools for creating records/datasets? I need to create about 1k records for testing. Not sure what the best way to do this is.

If the table is already created, right-click on it in the Schema Browser and choose Data -> Generate.

That will launch a wizard where you can put random data in your table.

Yes the table is already created. How do you open the schema browser?

Click here
image

For some the table is missing.

You will need to create the tables, first. You can either construct the CREATE TABLE statement yourself and execute it in the Editor or you can use Toad's Create Table window. See the Database > Create menu on Toad's main menu.

It already exists. Not sure why the schema browser is not seeing it.

Do you have any filters set? If the circled icon is red in color instead of gray or if the circled edit box has any text other than * then a filter is applied which will limit the tables you see.

image

It does not look like I have any filters.