Help - Search - Members - Calendar
Full Version: data transformation issue
Oracle DBA Forums > Oracle > Oracle Forum
sathyananda
Hi,

Is there anybody who has done data transformation using Advanced queues or streams.
Our main concerns:
Is it possible to transform and transmit data using streams for example table to table (bi dirctional) having different structure or may be different data type (ex: char to date or numbr to date) if yes then how to transform data because we have seen many documents where they talk about creating a object type or some pictorial representations but nowhere we got proper info.

If any boby having expertise on this please help us.

regards

Satya
Steve
Check out my blog here:

http://www.oraclealchemist.com/oracle/make...y-with-streams/

The second set of commands show an example LCR handler, which is a PL/SQL program that works with the ANYDATA LCR and can be used to perform data transformations.
HAL9000
You can use Streams aq_adm to map individual columns, even from non-matching tables and diverse data stores. The only requirement is that the sender and target columns "match" datatypes.

For working examples, Madhu Tuma describes this process in the Oracle Streams book.

http://www.rampant-books.com/book_2004_2_streams.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.