10,392 reputation
11437
bio website
location Munich
age
visits member for 2 years, 11 months
seen 11 mins ago

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


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.
Mar
30
comment How to insert default values to a table with not null columns?
How can you not know the number of columns of a table? Btw: the nullable attribute is independent of the default value of a column.
Mar
30
comment Organizing Postgres Databases
You can edit the the input field of the "Groups" dropdown. Just enter a non-existing name in there to create a new group
Mar
28
comment Where does Oracle Enterprise Manager derive the “User Logon Time” metrics from?
@Raj: but that doesn't explain where it is stored and in which system view this is available.
Mar
27
comment MySQL: Use Sysbench on Windows
Seems you need to compile that yourself
Mar
27
comment is there a DB client which supports oracle editions?
I would expect Oracle's SQL Developer to support that.
Mar
26
comment How do I use currval() in PostgreSQL to get the last inserted id?
@leonbloy: the insert as shown, will not create more than one row. But you are right: if you run an insert that inserts more than one row (e.g. insert into .. values (...), (...)) then you can not use currval() as shown.
Mar
25
comment Purpose of Nonclustered indexes in SQL Server 2012
You might be interested in this: use-the-index-luke.com/blog/2014-01/…
Mar
25
comment SQL Where Clause Efficiency
Check the execution plan and you'll see
Mar
24
comment Recover the postgres data if hard drive fails in CentOs 6
Restore your backup
Mar
24
comment How to know DB user?
select user from dual will tell you.
Mar
22
comment How do I access a result set from a StoredProcedure… in another StoredProcedure
The only thing that comes to mind is using temp tables to "transfer" the data from one procedure to the other.
Mar
22
comment How to do WHERE x IN (val1, val2,…) in plpgsql
WHERE col0 = ANY (intarray)
Mar
21
comment How to config Enterprisedb work with PostgresXC ?
I don't think that is possible. PostgresXC uses a different code base as the normal Postgres versions (including EnterpriseDB) so you can only create a PostgresXC cluster using PostgresXC. What exactly are you trying to do?
Mar
21
comment Which RDBMS do return better error messages?
In my opinion Postgres' error message are much clearer.
Mar
20
comment How to grant select on a view … based on IP adress?
The only thing I can think of, is to write a function that checks the client's IP address and then runs different SELECT statements based on that.
Mar
20
comment INSERT using results of CTE INSERT to provide unique id values
You need to join ins and t3