Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Adding data from SQL*Plus
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.
Regards, Gerrit-Jan Linker Received on Sun Feb 24 2002 - 03:53:08 CST
![]() |
![]() |