Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: scripts to create and populate tables

Re: scripts to create and populate tables

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Tue, 22 Sep 1998 16:52:43 +0100
Message-ID: <6u8h3g$188$1@schbbs.mot.com>


Look for tables owned by SCOTT/TIGER in your installation. These seem to appear in many installations I've visited in my time and are the ORacle training tables which are designed to do the sorts of things you want.

I imagine they are around somewhere on your installation media, if not already created. Two table names I remember are EMP and DEPT. Can anyone remember the others?

--
Alan D. Mills

>I'm in need of sql scripts that create and populate tables. I'm trying to
>come up to speed as quickly as possible and I need tables with real world
>data, eg. data for outer joins, self joins and the like. Of course I
could
>generate these myself, but If I can find something already available with
>various real world type data it would save me a lot of time.
>
Received on Tue Sep 22 1998 - 10:52:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US