Data Written into wrong columns
606054Mar 6 2008 — edited Mar 6 2008Hi
I use sql developer at work and I'm finding something odd when I try and manually add rows into a particular table: I create a new row using the + icon in sql developer and type in values 1,2,3,4 in columns A,B,C and D.
Everything looks OK on the surface, it commits without argument, but the data editor log shows the sql statement that's been executed and it appears to show that 4 has been entered in column C and 3 in column D. Sure enough, when I click the refresh icon, 3 and 4 swap places. Obvious;y the short term solution is to put the data in the wrong columns so that the bug will re-sort them again but can anyone help me understand what's going on please? something to do with the jdbc drivers? sql developer itself? I'm using an out of date version (1.00.00.15.57) which probably isn't helping, but I don't have the ability to download a newer one inside the firewall...