Copy & Paste Imports from Excel to Oracle using SQL Developer

Oh, I so DO love hearing about things that ‘we cannot do.’ This morning I read that in an article that Oracle doesn’t allow you to copy data from Excel and paste directly to a table.

AHEM.

Add as many rows as you want and paste from your spreadsheet.

Add as many rows as you want and paste from your spreadsheet.

In the video you see me selecting the cells in the Oracle table editor before pasting the new ones in, but you don’t actually need (more...)