I am not sure I understand your question. You need to articulate the question a little differently as it does not make sense in its current form. You do not copy table into SQL as SQL is just a language to define or manipulate data. You may want to copy table into a database using SQL. Now, I have some questions for you.
- Do you have a table creation script in the floppy disk that you need to run against an Oracle database?
In that case, say if your script is named myscript.sql, at the SQL*Plus prompt you can type "start a:myscript.sql" or "@a:myscript.sql."
- Do you have data in the floppy disk in flat files that you need to load into an Oracle table in the database?
In that case you can use SQL*LOADER to load the data or you can create an external table based on the file in the floppy disk. I have provided an example below as to how to create an external table based on a flat file. In your case, you may want to move the file to a directory on the database server side.
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.