3,534 reputation
512
bio website
location Vancouver, Canada
age
visits member for 3 years, 2 months
seen 1 hour ago

Aug
20
answered Null column for username and password when using Login with *social network*
Aug
19
comment Why do these two queries (which I think are equivalent) rely on different keys?
First query has LEFT JOIN, the second one - INNER JOIN. They are not the same...
Aug
17
answered How to grant permissions for User defined type in Oracle
Aug
8
comment Database with java query problem
As far as I remember query should not end with semicolon when you run from java(jdbc or whatever connection you are using) : sql2 = "select avg("+D+"), max("+ D +"),min("+ D+") from ras;"; - doesn't work ; sql2 = "select avg("+D+"), max("+ D +"),min("+ D+") from ras"; - should work.
Jul
9
comment Building a Trending query
@Mr.Concolato : do date '2013-12-30' - interval .... : ` .... SELECT n-interval '1 day' FROM t WHERE n >=(date '2013-12-30'-interval '365 day') ....`
Jul
9
comment Building a Trending query
check updated version. In case I misunderstood the question (I thought you need a running total), just change current_date to whatever end date you want.
Jul
9
revised Building a Trending query
added 659 characters in body
Jul
9
answered Building a Trending query
Jul
2
awarded  Curious
Jun
28
awarded  Yearling
Jun
22
answered Msg 2627 Violation of PRIMARY KEY constraint
Jun
18
answered selecting rows that have n foreign key conditions satisfied
Jun
4
awarded  Popular Question
Jun
2
comment Stored procedure performs worse than straight query
It sounds to me like parameter sniffing. Check blogs.msdn.com/b/turgays/archive/2013/09/10/… , there are some workarounds.
May
17
comment My stored procedures often get invalidated
DDL on any object that referred in the procedure causes its invalidation. you can check dependencies in dba_dependencies
May
3
asked Refreshing Materialized view creates many child cursors
Apr
28
comment How to generate current Oracle timestamp in perl?
You can use TO_TIMESTAMP or to_timestamp_tz Oracle functions that convert string to timestamp . INSERT ... VALUES(TO_TIMESTAMP('string', 'format'), ....
Apr
26
answered How to prepare executon plan for given sql query on a server with 4 processors (Oracle database)
Apr
17
answered SQl comand works in Workbench but not from Java Program
Apr
17
comment SQl comand works in Workbench but not from Java Program
How do you call it from java? You cannot just pass these lines to 'Statement.executeUpdate` . Each insert statement should be executed as a separate call to Statement.executeUpdate (and as far as I remember it should be no semicolon ). So you are getting connection object, set autoCommit to false, create a prepared statement object, execute inserts, and then commit (connection.commit)