mnowotka

150 reputation

bio	website
	location
	age
visits	member for	1 year, 4 months
	seen	Mar 28 at 20:00
stats	profile views	7

	150 reputation	bio	website		visits	member for	1 year, 4 months
6 badges		location			seen	Mar 28 at 20:00

summary answers questions tags badges favorites bounties reputation activity

30 Actions

suggestions reviews revisions comments badges posts accepts all

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?
Oct 22	awarded	Critic
Oct 22	comment	How can I append a column to an inner SQL statement? please read the question once again...
Oct 22	revised	How can I append a column to an inner SQL statement? added 65 characters in body
Oct 22	asked	How can I append a column to an inner SQL statement?
Oct 20	revised	How do Savepoints work in Oracle? deleted 9 characters in body
Oct 20	comment	How do Savepoints work in Oracle? OK, I see. So is there any possibility to roll back from table creation, truncation, modifications but not affecting other users?