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

PLSQL - Decoding time

 PL SQL Decode Function Some of my friends told me to write something about famous decode :) So here it goes .... What is decode? Decode is implemented function that has the functionality of an IF THEN ELSE statement. But there is one major difference between implementing these two functionality. DECODE can only work in select statement.You need to have in mind that DECODE is supported only in SQL Context so you don't really working with...

Read More

PLSQL check my email adress...

PL SQL Code for checking mail adress So you want to put some security check on you're mail input field... As you know mail can consist letters, numbers and dots.... It must contain only one @ sign... How would you check you're email? I do check on two different ways No1. Simple way of checking allowed signs in mail function f_emailok (i_email in varchar2) return boolean is  l_dot    NUMBER;  l_at     NUMBER;  l_length NUMBER;BEGIN  l_dot    := instr(i_email ,'.'); ...

Read More

PLSQL iso7064 MOD 97,10 check

What is iso7064? Check wikipedia It is standard for checking accounting number on Credit cards, Resident Identity Card etc.... Rules for checking Mod97,10 (iso7061) are: This scheme produces two digits as a check. And as a result, it catches just about every possible error. If you can afford the extra digit, this system is superior to the dihedral check. It also has an especially compact formula. The check digits are given by mod(98 - mod(data * 100, 97), 97) and the verification is just mod(data_check,97) == 1. In practice an alternate algorithm...

Read More

PLSQL what day is it?

PLSQL what day is it Say that for some reason you need name of the day for certain reason... You can create function that will return name of the day of specified date.... function f_name_of_the day (i_date) return varchar2 asl_day varchar2(50):=null;begin   SELECT TO_CHAR( trunc(to_date( to_char(to_date(i_date,'YYYYMMDD')) )),'day') into l_day FROM DUAL;   return(day);end f_name_of_the day ; So what does this function do? You...

Read More

PLSQL numeric check

PL SQL numeric check Assuming that you need some function to check input from the front-end and you want to assure that input is numerical data, you can do it by simple function that has one input parameter and is returning false or true... So here it goes... Function F_numeric_val (i_value IN VARCHAR2) return boolean is l_num NUMBER; BEGIN          l_num := to_number(i_value);        ...

Read More