I found a subject where I see it is not possible to delete from tpt on Oracle, but I was wondering if :
it's possible to launch Oracle's stored procedures from tpt ?
Or doing updates on Oracle's tables from tpt ?
>>"Is it possible to launch Oracle's stored procedures from tpt? Or doing updates on Oracle's tables from tpt ?"
The short answer: NO.
The long answer: YES.
You will need a wrapper function and more...
It is quite long to explain, but the whole story can be found here (in spanish, as usual):
I am doing Oracle to Terdata SP migartion , could you please guide me how to do and docs,...
1. how to convert the this Rank() funtion in oracle format to TD format, please help me
The RANK is exactly the same in Teradata, there's just a missing table alias directly before WHERE.
Oracle allows omitting that alias, but Standard SQL requires it.
how to convert oracle to teradata this query?