Asadullah fazli's Page

Find out the number is Even or Odd

 declare
  num number(5);
begin
  num:=#
  if num mod 2 =0 then
    dbms_output.put_line(' Number is ||num||' is even');
  else
    dbms_output.put_line('Number  is '||num||' is odd');
  end if;
end;

Hi

Plz find the below :

declare

first varchar(20):=&a;
second varchar2(10):=&b;
begin
dbms_output.put_line ('First letter before Swap :='||first);
dbms_output.put_line ('Second letter before Swap :='||second);
first := first || '/' || second;
second := substr(first, 1, instr(first, '/') - 1);
first := substr(first, instr(first, '/') + 1);
dbms_output.put_line ('........................');
dbms_output.put_line ('........................');
dbms_output.put_line ('First letter after Swap :='||first);
dbms_output.put_line ('Second letter after Swap :='||second);
end;

We have to use escape sequence,e.g if there is a table "bilal" and it has entry bilal_bhat under name column and i want to retrieve those names which has underscore, we can use

select name from bilal where name like '%/_%' ESCAPE '/';