today:
1,101
yesterday:
2,073
Total:
1,301,004

SQL ACTION

admin 2019.01.11 11:13 Views : 6611

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
41 Monthly SUM admin 2023.05.22 161
40 LOOP TABLE UPDATE admin 2023.05.19 339
39 STARTUP admin 2022.09.01 179
» ACTION admin 2019.01.11 6611
37 SELECT last_name FROM admin 2018.12.12 846
36 CREATE TABLE admin 2018.09.25 576
35 VERY IMPORTANT admin 2018.06.26 314
34 MISSIONARY_SUB admin 2018.06.25 284
33 TABLE PRINT admin 2018.06.18 294
32 GP PRINT admin 2018.05.31 1068
31 How to convert DATE to NUMBER admin 2018.05.27 332
30 DATE Compare admin 2018.05.22 472
29 Oracle SQL Developer: Online Migration 3.1 admin 2018.04.25 226
28 How to Update Oracle XE admin 2018.04.25 237
27 SQL admin 2016.07.15 498
26 SUBSTR admin 2016.05.26 351
25 FOR LOOP admin 2016.05.20 353
24 ROWNUM admin 2016.05.19 320
23 NVL admin 2016.05.19 232
22 INSTR admin 2016.05.19 901
Write Tag