selected two variables that control whether the program from a fixed start and end

Hi;
This is my first English post.Sometimes we need a program for check the anything.Someday such a program was needed and I and my friend wrote this program.This program is checking the numbers between two numbers.If the number is between the start and end points of the two variables is terminating the process.If two values are given, but processing continues in the start and end values.
The syntax of program below.I hope it will be useful.

DECLARE
  begin_number     NUMBER := 8; --first number for time line
  end_number       NUMBER := 20; --last number for time line
  variable_number1 NUMBER := 22; --first variable for time line
  variable_number2 NUMBER := 5; --last variable for time line
  break            NUMBER := 0; -- value:1 break,value:0 continue
BEGIN
  --/*Condition 1*/
  IF variable_number1 < begin_number AND variable_number2 < end_number THEN
    IF variable_number1 < begin_number AND variable_number2 > begin_number THEN
      break := 1;
    END IF;
  END IF;

  --/*Condition 2*/
  IF variable_number1 < begin_number AND variable_number2 > end_number THEN
    break := 1;
  END IF;

  --/*Condition 3*/
  IF variable_number1 > begin_number AND variable_number2 > end_number THEN
    IF variable_number1 < end_number AND variable_number2 > end_number THEN
      break := 1;
    END IF;
  END IF;

  --/*Condition 4*/
  IF variable_number1 > begin_number AND variable_number2 < end_number THEN
    IF variable_number1 > end_number AND variable_number2 < begin_number THEN
      break := 0;
    ELSE
      IF variable_number1 = end_number AND variable_number2 < begin_number THEN
        break := 0;
      ELSE
        IF variable_number1 = end_number AND variable_number2 = begin_number THEN
          break := 0;
        ELSE
          IF variable_number1 > end_number AND variable_number2 = begin_number THEN
            break := 0;
          ELSE
            break := 1;
          END IF;
        END IF;
      END IF;
    END IF;
  END IF;

  --/*Condition 5*/
  IF variable_number1 = begin_number AND variable_number2 = end_number THEN
    break := 1;
  END IF;

  --/*Condition 6*/
  IF variable_number1 > begin_number AND variable_number2 = end_number THEN
    break := 1;
  END IF;

  --/*Condition 7*/
  IF variable_number1 = begin_number AND variable_number2 < end_number THEN
    break := 1;
  END IF;

  --/*Condition 8*/
  IF variable_number1 < begin_number AND variable_number2 = end_number THEN
    break := 1;
  END IF;

  --/*Condition 9*/
  IF variable_number1 = begin_number AND variable_number2 > end_number THEN
    break := 1;
  END IF;

  IF nvl(break, 0) = 1 THEN
    dbms_output.put_line('Result=' || break || ' Break the program.');
  ELSE
    dbms_output.put_line('Result=' || break || ' Continue the program.');
  END IF;

END;

Note:Please let me know if you have an error in my article.

pl/sql dbms_sql kullanımı

PL/SQL de dbms_sql kullanımı için hazırlanmış basit bir örnek. bu işlem işle istenildiği gibi sql string oluşturulup sorgulama sonucu istenilen değişkenlere atılabilinir.

DECLARE
  sql_string  VARCHAR2(5000);
  dbms_cursor NUMBER;
  valuee      NUMBER := 2;
  col_1       NUMBER;
  col_2       NUMBER;
  col_3       NUMBER;
  ignore      NUMBER;
BEGIN

  sql_string := 'Select colum_1,colum_2,colum_3 from table where colum_1=' || variable_1 || ' and colum_2=' || variable_2;

  dbms_cursor := dbms_sql.open_cursor;
  dbms_sql.parse(dbms_cursor, sql_string, valuee);
  ignore := dbms_sql.execute(dbms_cursor);

  dbms_sql.define_column(dbms_cursor, 1, col_1);
  dbms_sql.define_column(dbms_cursor, 2, col_2);
  dbms_sql.define_column(dbms_cursor, 3, col_3);

  WHILE dbms_sql.fetch_rows(dbms_cursor) > 0 LOOP
    dbms_sql.column_value(dbms_cursor, 1, col_1);
    dbms_sql.column_value(dbms_cursor, 2, col_2);
    dbms_sql.column_value(dbms_cursor, 3, col_3);
    dbms_output.put_line(col_1 || '-' || col_2 || '-' || col_3);
  END LOOP;

  dbms_sql.close_cursor(dbms_cursor);

END;