Reputation
4,597
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
7 17 31
Newest
 Electorate
Impact
~263k people reached

14h
comment DB2 connection rejected with JDBC and ODBC
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
Aug
28
comment Running a SQL Server query with as little impact as possible
Seems to me your current monitoring system is inadequate if it doesn't have such basic metrics readily available.
Aug
27
comment How to improve this query so it'll run quicker
What are your table definitions, including indexes? What's the execution plan?
Aug
26
comment Step by step connect to SQL Server 2014 from Oracle 12c and vice versa
You'll need Oracle Gateway or similar technology.
Aug
25
comment Case When over 2 columns return results into 1 output column
Do you mean that if either q20 or q46 have an 8 or a 9, you want Promoter to be 1? And in all other cases it should be 0?
Aug
21
comment I want a select to give me id's that are not in a consecutively order
This syntax isn't going to work on Oracle.
Aug
12
comment moving large PostgreSQL/PostGIS database
Buy a bigger disk? 1Tb costs next to nothing these days.
Aug
4
comment How can I call a remote User Defined Function?
Is your function called getvalue or getacid? Also, you're linking to an Oracle database so I'm presuming the syntax of the query you pass to openquery must conform to Oracle syntax. In this case you will need to add ` from dual` to the query.
Jul
31
comment Why would one need multiple instances of same Oracle database?
This doesn't answer the question. The question is about opening one database with multiple instances, ie RAC.
Jul
30
comment Storing Large Nested Objects
JSON has better write speed. I'm guessing JSONB will have better read speed, but it should be very close. Why don't you test both and report back?
Jul
29
comment Select using a different value than id on join
Why is that not correct? What result is it giving? What result do you expect or want?
Jul
24
comment Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause
Yes, you can update views -- at least in most DBMSes.
Jul
24
comment Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause
Can you rename the table(s) and replace the table(s) with view(s) that simply do select * from <underlyingtable> order by <column>?
Jul
23
comment Get rows changed between two dates (latest and previous)
in finds values in a set, not in between two values. For that you would need between <a> and <b> but that won't work with a subquery in this way.
Jul
23
comment Converting Legacy SQL Server 2005 Stored Procedure to Transaction based for parallelism
Without knowing your data, structures and code we can't really help you. Voting to close.
Jul
22
comment How do I convert a datetime column from SQL Server 2014 to Oracle 11g using ogr2ogr?
It seems to me that your problem stems from the fact that you are converting the datetime column to a string and then relying on the Oracle session's NLS settings to convert that string to an Oracle date. I'd check what your NLS settings are to see if it matches the format you are using in the date-stored-as-a-string.
Jul
21
comment Oracle ODBC Driver, Tables and Columns Remarks
I think you might be right, unfortunately.
Jul
21
comment Oracle ODBC Driver, Tables and Columns Remarks
Which platform are you on?
Jul
21
comment cannot delete db table
And the real take-home from all of this is: Don't delete .frm and .ibd files by hand.
Jul
21
comment Can I use OpenLDAP to authenticate users in Oracle?
Please don't create link-only answers.