I have some ORACLE SQL query which I need to convert to Teradata compatible.
I am using teradata DB version 13.10.
The query used the replace function but in teradata there is no replace function in teradata. And also I saw if I can install the UDF utility then I can get the Oracle functions. Like oReplace.
But the problem is I do not have any access to install things in DB or also it is difficult for me to contact the DBA out there.
The query in oracle --
select replace(replace(strvalue,'--Major',''),'--Mainor','') as MyValue from TableName where startdate > 'somedate'
Can you help me converting this query to TD compatible.
Thanks in advance.
I can't help you with 13.10, but it may interest you to know that 14.0 has implemented OREPLACE and many other Oracle-like functions as built-in functions.