Manage Learn to apply best practices and optimize your operations.

How to copy tables from floppy disk into SQL

How do I copy tables into SQL from a floppy disk?

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.

  1. 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."

  2. 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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.