Reputation
15,810
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
3 29 58
Newest
 Copy Editor
Impact
~1.0m people reached

5h
comment Query on Sqlplus utility
To just run queries the current OS user does not need to be in the dba or oinstall group.
7h
comment PostgreSQL 9.3 is not returning existing rows with Ruby on Rails or Squirrel
What exactly does "Content does not show anything" mean? Most of the time in cases like this the answer is: you are connected to different databases in Squirrel and Ruby
8h
reviewed Approve PostgreSQL 9.4.4 Crashing
8h
comment PostgreSQL failed on Select
No need for a variable (at least not in this case) select data into data_list from some_table where PortNumber = (select alter_port from another_table where ...). Note that this will fail if the sub-select returns more than one row, but so would the select ... into
8h
revised I want load the Jason File in my local desktop , that i want to load in postgres
deleted 23 characters in body; edited title
12h
comment Oracle 12c upgrade - from Oracle 11g
Why do you think the create user statement would be different?
23h
comment Postgres New trigger being blocked.
Check pg_stat_activity and pg_locks
1d
comment Is adding the join columns to a table a good practice to improve performance?
You might also want to tag this with the DBMS you are using (Postgres, Oracle). Different DBMS have different optimizers and will behave differently.
1d
answered How to use a value from insert in conditional insert in postgres
1d
comment Matching data in two tables
@ypercube: I know that, but it will not work as it is shown right now using o.Cust_ID.
1d
comment Calculating the percentage change from the previous row
There was a Value in the question, not a [Value]
1d
comment Oracle and execution plans
You don't need a procedure for that. Just run the select statement directly.
1d
comment Calculating the percentage change from the previous row
[value] is an invalid identifier ([ or ] or not allowed in an SQL identifier)
1d
revised Determining the specific command type in a DDL trigger
edited tags
1d
revised Is it possible to cascade delete a column value?
edited tags
1d
comment Matching data in two tables
Your query will fail in Postgres: "column "c.cust_id" must appear in the GROUP BY clause or be used in an aggregate function"
2d
comment Postgres Dump and Restore on Linux Terminal
postgresql.org/docs/current/static/backup.html
2d
revised Losing the last column of data
added 24 characters in body
Aug
25
revised SQL Server 2000 Error
edited tags; edited tags
Aug
24
revised which is the cost of evaluation of the request?
edited tags