today:
98
yesterday:
148
Total:
999,234

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
106 TEST admin 2023.04.28 40
105 WHDR email address admin 2023.04.13 55
104 TEST admin 2023.03.27 97
103 GP 영수증 (3) -01/04/2023 admin 2023.01.04 53
102 GP - 영수증 (2) admin 2022.11.07 63
101 GP 영수증 본문 admin 2022.11.07 61
100 STARTUP admin 2022.09.01 83
99 QRCODE admin 2020.05.25 405
98 JK admin 2019.02.05 700
» ACTION admin 2019.01.11 6454
96 SELECT last_name FROM admin 2018.12.12 742
95 IMP admin 2018.10.08 717
94 CREATE TABLE admin 2018.09.25 471
93 Change Admin PASSWORD admin 2018.07.31 225
92 VERY IMPORTANT admin 2018.06.26 224
91 IF/ELSE ... CASE WHEN admin 2018.06.25 208
90 MISSIONARY_SUB admin 2018.06.25 198
89 How to convert DATE to NUMBER admin 2018.05.27 197
88 TABLE PRINT admin 2018.06.18 185
87 DATE Compare admin 2018.05.22 365
Write Tag