I'm facing a trouble when firing two oreplace quries.
Queries are as follows:
SELECT OREPLACE('TD13.1 is the current version', '13.1'); - following error : Select failed 5589 : Function OREPLACE does not exist.
SELECT OREPLACE('TD13.1 is the current version', '13.1', '14.0'); - Works fine
anyone knows the issue?
also I tried firing the first one(the one that's having an error in our DEV BOX and it wokrs fine. Both queries works fine.)
This is in our QA box. Both boxes have the same version of TD.
Any help will be greatly appreciated. :)
I have one table which consists of 2 columns emp_no and emp_name but in the emp_name column the emp name is stored as R.A.M.A.
I need the output to be displayed as RAMA when i select from the table.
Can anyone please let me know how can i get the same.