This article explains how to insert data into an Oracle table from Excel or a flat text file using Import.
After a long time I am back on C# Corner with a new article.Today I will explain how to put Excel or text file data into an Oracle table. You can do this easily in SQL Server with a Copy (Ctrl+C) of the data from Excel then open the target table into edit mode and Paste (Ctrl+V). Done.But this will not work in Oracle.In an Oracle database you can do it using the import command. I will show you each and every step with snapshots.Step 1 : Open TOAD.Step 2 : Write the following query to create a test table:
Introduction to Mongo DB