Home » SQL & PL/SQL » SQL & PL/SQL » how we can do manipulations like aggregration functions or any manipulation
how we can do manipulations like aggregration functions or any manipulation [message #262615] Mon, 27 August 2007 21:54 Go to next message
kumar.bethamcherla
Messages: 5
Registered: August 2007
Junior Member
how we can do manipulations like aggregration functions or any other manipulations before data being loaded into oracle database
without using informatica
Re: how we can do manipulations like aggregration functions or any manipulation [message #262629 is a reply to message #262615] Mon, 27 August 2007 23:07 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What is informatica?
Re: how we can do manipulations like aggregration functions or any manipulation [message #262658 is a reply to message #262615] Tue, 28 August 2007 00:49 Go to previous message
transfer
Messages: 53
Registered: August 2007
Location: transfer
Member
Kumar,

If you are in version 9iR2 or later, you can use "external tables".

The idea of an external table is that a flat file present on the Oracle server can be described and used as a read-only table. You can then use SQL to change the data before loading it. In many cases, this is preferable to the SQL Loader routine.

Once the external table is defined, you can load the data using CREATE TABLE ... AS SELECT or INSERT INTO ... SELECT just as you would if the source table were in the database.

Complete example and nice explanation here :
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6611962171229

Regards, Stew
Previous Topic: Forgot login info
Next Topic: how to convert a timestamp with time zone into a date?
Goto Forum:
  


Current Time: Thu Dec 08 16:12:28 CST 2016

Total time taken to generate the page: 0.16092 seconds