Reputation
19,980
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
4 37 70
Impact
~1.5m people reached

Oct
28
comment Standards when writing SQL?
Both ;) If I have the choice between a proprietary solution and the DBMS solution and both are identical, I prefer standard SQL (e.g. case instead of decode()). If a DBMS specific feature makes things faster, I use that e.g. distinct on() instead of a solution involving window functions.
Oct
28
revised Teradata view with “With Clause” syntax
edited tags
Oct
28
comment Postgres Installed in Linux (RHEL) and trying to access / connect using pgadmin (Windows)
I'm pretty sure the error message contains more information than just "Failed". Please edit your question and add the exact error message.
Oct
28
revised Postgres Installed in Linux (RHEL) and trying to access / connect using pgadmin (Windows)
added 49 characters in body
Oct
28
awarded  sql
Oct
27
revised Trigger in MySQL upon changing stock status
edited tags
Oct
27
answered How to create a dynamic comment to an object?
Oct
27
comment How to create a dynamic comment to an object?
postgresql.org/docs/current/static/catalog-pg-description.html
Oct
27
comment How to create a dynamic comment to an object?
"Is dynamic SQL the only option" - yes. You will need to create a function that does this.
Oct
27
comment Is it recommend to create a table for addresses?
"to store all the addresses of the person" seems to indicate that you have more than one address per person. In that case, yes it would be better to create an additional table
Oct
27
comment How to find current setting of “FORCE PARALLEL QUERY” in Oracle
Works fine. The select from v_$mystat is not needed btw. Where Sid = userenv ('SID') is working just fine. I also used v$ses_optimizer_env instead of Sys.V_$ses_Optimizer_Env
Oct
27
accepted How to find current setting of “FORCE PARALLEL QUERY” in Oracle
Oct
27
comment Is Oracle DB licensing needed for a test environment?
I was always confused by this "for testing and development" part of the OTN license. What if I develop an application that never goes into production in my environment, because I deliver the binaries to a customer who then puts it into production (and does have an Oracle license)
Oct
26
comment what is the SQL Query for Split one column into two column based on two different conditions in SQL
Which DBMS are you using? Postgres? Oracle?
Oct
26
comment Can I make something similar to a makefile for psql?
So what? Liquibase is just a command line tool
Oct
26
comment Can I make something similar to a makefile for psql?
Check out tools like Liquibase or Flyway.
Oct
26
revised Can I make something similar to a makefile for psql?
added 20 characters in body
Oct
26
comment 0xdbe doesn't display tables
Which JDBC driver and version are you using? jTDS or the Microsoft driver?
Oct
26
revised Full outer join problems
edited tags
Oct
26
comment Foreign key: in which table?
This is the correct way of modeling it.