Re: Transitioning from Informix to Oracle

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 1 Jun 1999 10:07:57 -0400
Message-ID: <7j0p99$mkf$1@autumn.news.rcn.net>

Hi Jorge,

Oracle does not have a direct equivalent to Informix's UNLOAD command. Just use SQL*Plus and do a SET COLSEP '|' followed by a SELECT * FROM <tablename>;

regards

Jerry Gitomer

jorget_at_e4dc.hf.intel.com wrote in message <374EDA60.26B1BB3F_at_e4dc.hf.intel.com>...
>Just started working with Oracle after working with Informix for many
>years. I understand Oracl has a sql loader which is similar to
>Informix's High Performance Loader. However, I cannot seem to find a
>way to unload the data in Oracle as I can with the Informix HPL Is
>there another tool ?
>
>Thanks,
>
>Jorge
>
Received on Tue Jun 01 1999 - 09:07:57 CDT