2,324 reputation
517
bio website
location Austria
age 57
visits member for 3 years, 4 months
seen 23 hours ago

Oct
20
answered Configuring sqlnet.ora and tnsnames.ora on the client side
Oct
20
comment Configuring sqlnet.ora and tnsnames.ora on the client side
The difference of oracle instant client and the traditionally installed oracle client is in how they are installed. The Oracle universal installer maintains e registry which the instan client does not have. but the same softwre components are the same independen of the method you use to install. If you use the jdbc oci driver then you use a layer above the you use the layer above oracle oci client (which is used the oracle client libraries that use
Oct
20
comment Configuring sqlnet.ora and tnsnames.ora on the client side
@Phil: DIAG_ADR_ENABLED=OFF is related to logging
Oct
20
comment Configuring sqlnet.ora and tnsnames.ora on the client side
+1 that is true for all environment variables: they are inherited from a process (e.g. shell ) to its subprocesses (e.g. application program started by the shell that starts the process)
Oct
15
reviewed Approve suggested edit on Design a queue and table in SQL Server as per below data
Oct
15
reviewed Reject suggested edit on sql server service broker
Oct
10
comment Need Query for th problem in oracle
@a_horse_with_no_name: thanks for the links
Oct
10
comment Need Query for th problem in oracle
-1 for both question and answer: you pose a question with almost no information, you dont't answer the questions in the comments and you provide an answer that contains a lot of errors (wrong resilt for negative values, groups with more than one 0 value will displayed multiple times, ...)
Oct
10
comment Need Query for th problem in oracle
@a_horse_with_no_name: how does one create an own aggregate query? But writing a function may be an overkill the data can be queried using the known aggregate functions in a performant way
Oct
10
comment Need Query for th problem in oracle
your case statement is strange, but using exp/sum/log can be the right approach. But this depends on your needs. what you need is the special treament of tactos that are zero or negative.
Oct
10
comment Need Query for th problem in oracle
That isn't an answer to my questions :-)
Oct
10
comment Need Query for th problem in oracle
@a_horse_with_no_name: can you provide a reverence?
Oct
10
revised Need Query for th problem in oracle
formatting query
Oct
10
comment Need Query for th problem in oracle
How large could that products become? Are these integer values or arbitrary numbers? Can you tell us why you need such products?
Oct
10
revised Need Query for th problem in oracle
formatting table
Oct
9
reviewed Reject suggested edit on logical reads vs. scan count
Oct
8
reviewed Edit suggested edit on how to select top ID from join operation and staging tables
Oct
8
revised how to select top ID from join operation and staging tables
Formatted SQL query
Oct
7
reviewed Approve suggested edit on Alternative way to compress NVARCHAR(MAX)?
Oct
6
reviewed Approve suggested edit on mysql advanced query