2,275 reputation
514
bio website
location Austria
age 57
visits member for 3 years, 3 months
seen 15 mins ago

2m
reviewed Reject suggested edit on Difference data between adjacent rows
13h
reviewed Approve suggested edit on SQL statement that return Component in each Order
19h
reviewed Approve suggested edit on Replace a materialized view in Postgres
21h
comment Stop NLS settings in init.ora getting overridden by environment variable
What kind of client are you running? Does it run on the same machine as the database instances? Why are you not able to change the environment settings? Maybe you can describe your system and your problem a little bit more in detail.
21h
comment Stop NLS settings in init.ora getting overridden by environment variable
Maybe you can use a login trigger to set your session parameters.
21h
comment Stop NLS settings in init.ora getting overridden by environment variable
You should add this to your question. The NLS_SESSION_PARAMETERS shows the session parameter values. These are defined by the environment variables. What do the NLS_INSTANCE_PARAMETERS and NLS_DATABASE_PARAMETERS show?
21h
comment Stop NLS settings in init.ora getting overridden by environment variable
What do you mean by "we still get 'GREGORIAN' for NLS_CALENDAR"
2d
revised Why MAX() of SUM() giving wrong output?
typo
Aug
27
revised Duplicate Statistics?
edited title
Aug
27
awarded  Quorum
Aug
27
reviewed Approve suggested edit on Technical documentation for Replication
Aug
27
comment Find active values of SQLNET.ORA parameters on server
@Raj: as far a I know the sqlnet.ora is read by a new shadow process. So if you enable server side sqlnet tracing this will be enabled for all sessions that are created after you changed the sqlnet.ora until these processes end, even if you disable sqlnet tracing in the sqlnet.ora file after a while.
Aug
26
reviewed Approve suggested edit on converting then outputting varbinary(max) FOR XML PATH
Aug
24
reviewed Approve suggested edit on converting then outputting varbinary(max) FOR XML PATH
Aug
24
comment Why MAX() of SUM() giving wrong output?
@babu: thank you, fixed
Aug
24
revised Why MAX() of SUM() giving wrong output?
repaired query and some additional info
Aug
24
revised Why MAX() of SUM() giving wrong output?
added 234 characters in body
Aug
24
comment Why MAX() of SUM() giving wrong output?
your query simulates the HAVING clause by a WHERE clause. Maybe the usage of a HAVING clause would more directly express it.
Aug
24
comment Why MAX() of SUM() giving wrong output?
@babu: thank you, I changed it.
Aug
24
revised Why MAX() of SUM() giving wrong output?
the final section uses a wrong query. reference to a comment. more details how to construct the query