Reputation
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
4 34 65
Newest
 Nice Answer
Impact
~1.3m people reached

Jul
31
answered Selecting records where date range is current year minus #years
Jul
31
comment Selecting records where date range is current year minus #years
The question is tagged oracle. There is no dateadd() function in Oracle.
Jul
31
revised Minimum value on most recent date per account MS ACCESS SQL
edited tags
Jul
31
revised Postgres - Error while adding constraints
edited tags
Jul
31
comment Optimise huge Postgres table for fast read
Essentially all DBMS use a some kind of a tree to represent an index ("B-Tree" - balanced trees). I'm not aware of any DBMS that does this differently (for standard indexes). Postgres' indexes are explained in the manual: postgresql.org/docs/current/static/indexes.html
Jul
31
comment Optimise huge Postgres table for fast read
Which is essentially the same thing as creating the index on the MD5 sum suggested by Frank. A lookup on an index is a binary search as well
Jul
31
comment Recommended Database(s) for Selecting Random Rows
So how do you select the random row? Show us your query, table definitions and the explain plan.
Jul
31
comment Minimum value on most recent date per account MS ACCESS SQL
The example is actually standard SQL - no T-SQL specialties in there. It will run without any change on Oracle, Postgres and DB2
Jul
31
revised Minimum value on most recent date per account MS ACCESS SQL
edited tags
Jul
30
comment Lower() vs ilike on postgresql
"AFAIK there is no way to index a case-insensitive pattern match at this time" - depesz.com/2011/02/19/waiting-for-9-1-faster-likeilike and postgresonline.com/journal/archives/…
Jul
30
comment How Do you add multilanguage support in oracle 12c post installation?
So you are not looking for multi language support but for a different character set support. The character set cannot be changed once the database have been created. Bu you should be able to store those characters in a NVARCHAR2 column (N = National Character Set). That defaults to a multi-byte character set. If you really, really need to store that in a VARCHAR2 column. You will need to dump the existing data, re-create the database and the import the data again.
Jul
29
revised Add MS SQL Server to virtual machine in Azure
edited tags
Jul
29
revised MySQL Matching records across tables discrepancies
edited tags
Jul
29
comment How Do you add multilanguage support in oracle 12c post installation?
What exactly do you want to achieve? Get error messages in a non-english language?
Jul
28
revised Finding all date ranges that overlap a target date range
edited tags
Jul
28
comment Finding all date ranges that overlap a target date range
If you are limited to Oracle and SQL Server you should not have stated that the "choice of RDBMS is not fixed". Btw: Postgres does qualify as a "standard DBMS". Postgres range types are extremely efficient and powerful. Neither Oracle nor SQL Server has anything like that (including unique constraints on them)
Jul
28
revised pgAdmin export line overflow on large field
edited title
Jul
28
revised pgAdmin export line overflow on large field
edited tags
Jul
28
comment pgAdmin export line overflow on large field
The truncation of the value is not done by Postgres, but by pgAdmin (the client application). Other SQL clients might be better at this. I don't use pgAdmin, but I recall other questions regarding this, and I think there is an option somewhere that limits the amount of data displayed to the user. pg_dump can create a valid plain SQL dump for this.
Jul
28
answered How can i get list of postgresql database through php or using just sql query?