meta user
network profile
| bio | website | |
|---|---|---|
| location | Munich | |
| age | ||
| visits | member for | 2 years |
| seen | 19 mins ago | |
| stats | profile views | 722 |
I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)
|
Apr 5 |
comment |
Table Creation Fail in Oracle 10g Express Please show us the SQL you have executed (add it to your question). Posting code or error messages as images is not very useful. |
|
Apr 5 |
comment |
Discover SQL Time on Oracle10g "causing duplication of data": you should create a unique index on those columns that should be unique. Then the second call would throw an error and you don't have "duplicates". A PK on a generated number is never enough, you should always have a unique index on the real (i.e. "business") primary key. |
|
Apr 4 |
comment |
Is this an appropriate development environment MySQL backup strategy? IMHO it is much cleaner to put the original SQL scripts to create the database under version control. |
|
Apr 3 |
comment |
Compare a date and a timestamp with time zone with now() in the same query? Are you sure expiration is a timestamp column? Sounds like it's a convertion problem caused by the CAST operator |
|
Apr 3 |
comment |
Is there any way to clear all tables using Liquibase? @gilaras: if a dropAll() takes that long, I would suspect some locking, e.g. transactions still referencing the tables that are to be dropped. If that is the case you would have the same problem with truncate. |
|
Apr 2 |
comment |
Request suggestion for a database between MySQL and Postgresql +1 for the Wikivs link. Very nice comparison |
|
Apr 1 |
comment |
Foreign key constraints with MySQL/InnoDB yes, absolutely |
|
Apr 1 |
comment |
Foreign key constraints with MySQL/InnoDB Actually in some DBMS, SELECTs can be influenced by FKs as the optimizer might remove redundant joins based on FK information - this is usually used to improve the performance of the statement. MySQL is not smart enough to do an optimization like that as far as I know. |
|
Mar 29 |
comment |
SQL Server equivalent to MySQL UNIQUE index? Is there a difference between a unique index and a unique constraint for SQL server (regarding the multiple NULLs) |
|
Mar 29 |
comment |
No luck trying out Firebird 3.0 I'm not planning to use it in a production environment. I just want to play around with it checking out the new 3.0 features. Version 2.5 works without problems so I guess my problems are simply related to the fact that it's still an alpha version. Guess I'll just wait until it's stable |
|
Mar 29 |
comment |
How to convert a MySQL database to PostgreSQL? Start here: wiki.postgresql.org/wiki/… |
|
Mar 29 |
comment |
How to toggle a boolean field by sql in postgresql? Not "maybe", definitely ;) |
|
Mar 28 |
comment |
Oracle explain for cascading delete is wrong @AdamMusch: thanks, good to know. |
|
Mar 27 |
comment |
Storing date as integer (numeric), what are the advantages I only see disadvantages in this approach no advantage whatsoever |
|
Mar 27 |
comment |
“Table of Constants” - is this common practice? The view solution is pretty nice. It also protects agains accidental changes to the "constants". |
|
Mar 26 |
comment |
SQL database with temporal data The correct notation for an ANSI date literal is DATE '1970-01-01'. Note the single quotes around the actual date. |
|
Mar 25 |
comment |
Return a fully dynamic table from an Oracle function This link here seems to have a solution although only with a limited set of columns: database.itags.org/oracle/108132 |
|
Mar 25 |
comment |
Update statement errors, parenthesis, failed validation ORACLE So, your question is only about the UDATE statement? |
|
Mar 24 |
comment |
Update statement errors, parenthesis, failed validation ORACLE I don't see a trigger, only an UPDATE statement. |
|
Mar 24 |
comment |
Return a fully dynamic table from an Oracle function I don't think this is possible in Oracle. |
