Reputation
4,789
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 9 24
Impact
~481k people reached

22h
comment Why is a Full Database Backup (as opposed to a level 0 backup) required in Oracle after switching to ARCHIVELOG mode?
Level 0 backup = (full backup (whole db backup) + ability to use as a parent to incremental backups)
1d
answered Why is a Full Database Backup (as opposed to a level 0 backup) required in Oracle after switching to ARCHIVELOG mode?
Apr
22
comment Why does Oracle change my date fields?
What does Calendar.getInstance().getTimeZone() output on your application machine ? If app timezone matches db timezone, try checking session timezone from application .
Apr
21
answered Why does Oracle change my date fields?
Apr
20
comment Why does Oracle change my date fields?
it seems that database time zone is set UTC (+00:00). Session timezone (client machine) is Moscow; when you store value in java, it actually goes as 12 (+3:00) which is equal to 9(or 8 in case of daylight savings) . The culprit is not Oracle, but jdbc driver. Unfortunately when it reads date back , it doesn't do reverse, but rather simply returns what is stored in db. You can check actual value stored in database with to_char(date_field, 'yyyy-mm-dd hh24:mi:ss')
Apr
11
answered INSERT and UPDATE in Trigger
Apr
11
comment Oracle Min - ORA-00937 not a single-group group function
You need to group by every non-aggregate column of your query, : GROUP BY by bus, dest
Mar
30
comment Why does Deadlock occur for this INSERT/UPDATE combination despite seemingly holding an X lock?
Can you add ddl for tables involved ? And the queries ; the important part is what fields are in WHERE
Mar
23
comment Is there any particular reason LIMIT 0 is allowed?
Such a query (as well as many others , e.g. WHERE 1=0 ) will return column metadata.
Mar
22
answered Can a trigger catch updates done by a select for update + lob.write()?
Mar
21
comment Can a trigger catch updates done by a select for update + lob.write()?
You can't do that , at least up to 12c : "Using OCI functions or the DBMS_LOB package to update LOB values or LOB attributes of object columns does not fire triggers defined on the table that contains the columns or attributes." (docs.oracle.com/database/121/ADDCI/lobs.htm#ADDCI4383 )
Mar
18
comment permissions for yet another “ORA-06512: table or view does not exist” scenario
I guess the culprit is enc. Try qualifying it like schema_name.enc. In general, full object qualification is much better way than using synonyms.
Feb
23
awarded  Popular Question
Feb
18
awarded  Popular Question
Feb
15
comment MySQL Update column with case on joined tables
I guess it happens because there is more than one record in d with the same c_id but different domain_id (2 rows in d with c_id =113113, one with domain_id =1 , another with domain_id=2) .
Feb
12
comment MariaDB: inner join searching for 1 in TINYINT column not working
@gglasses : the schema you posted in sqlfiddle doesn't have foreign key constraint ( CONSTRAINT imagehit_ibfk_1` FOREIGN KEY (owner_id) REFERENCES image (id)`) , and it cannot be added because the sample data violates it.
Feb
4
answered ORA 01722: Invalid Number caused by different comparison
Feb
3
comment Join SQL Server table in OPENQUERY on multiple keys
@user2316040 : I can't try myself, but what if you INNER REMOTE JOIN (SELECT all_columns_except_timestamp_column FROM ...) A ? I hope it shouldn't complain about timestamp then...
Feb
3
comment How to compare dates on minute level in plsql?
@Phil : or TRUNC .
Feb
3
answered Join SQL Server table in OPENQUERY on multiple keys