Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 24 48
Impact
~456k people reached

Jul
13
comment Does reporting webservice url contain the function that helps to export the report to the client version?
In broader: please include here the steps/elements of the solution that helps the OP. You might have the idea later to move your page to somewhere else - in this case the link will 'rot', making this answer useless.
Jul
13
comment Oracle Performance on 2 servers
If I see it correctly, the timing involves transporting data over to the client. Can it be that this is the only source of the time difference?
Jul
13
comment How to prevent multiple queries in this case?
As an aside, it's not a very wise idea to name tables with keywords.
Jul
10
comment SQL Join Field and Content
Could you then remove the references to HTML? And possibly add an example output table.
Jul
10
comment SQL Join Field and Content
Are you sure a SQL join will produce HTML for you?
Jul
10
comment Why postgresql pg_dump exports a view as a table?
Is it a materialized view?
Jul
10
comment GRANT USAGE on all schemas in a database? postgres
@a_horse_with_no_name thinking about it, I see currently no reason why it could not be done.
Jul
10
comment Implementing a function written for Postgres 9.4 in Postgres 8.4
According to postgresql.org/docs/8.4/static/sql-createtable.html, the IF NOT EXISTS syntax didn't exist in 8.4 (appeared in 9.1)
Jul
10
comment Implementing a function written for Postgres 9.4 in Postgres 8.4
Just out of curiosity, why cannot you upgrade?
Jul
10
comment Implementing a function written for Postgres 9.4 in Postgres 8.4
Well, the format( is missing from your post - otherwise, you have to concatenate and quote with quote_ident(). But the best suggestion would be upgrading ;)
Jul
10
comment Where is the default postgres user path environment set?
I'm voting to close this question as off-topic because it's a sysadmin problem, thus a topic for SU
Jul
10
comment Update one column based on count of records of grouped value in another column
When providing table designs and sample data, you should include actual CREATE TABLE and INSERT statements, so that anyone trying to answer could easily reproduce your problem.
Jul
9
comment Oracle's (+) notation within function
Do you have any reason for not using the standard syntax?
Jul
9
comment Does running pg_dump on live db produce consistent backups?
Your statements are either indicating a serious bug (did you file a bug report?), a serious bug in the way you dump your database or some misunderstanding. Lacking any facts one cannot decide among these.
Jul
9
comment How to find similar (but different) names with the same soundex value?
@MohamedAshrafAliB it's not a variable but a mandatory table alias for a subquery.
Jul
9
comment How to find similar (but different) names with the same soundex value?
Please give some examples that you'd like to find. How similar is similar?
Jul
8
comment move data folder and drive mysql centos
Would you mind to add an explanation about how this solves the issue?
Jul
7
comment Clob (Swift message) data in Oracle table
And what do you have so far?
Jul
7
comment How to print to console in SQL?
Maybe a SELECT 'hello world'? Other than that, I used a solution for something else here: dba.stackexchange.com/a/24850/6219
Jul
6
comment How to partition existing table in postgres?
@EvanAppleby DELETE FROM ONLY master_table is the solution.