Reputation
14,636
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 28 54
Newest
 Yearling
Impact
~857k people reached

18h
reviewed Reject Is there any way to retrieve “Messages” in SQL Server through JDBC?
23h
revised Postgres 9.4 - How to really grant all privileges on a database to another user?
edited tags
1d
comment Conditionaly query in postgresql function
You can't have two parameters with the same name. And id isn't a standard data type. Did you create a domain/type with that name?
1d
answered PostgreSQL: a Login Role which can select from any Views
1d
comment Dividing values from a single column into 2 based on a rule
Which DBMS are you using? Postgres? Oracle?
1d
comment Left Outer Join doesn't give expected result. What am I missing?
b.fld will be null if the outer join does not find a corresponding row.
1d
revised PMA-SQL-ERROR while importing databse in xampp
edited tags
2d
comment Postgres Query Optimisation (Rails App)
For a statement processing all rows of a table, there is not much you can do - indexes will never help for that. If you are on 9.4 already you might try to use the new filter() expression instead of the case - sometimes that improves the performance (but then not much I would assume)
May
20
comment how to migrate data between two distincts tables
If the new table is in a different database: export the data using a COPY and an appropriate SELECT statement. Then import the data in the target database e.g. using COPY again. If the new table is in fact in the same (physical) database, you can do an insert into new_table ... select ... from old_table (provided you can do the "transformation" in pure SQL)
May
20
revised INSERT DATA The database disk image is malformed
edited tags
May
20
answered Oracle: How to get a list of CTXSYS.CONTEXT indices?
May
19
revised How can I calculate the difference between my time column in seconds?
added 17 characters in body
May
19
revised Transaction block on coordinator
deleted 9 characters in body
May
18
comment Does MariaDB support schema changes inside a transaction?
from the manual: "DDL statements (CREATE, ALTER, DROP) [...] cause an implicit COMMIT"
May
18
revised Best way to remap database login to new database user and keep previous database user
edited tags
May
18
comment install GUI for Oracle Linux 7.1 after I installed with default settings with no gui
I'm voting to close this question as off-topic because this belongs on superuser
May
18
revised How to serialize on SQL server metadata?
edited tags
May
18
comment How to set correctly utf8 on oracle?
That's your SQL client (presumably SQL*Plus) which cannot display those characters. You need to use a font that can display them and in case of SQL*Plus you also need to switch the command line from which you start SQL*Plus to UTF-8 (I think that is done through chcp 65001)
May
18
revised Fetching data from View with more number of columns
added 33 characters in body
May
17
answered Multi-row uniqueness constraint, checking a field has one of two values