Re: Are there any sample DBs with content to load ?

On Feb 21, 2:37 pm, "joel garry" <joel-ga..._at_home.com> wrote:
> On Feb 21, 10:47 am, peter.s..._at_yahoo.com (Peter Swampton) wrote:
>
> > In order to learn some SQL and PL-SQL statements I need one or more sample
> > databases with one or more tables inside.
>
> > Ok, I could create the tables and data records manually.
> > But this would be very unconvenient. Before I reinvent the wheel
> > I could imagine that there is somewhere a sample database to download
> > which I can load into my Oracle installation.
>
> > Does someone here in the forum know such a sample database ?
>
> > Thank you
> > Pete
>
> There is an appendix in the 10g Oracle Database Reference manual that
> lists additionaly database structures you can create, including
> examples.
>
> The script is probably in $ORACLE_HOME/rdbms/admin, though it would
> help if you stated your exact platform and version.
>
> There is also an entire document about installing sample schemas:http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14198/t...
>
> Many posts here and elsewhere (like asktom.oracle.com) include scripts
> for creating tables and data for particular issues. Many people
> require such scripts to work on problems, including many official
> support service requests, so it is a good idea to practice finding or
> making such scripts.
>
> jg
> --
> @home.com is bogus.
> Yow! http://msmvps.com/blogs/spywaresucks/archive/2007/02/18/591493.aspx

Personally, I always find questions like the OP's kind of ironic. A user wants to learn SQL and PLSQL, but doesn't want to write SQL statements to create table structures, load data, etc.

IMHO, the exercise of writing loops to load arbitrary data to a table for which I typed "CREATE TABLE..." is worth it by itself.

Regards,

Steve Received on Wed Feb 21 2007 - 15:09:13 CST