Recent content by Sparrow

For example, I have procedure like as: procedure CalcSomething(npBase number) as idvMain number; nvQty number; svName varchar2(100); nvSize number; begin select t.idMain , t.nQty , t.sName , t.nSize into idvMain , nvQty , svName...

Could you do checing syntax not for compilation but right after typing?

pl\sql variable doesn't can contains in name character "," therefore when we choos a few variable split ',' and click "Add variable to watch", we can split choosed text by ',' and add all variables to watch. When we choose function or procedure and clicked "Add variable to watch" then added new...

When I write big procedure on pl\sql, I often use subprograms like as: procedure MyBigProcedure as procedure AddRow(svRow varchar2) as begin ... end; procedure DelRow(svRow varchar2) as begin ... end; begin .. end; And then I want collapsed subprogram in declaration...

I added this option, I will try use farther and I will write you then sometimes

Interface doesn't must freezing when Developers losts connect with DB. I often work with external Data base and sometimes connect is losts when I try compile type or package, or execute sql query, afterwards interface frezzing and Developer stop response! It's horrible!

I need more flexible beautifier. For example, I want to have opportunity put a end-bracket on next line after end line with code text and fisrt line with code in sub-query must be in new line after start-bracket, like this: select t.* from MyTable t where t.sCode in ( select...

"Elsif" block does not must collapse when we collapse block "If". It's very uncomfortable, when I have construction "If-elsif-else" and I collapse block "elsif" or "else" then I try collapse block "If" afterward blocks "elsif"\"else" vanish!