12,820 reputation
12049
bio website
location Munich
age
visits member for 3 years, 7 months
seen Dec 24 at 13:17

Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
Oracle (the database) will never create a name like "Relationship143" on its own. It was probably one of your tools that did this. Anyway: as it stands, your answer is simply wrong in the context of the original question.
Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
See here for an example: sqlfiddle.com/#!4/27ee6/1
Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
The you created the constraints using double quotes, e.g: alter table ... add constraint "Relationship143" ... "Relationship143" is indeed a different name than RELATIONSHIP143. But "RELATIONSHIP143" and RELATIONSHIP143 are identical
Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
A quoted identifier where all characters are upper case is identical to the same name without quotes (because Oracle stores all un-quoted identifiers in upper case).
Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
No it will not work. Your statement is exactly the same statement the first statement in the question: ALTER TABLE A_DUP_CALLE DROP CONSTRAINT A_DUP_CALLE_UK1;
Dec
24
comment The sum of the distances of all employees and select the top 3
Which DBMS are you using? And please post sample data as formatted text, not as a picture. And you should add the expected output (as formatted text) based on the sample data.
Dec
24
reviewed Looks OK MySQL - Alter table to automatically put in a UUID
Dec
23
revised Server CPU usage Issue
edited tags
Dec
23
reviewed Edit Incorrect syntax near the keyword 'AS'
Dec
23
revised Incorrect syntax near the keyword 'AS'
edit taken from a NAA
Dec
23
revised SQLPlus : default define settings
edited tags
Dec
23
comment Which replication technique to use?
That pretty much only leaves Bucardo as your only choice (or BDR but that is still in beta if I'm not mistaken) wiki.postgresql.org/wiki/…
Dec
23
comment Unable to connect to Oracle from SQL Developer
Can you post the JDBC URL that SQL Developer is using? This could also be a firewall issue.
Dec
23
comment Unable to connect to Oracle from SQL Developer
@AhmadAbuhasna: the tnsnames.ora is not used by SQL Developer as it uses the JDBC thin driver (at least by default).
Dec
23
revised Unable to connect to Oracle from SQL Developer
added 1 character in body; edited tags; edited title
Dec
22
comment How to Select the First (or last) entry for a specific day
Regarding window functions: there is a tutorial in the manual:: postgresql.org/docs/current/static/tutorial-window.html identifiers are case-insensitive in SQL. So AttendanceREcords is the same name as AttendanceRecords or attendancerecords. The SQL standard requires all (unquoted) identifiers to be stored in UPPERCASE. Postgres chose to store them all in lowercase.
Dec
21
comment How to create a temporary table using VALUES in PostgreSQL
from the docs: "CREATE TABLE AS is functionally similar to SELECT INTO. CREATE TABLE AS is the recommended syntax"
Dec
21
revised How to create a temporary table using VALUES in PostgreSQL
added 262 characters in body
Dec
21
comment Possible to get log file with only statements sent to Postgres from my app (and not from psql prompt)?
If you specify an application name when you connect, you can add that application name to the log entry.
Dec
21
comment How to create a temporary table using VALUES in PostgreSQL
select .. into to create a new table is an old non-standard way of doing this and is only supported for backward compatibility. Using the standard compliant create table as should be preferred.