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: Adding data from SQL*Plus

Re: Adding data from SQL*Plus

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sun, 24 Feb 2002 09:53:08 +0000 (UTC)
Message-ID: <a5ad63$9pd$1@helle.btinternet.com>


To add rows from SQL*Plus you need to write insert statements. They go like this: Insert into table (col1, col2, col3) values (val1,val2,val3). This is quite tedious to do. If you like to have an easier way of inserting data into the database why not try SQL*XL. SQL*XL allows you to prepare the data in Excel and then post it to Oracle for you with a few mouse clicks.

SQL*XL is an addin for Excel that allows you to use Excel as a front-end to Oracle databases.

http://www.oraxcel.com

Regards, Gerrit-Jan Linker Received on Sun Feb 24 2002 - 03:53:08 CST

Original text of this message

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