today:
130
yesterday:
177
Total:
1,001,047

SQL ACTION

admin 2019.01.11 11:13 Views : 6454

declare
  M_action integer;
begin
  select count(*)
    into M_action
    from MNEWS
   where MYEAR = :P18_YEAR and MMONTH = :P18_MONTH;

  if( M_action >= 1 )
  then
    :P18_SELECT := 2;
  else 
    :P18_SELECT := 1;
  end if;
end;
I want to
List
No. Subject Author Date Views
6 GP PRINT admin 2018.05.31 918
5 How to Update Oracle XE Version admin 2018.02.23 930
4 QR Code plugin Process admin 2017.11.30 963
3 QR Code plugin admin 2017.11.30 1586
2 Fundamentals of PL/SQL admin 2016.05.10 2031
» ACTION admin 2019.01.11 6454
Write Tag