11,727 reputation
11946
bio website
location Munich
age
visits member for 3 years, 4 months
seen 15 mins ago

1d
awarded  Explainer
1d
revised Select Multiple Values from Same Column; one sql statment
added 8 characters in body
2d
revised How to pass ouput parameter values in mysql procedure
added 46 characters in body; edited tags
2d
comment Something similar to SQL Server's DACPAC (for customizable deployment) for Oracle database
I don't see why you would need an extra tool for that. Just create a SQL script and run it via SQL*Plus.
Sep
28
comment How to combine a default value with a new value?
If really all values should have that prefix, I wouldn't even store that. Create a view that returns the concatenated value. There is no sense in storing data that is always the same thing.
Sep
28
revised How to combine a default value with a new value?
edited tags
Sep
28
comment How to combine a default value with a new value?
Which DBMS are you using? Postgres? Oracle?
Sep
28
comment Prevent gaps while using Identity/sequence object in sql server
"I want to prevent gaps in the primary key column" - why? The value of a primary key - especially an auto generated one - is meaningless. It's only purpose is to uniquely identify a row. And to do that job the value itself is totally meaningless. And gaps are equally meaningless.
Sep
28
comment DIRECT and SORTED in H2 and How to insert data with SORTED technique in H2
In the link you provided (right below the values clause)
Sep
27
comment DIRECT and SORTED in H2 and How to insert data with SORTED technique in H2
"How to insert data with SORTED technique?" - maybe by specifying the sorted keyword as shown in the manual?
Sep
27
comment Postgresql: Domain of two values
I agree with ypercube: range types are the way to go here.
Sep
26
comment How much should I care about prepared statements for simple queries?
When using JDBC a parameterized statement is always a prepared statement.
Sep
26
comment SQL syntax error
Cross post: stackoverflow.com/questions/26063846/mysql-sql-syntax
Sep
26
comment SQL syntax error
Please post the exact error message. That usually indicates the position where the syntax error is.
Sep
24
revised Why wouldn't VACUUM ANALYZE clear all dead tuples?
added 88 characters in body
Sep
24
revised Enterprise database design
edited tags
Sep
24
answered How to change the mount point for a column in postgresql table?
Sep
24
revised How to change the mount point for a column in postgresql table?
added 11 characters in body; edited tags
Sep
23
comment Postgres - Combine similar queries with extra where clause
You can use a CTE to only have the "broader" query once, but you still need to return a single result set.
Sep
23
comment Alternatives for a LEFT OUTER JOIN query
@MarkSinkinson: ah, thanks. I didn't know that.