Re: Why doesn't output display SQL statement when using sqlplus in
Date: Tue, 8 Mar 2016 09:03:57 -0700
Message-ID: <56DEF7ED.1040207_at_gmail.com>
I agree that SQL Loader is heavily underutilized, and misunderstood. Few people read that document as well
(http://docs.oracle.com/database/121/SUTIL/toc.htm) and therefore miss the fact that there are tons of practical examples on both SQL*Loader and External Tables. (The doc also discussed Data Pump, Import/Export, ADRCI, Log Miner - all included in the licensed product.)
Browsing through the licensing doc highlights a huge number of capabilities in the database. I wish people would just browse the doc list (docs.oracle.com/database/121/nav/portal_booklist.htm) to become familiar with what is available, so they know where to turn to start asking questions.
Whole pile of free, or 'included in license' stuff that developers and administrators don't know about - and end up costing their org huge buckets of money by buying alternatives or using ineffective work-arounds.
Oh well.
/Hans
On 08/03/2016 8:23 AM, Dave Morgan wrote:
>> From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
>> Date: Mon, 7 Mar 2016 20:25:15 -0700
>>
>> incredible number of useful reporting capabilities in the tool, and it
>> saddens me greatly that there are so few people who actually know and
>> understand the power of SQL*Plus, SQL*Developer and now SQLcl (which
>> does everything that SQLPlus does and a whole lot more - see
>
> The lack of knowledge that bothers me most is about sqlldr.
> The most useful tool for ETL and very few duhvelopers know about it.
>
> YMMV
> Dave
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 08 2016 - 17:03:57 CET