today:
22
yesterday:
242
Total:
1,004,180

SQL ACTION

admin 2019.01.11 11:13 Views : 6456

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 DATE -> DAY CONVERT SQL admin 2023.05.25 40
5 Monthly SUM admin 2023.05.22 40
4 ORACLE COLLECTION admin 2023.05.08 40
3 INNER JOIN admin 2023.05.19 39
2 TEST admin 2023.05.03 38
1 YEAR EXPRESSIONS admin 2023.05.25 35
Write Tag