RE: SQL comparison addition:
I'll try tracing the session. Global.client_dim is just a table with client info and a column that corresponds to client logins to enable row level security. Thanks for the suggestions. As stated earlier..i'll post the resolution. chris -Original Message- Sent: Tuesday, November 11, 2003 4:39 PM To: Multiple recipients of list ORACLE-L You can flush shared pool, optionally, then enable SQL tracing and CBO tracing and check the trace file, anyway you will be asked to do that when you open a tar. What Oracle version do you use? What's the object you're referencing in your query -- global.client_dim? Is it a [partitioned] table, [m]view or synonym for some other object? -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN); SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 And 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 I'm going to open a tar on this. I will email the resolution. ...and check for any more suggestions! :) Chris -Original Message- Sent: Tuesday, November 11, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Chris There is a contradiction below: Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Produces some output. Your original query does not return anything. 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) The obvious differences here are: . TRIM function . probably when you've tried to launch the original query you had pofile functions enabled, when you tried it second time it was disabled. . query rewrite is used (could be, right?) Could you please check the second and third items? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL comparison addition:
Perhaps it's your clients? I've spouted off here before about the MACHINE column of V$SESSION having an extra CHR(0) at then end of it for Winders clients. Maybe something similar's happening to you, but with whitespace (the TRIM in your statement won't lop off CHR(0)). HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Chris Stephens [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Subject: SQL comparison addition: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL comparison addition:
I may be barking up the wrong tree, but humour an old dba... Could you try running the following and post the output? select sys_context('userenv','session_user'), dump(sys_context('userenv','session_user')), a.reports_login, dump(a.reports_login) from global.client_dim a WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Daniel Chris Stephens wrote: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL comparison addition:
SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 -Original Message- Sent: Tuesday, November 11, 2003 11:44 AM To: Multiple recipients of list ORACLE-L I may be barking up the wrong tree, but humour an old dba... Could you try running the following and post the output? select sys_context('userenv','session_user'), dump(sys_context('userenv','session_user')), a.reports_login, dump(a.reports_login) from global.client_dim a WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Daniel Chris Stephens wrote: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL comparison addition:
But wouldn't whitespace show up when I select '|'||reports_login||'|' ?? -Original Message- Sent: Tuesday, November 11, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Perhaps it's your clients? I've spouted off here before about the MACHINE column of V$SESSION having an extra CHR(0) at then end of it for Winders clients. Maybe something similar's happening to you, but with whitespace (the TRIM in your statement won't lop off CHR(0)). HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Chris Stephens [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Subject: SQL comparison addition: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL comparison addition:
I don't see any extraneous characters in sys_context('userenv','session_user')either. But the trailing null in v$session.machine for Windows connections is a known problem. Bug 646174 shows version 8.1.5. I tried in 9.2.0.1. It still exists: SQL select dump(machine) from v$session where machine = 'ICONIX\YONGHUANG'; no rows selected SQL select machine from v$session where machine like 'ICONIX\YONGHUANG_'; MACHINE ICONIX\YONGHUANG SQL select dump(machine) from v$session where machine like 'ICONIX\YONGHUANG_'; DUMP(MACHINE) Typ=1 Len=17: 73,67,79,78,73,88,92,89,79,78,71,72,85,65,78,71,0 Yong Huang --- Chris Stephens [EMAIL PROTECTED] wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL comparison addition:
Hmmm... I was expecting to see something like Yong writes about. The only suggestion I have is to use DUMP() the next time this happens and figure out where the two strings differ. Daniel Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 -Original Message- Sent: Tuesday, November 11, 2003 11:44 AM To: Multiple recipients of list ORACLE-L I may be barking up the wrong tree, but humour an old dba... Could you try running the following and post the output? select sys_context('userenv','session_user'), dump(sys_context('userenv','session_user')), a.reports_login, dump(a.reports_login) from global.client_dim a WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Daniel Chris Stephens wrote: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL comparison addition:
Chris There is a contradiction below: Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Produces some output. Your original query does not return anything. 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) The obvious differences here are: . TRIM function . probably when you've tried to launch the original query you had pofile functions enabled, when you tried it second time it was disabled. . query rewrite is used (could be, right?) Could you please check the second and third items? -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 -Original Message- Sent: Tuesday, November 11, 2003 11:44 AM To: Multiple recipients of list ORACLE-L I may be barking up the wrong tree, but humour an old dba... Could you try running the following and post the output? select sys_context('userenv','session_user'), dump(sys_context('userenv','session_user')), a.reports_login, dump(a.reports_login) from global.client_dim a WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Daniel Chris Stephens wrote: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL comparison addition:
SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN); SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 And 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 I'm going to open a tar on this. I will email the resolution. ...and check for any more suggestions! :) Chris -Original Message- Sent: Tuesday, November 11, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Chris There is a contradiction below: Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Produces some output. Your original query does not return anything. 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) The obvious differences here are: . TRIM function . probably when you've tried to launch the original query you had pofile functions enabled, when you tried it second time it was disabled. . query rewrite is used (could be, right?) Could you please check the second and third items? -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. SYS_CONTEXT('USERENV','SESSION_USER') DUMP(SYS_CONTEXT('USERENV','SESSION_USER')) REPORTS_LOGIN -- DUMP(A.REPORTS_LOGIN) REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 REPORTS_DELTA Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65 -Original Message- Sent: Tuesday, November 11, 2003 11:44 AM To: Multiple recipients of list ORACLE-L I may be barking up the wrong tree, but humour an old dba... Could you try running the following and post the output? select sys_context('userenv','session_user'), dump(sys_context('userenv','session_user')), a.reports_login, dump(a.reports_login) from global.client_dim a WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; Daniel Chris Stephens wrote: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other