Hi,
I just came across the query visible_to_system in SystemGroup_queries.xml:
SELECT MAX(DECODE(VSGM.server_id, :sid, 1, 0)) is_system_member,
VSGM.GROUP_ID id,
VSGM.GROUP_NAME,
VSGM.GROUP_TYPE,
VSGM.CURRENT_MEMBERS,
VSGM.MAX_MEMBERS,
On Tue, May 24, 2011 at 12:14:16PM +, Julian Einwag - rockenstein AG wrote:
I just came across the query visible_to_system in SystemGroup_queries.xml:
SELECT MAX(DECODE(VSGM.server_id, :sid, 1, 0)) is_system_member,
VSGM.GROUP_ID id,
VSGM.GROUP_NAME,
On 24.05.2011, at 14:26, Jan Pazdziora wrote:
Think of it as if you had
(
select :user_id from dual
)
and an outer join of this subselect with that USGP.
The
AND :user_id = USGP.user_id (+)
matches where the USGP.user_id is the same as :user_id, or where
Julian Einwag - rockenstein AG jein...@rockenstein.de writes:
So basically the following in ANSI syntax would be equivalent:
select web_customer.id, web_contact.id
from web_customer left join web_contact on web_customer.id = web_contact.id
and 1 = web_contact.id
I've never been perfectly