10,382 reputation
11336
bio website
location Munich
age
visits member for 2 years, 11 months
seen 6 hours ago

I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)


Apr
3
comment Problem translating MySQL to PostgreSQL
@GhostGambler: MySQL never ceases to surprise me in what kind of invalid SQL it will run.
Apr
3
comment Problem translating MySQL to PostgreSQL
INNER JOIN work_log w WHERE t.id = w.ticket is completely invalid and I would be very suprised if MySQL was actually running that. The JOIN is missing the actual join condition defined by the ON clause. But Postgres unfortunately does not support the with rollup part
Apr
2
comment How can I speed up a Postgres query containing lots of Joins with an ILIKE condition
Can you do an explain analyze so that we can see the real execution times, rows and costs?
Apr
2
comment How can I speed up a Postgres query containing lots of Joins with an ILIKE condition
There is a way to make ILIKE or LIKE use an index in this case: postgresonline.com/journal/archives/…
Apr
2
comment Oracle: Table or View does not exist in Tree
There is no package named sys.dbms_system so this is expected to throw an error. What are you trying to achieve with that?
Apr
2
comment Version control tool for postgreSQL
Liquibase is quite a good solution. We use it several projects.
Apr
2
comment what should be in tnsnames.ora and sqlnet.ora for a local database?
Is your listener running? What does lsnrctl status show? What is the service name of your Oracle instance? Does the name resolution work for khurram (what does ping khurram return?). Is your Oracle instance running?
Apr
2
comment netca failed during installation of Oracle 12c on Windows
Did you have another Oracle installation on that computer?
Apr
1
comment Oracle Database XE 11.2 Question on how to get started
@ClydeShelton in Oracle the term "database" has a completely different meaning than e.g. in Postgres, SQL Server or MySQL. You very seldomly create mutliple databases (called "instance") in Oracle. Where you use a database in SQL Server or MySQL you'd simply use a different user/schema in Oracle
Apr
1
comment What are the disadvantages of PostgreSQL compared to other DBMS?
You might be interested in this: sql-workbench.net/dbms_comparison.html
Apr
1
comment What are the disadvantages of PostgreSQL compared to other DBMS?
I strongly disagree with "MySQL supports a lot of the SQL functionality that is expected from a RDBMS" - there is a lot that is expected from a modern RDBMS that MySQL does not support: check constraint, window functions, recursive queries, a decent query optimizer and many more.
Apr
1
comment Confused on how a value gets added with the DEFAULT constraint
It it more or less standard, but still different DBMS behave differently.
Apr
1
comment Confused on how a value gets added with the DEFAULT constraint
Which DBMS are you using? Postgres? Oracle?
Apr
1
comment Lost all my Postgres database tables?
Did the "system update" maybe upgrade Postgres as well?
Apr
1
comment Select Into Regexp_replace doesn't write changes into newly generated table
select into .. from .. to create a new table is not defined in the SQL standard. The select into syntax in the standard is only defined for to read a single row into one or more host variables (e.g. in PL/pgSQL). To create a new table based on a select, the SQL standard only defines create table .. as ...
Mar
31
comment Delete Query takes a long time
Show us the query, the indexes defined on it and the execution plan.
Mar
31
comment Where does Oracle Enterprise Manager derive the “User Logon Time” metrics from?
The information I was looking for was available using select * from sysman.mgmt$metric_daily where metric_name = 'Response' and metric_column = 'userLogon'
Mar
31
comment Where does Oracle Enterprise Manager derive the “User Logon Time” metrics from?
@Raj: that's it, thanks a lot. If you add that as an answer, I will accept it
Mar
31
comment Version control tool for postgreSQL
What's wrong with the popular choices like subversion or git?
Mar
30
comment UPDATE CONCAT without duplicates
In general it is a really bad idea to store multiple delimited values in a single column. If you properly normalize your data model you can ensure uniqueness very easily with the appropriate constraint (or index) Btw: which DBMS are you using? Is that Oracle? And if id is a number column you shouldn't compare it to a string '1' is string, 1 is a number.