PL SQL Developer Conditional Breakpoint

Making Conditional Breakpoint When you make a breakpoint conditional, the debugger pauses when a certain condition is met. When breakpoint is first set, the debugger pauses the program execution each time the breakpoint is encountered. However, using the Edit Breakpoints dialog, you can customize breakpoints so that they are activated only in certain conditions. The Conditions tab in the Breakpoint dialog...

Read More

PLSQL Locked package

PL SQL locked package When you work in a large company that has many programmers, you can often find yourself in situation of locked package. Locked package? Yes, that is right. Locked package is the thing that happens when somebody else compile that package or is debugging it and you are also working on that package, but with no team coding option. If person A is debugging package, and person B let's say wants to compile package he will end up...

Read More

Leap year function PLSQL

PL SQL Leap year function Hi all, I didn't have time to write cause I had no time on my schedule :) so I decided to refresh my blog with leap year calculator.... Some exceptions to this rule are required since the duration of a solar year is slightly less than 365.25 days. Over a period of four centuries, the accumulated error of adding a leap day every four years amounts to about three extra days. The Gregorian Calendar therefore omits 3...

Read More

Backup of Source Code (effective versioning without SVN)

PL SQL versioning tutorial without SVN Have been busy lately with MSAccess coding and had no time to write something useful.... But now I manage to take some time and write .... I had some bad experience with "loosing source code"  day after I wrote it... Scenario: You write the code test it and Compile package Someone else has that package opened and hit compile on it.... Next day you open your source and you see that there are no changes...

Read More

PLSQL Operators

PL SQL Operators Relational operators compare two expressions or values and return a Boolean result. PL/SQL supports operators like =, <, >, <=, >=, <>, !=, ~=, ^=, IS NULL, LIKE, BETWEEN, IN Operator Meaning = equal to <>, !=, ~=, ^= not equal to < less than > greater than <= less than or equal to >= greater than or...

Read More

PLSQL Modulo 11 check...

What is Modulo 11 check? MSI was developed by the MSI Data Corporation, based on the original Plessey Code. MSI, also known as Modified Plessey, is used primarily to mark retail shelves for inventory control. MSI is a continuous, non-self-checking symbology. While the length of an MSI bar code can be of any length, a given application usually implements a fixed-length code.  A typical MSI bar code is MSI, and other symbologies based...

Read More

PLSQL backup time...

PL SQL package backup tutorial I started this project because i needed program that will easily back up my files from developer without clicking on package and exporting it to save my work... Second i wrote it because there is Bug in SQL DEVELOPER that causes lines to be messed up  when you have large code... Example: You have large code and export it with right click on package name and select save specs and body Real code is written like...

Read More