Re: How do you copy tables from a CD into a database?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 1 Jun 2001 16:27:26 +0100
Message-ID: <991409248.3447.0.nnrp-13.c30bdde2@news.demon.co.uk>

If it's a SQL script that is just to create, for example, demo tables (much along the lines of the SCOTT/TIGER EMP/DEPT deal), then you just do 'start d:\scripts\createit.sql'.

Without knowing more about what these 'tables' are etc...

Or SQL*Load perhaps if it's just data? Or perhaps you can *generate* SQL from the data file to row-by-row insert it using Perl for example.

"bullseye" <bullseye35_at_deletethefunnies@excite.com> wrote in message news:BfOR6.20$QO5.50068_at_typhoon.nyc.rr.com...
> The Loney & Koch book (The Complete Reference to Oracle 8i, 10th edition)
> comes with a CD ROM.
>
> What is the command in SQL to copy the tables in Appendix A from the CD
into
> my Oracle database? (The text that makes up the book is copy protected.
> The Appendix is available to be copied; so says the book.)
>
>
Received on Fri Jun 01 2001 - 10:27:26 CDT