| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Populating a database in Oracle 7.3
In article <3506FEB4.3C86_at_ulst.ac.uk>,
Gareth Leonard <leonard-gg_at_ulst.ac.uk> wrote:
>How do I populate a database in oracle 7. I am using Oracle enterprise
>manager and do not understand how to get the data stored within my
>tables. Is therea simple way of doing this
>
>Gareth
There are a number of ways of doing this, depending on whether you already have data and in what form. The product SQL*Loader can handle a variety of formats from text files. You can use SQL*Plus and a bunch of insert statements like insert into yourtable values ('1','2','3');. You can use utilities like perl and frontends of various sorts. There is an embarrassment of riches. So, to get a decent answer, you must state what you have and what you want to do with it.
-- These opinions are my own and not necessarily those of Information Quest jgarry@eiq.com http://www.informationquest.com http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA!Received on Wed Mar 11 1998 - 00:00:00 CST
![]() |
![]() |