today:
171
yesterday:
456
Total:
1,015,497

SQL ACTION

admin 2019.01.11 11:13 Views : 6467

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
46 DATE Compare admin 2018.05.22 378
45 How to convert DATE to NUMBER admin 2018.05.27 206
44 GP PRINT admin 2018.05.31 929
43 TABLE PRINT admin 2018.06.18 201
42 eeeeee admin 2018.06.21 237
41 MISSIONARY_SUB admin 2018.06.25 213
40 IF/ELSE ... CASE WHEN admin 2018.06.25 218
39 VERY IMPORTANT admin 2018.06.26 239
38 Change Admin PASSWORD admin 2018.07.31 245
37 CREATE TABLE admin 2018.09.25 482
36 IMP admin 2018.10.08 736
35 SELECT last_name FROM admin 2018.12.12 758
» ACTION admin 2019.01.11 6467
33 JK admin 2019.02.05 711
32 QRCODE admin 2020.05.25 408
31 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 126
30 SQL DEVELOPER file admin 2022.03.17 114
29 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 157
28 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 163
27 STARTUP admin 2022.09.01 94
Write Tag