sqlldr syntax question

From: Christopher Zarrella <serge_at_io.com>
Date: Sat, 08 Jun 2002 00:36:22 GMT
Message-ID: <akcM8.170853$9F5.9046993_at_typhoon.austin.rr.com>

We are planning to move from Informix to Oracle. In my research I was surprised to discover that plsql does not support the 'load from' syntax that is prevalent on many databases (eg Informix, Mysql).

I'm looking at sqlldr, sql loader. My question is whether listing the columns of the target table is mandatory even if all of the fields are to be populated? Is ( * ) really not ok?

-- 
Christopher Zarrella
serge_at_austin.rr.com
Linux User

Received on Sat Jun 08 2002 - 02:36:22 CEST

This message: [ Message body ]
Next message: Vissu: "importing triggers"
Previous message: JamesM: "Oracle 8.1.7, Windows XP and file creation errors"
Next in thread: Priyesh Patel: "Re: sqlldr syntax question"
Reply: Priyesh Patel: "Re: sqlldr syntax question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message