01. The first step

  • Desc first emp; Look at the structure of the EMP table to see what fields and what data types there are.
  • Create an Excel table and fill the header with the same field names. The data format below the header must be the same as the data type in the EMP table.

02. The second step

  • Save the Excel sheet as the file type of the picture.

3. The third step

4. The fourth step

05. Step 5

06. Step 6

07. Step 7

— — — — — — — — — — — — — — — — — — — — — — — — — — — small complement — — — — — — — — — — — — — — — — — — — — — — — — — –

Above step <02. Step 2 >

  • You can also save excel tables as *.csv files of images. Then do the same step 3 – to step 7.
  • *.csv file type import, sometimes PL/SQL does not respond, only to close PL/SQL.