Question

select
wu.ACCOUNT_NUMBER as WS_ACCOUNT_NUMBER,
wu.LIFETIME_REVENUE as WS_LIFETIME_REVENUE,
wu.FIRST_NAME||   ||wu.LAST_NAME as WS_ACCOUNT_NAME,
wu.PRIMARY_EMAIL as WS_ACCOUNT_EMAIL,
wu.TIME_CREATED as WS_ACCOUNT_TIME_CREATED,
wuu.URL as BUSINESS_URL
from
WUSER wu
left outer join WUSER_URL wuu on wu.ACCOUNT_NUMBER = wuu.ACCOUNT_NUMBER

where
wu.ACCOUNT_NUMBER = 123456789;

屏幕上显示的URL是超链接,应当把我们带到网站点击。问题在于,它只是在《Oracle db》中附有《吉大港山区议定书》的情况下才运作。

for example, it works when the url in db is http://www.google.com or http://google.com but it FAILS when the url is google.com or www.google.com

我们的客户非常具体地了解这一要求,希望能够在没有吉大港定居许可证的情况下绕过网站。

** 可能的解决办法是什么? Can 我写了一个有条件的字句,以记录,如果存在吉大港山区,如果没有,则将记录下来。

如果是,请告诉我,**

!

Answer 1

您是否能够核对数据,然后插入<代码>。 HTTP:

采用<代码>的有条件代码在护堤前,......

CASE WHEN UPPER(wuu.URL) LIKE  HTTP://% 
THEN wuu.UR
ELSE  HTTP://  || wuu.URL
END

(It s only on several lines to make it easier to read.)

友情链接