Oracle query syntax
Posted on 2013-06-12
Im trying to figure out what Im doing wrong here
select 'PAGES' as Bucket,FUNC_OMNI_DEPT_PAGE_OWNER(a.PAGE_ID) as Topic,
'CONTENT_CHANGE' as subTopic,
PAGE_TITLE as Headline,
'web page content changed on ' || LAST_UPDATE as Summary,
----THIS IS RETURNING BLANKS(NULLS?)
(select link_id from omni_ent_link where link_type='INTRANET' and link_url like '%?page=' || a.PAGE_ID and rownum=1 and link_id is not null) as Link_ID
I guess my question is why is this returning values that are blank or NULL??
'and link_id is not null'
PLEASE HELP!!! Thanks