Reputation
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 29 58
Newest
 Caucus
Impact
~983k people reached

7h
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/…
16h
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.
1d
revised Add MS SQL Server to virtual machine in Azure
edited tags
1d
revised MySQL Matching records across tables discrepancies
edited tags
1d
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?
1d
comment Selecting the correct database engine
@miracle173: of course Postgres is an RDBMD (actually an ORDBMS)
1d
comment Best Admin Tool for Postgres
You forgot to mention that Postgres Enterprise Manager is a commercial product and is not an open source tool (which is what Jeevitha is looking for)
1d
comment insert value based on check constraint on another column
There is no mentioning of an array in your question (and an array is still storing multiple values in a single column). You need to add some sample data and a description on how the system should behave with the sample data. As it stands I for one have no idea what you are trying to achieve.
1d
comment Selecting the correct database engine
Postgres fits your list. It has an extremely efficient key/value store, supports JSON (even indexing JSON documents) and has very good SQL support (far better than the mentioned MySQL)
1d
comment Best Admin Tool for Postgres
psql comes to mind. An extensive list is here: wiki.postgresql.org/wiki/…
1d
revised Best Admin Tool for Postgres
edited tags
1d
revised DEFERRABLE INITIALLY DEFERRED in postgres after migration
edited tags
1d
comment insert value based on check constraint on another column
Do not store multiple (comma) delimited values in a single column. Normalize your model instead
1d
revised insert value based on check constraint on another column
deleted 8 characters in body
2d
revised Finding all date ranges that overlap a target date range
edited tags
2d
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)
2d
revised pgAdmin export line overflow on large field
edited title
2d
comment Row with latest timestamp
wiki.postgresql.org/wiki/Slow_Query_Questions
2d
comment Remote connection to oracle database 12c
Sorry I can't see your computers from over here and my crystal ball is broken so I can't see what you did, nor how you configured your Oracle instance, nor how you configured your notebook, nor how your teammates connect to your laptop, nor how your network is setup.
2d
comment Remote connection to oracle database 12c
What happened when "they" tried?