165 reputation
1110
bio website mnowotka.github.io/…
location Cambridge, UK
age 28
visits member for 2 years, 7 months
seen Aug 22 at 14:08

Professional Python developer with many years of experience in writing code in Python and C++ and joining them together. Experienced web developer and open source enthusiast. Has academic background in CS but professionally involved in chem and bio informatics. A gentleman, who demands excellence from his code.


LinkedIn Profile GitHub repo My presentations


Aug
30
awarded  Autobiographer
Aug
22
awarded  Famous Question
Feb
10
awarded  Popular Question
Nov
14
awarded  Popular Question
Aug
2
awarded  Notable Question
Aug
2
awarded  Popular Question
Mar
28
awarded  Popular Question
Oct
26
comment Oracle Procedure to Enable/Disable all constraints
Additional questions here would be: how to do unit testing? How to formalize error handling? What is instrumentation? How to improve reporting method?
Oct
26
accepted Oracle Procedure to Enable/Disable all constraints
Oct
26
comment oracle how to call procedure
I'm using it. So can you tell me how to achieve this using SQLdeveloper?
Oct
25
accepted How do Savepoints work in Oracle?
Oct
25
accepted What happens when you modify (reduce) a column's length?
Oct
25
asked Oracle Procedure to Enable/Disable all constraints
Oct
25
accepted oracle how to call procedure
Oct
25
comment oracle how to call procedure
I have large database where many fields have a type of NUMBER (without precision and scale). I want to use django ORM to create an interface out of this schema. Unfortunately with such a generic types django has no clue how to treat these fields, and that's why I have to change their type do decrease precision and scale. You can't do this on nonempty columns so I'm creating a temporary table and truncate original one. So in the process of copying back and forth I need to temporarily disable all constrains and triggers. Do you have other idea?
Oct
25
comment oracle how to call procedure
Your procedure is very helpful, perhaps I should change the question now :)
Oct
25
awarded  Supporter
Oct
25
comment oracle how to call procedure
This will be production code for migration script. What are the consequences?
Oct
25
asked oracle how to call procedure
Oct
22
accepted How can I append a column to an inner SQL statement?