today:
352
yesterday:
667
Total:
1,015,222

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
106 TEST admin 2023.04.28 51
105 WHDR email address admin 2023.04.13 61
104 TEST admin 2023.03.27 110
103 GP 영수증 (3) -01/04/2023 admin 2023.01.04 60
102 GP - 영수증 (2) admin 2022.11.07 66
101 GP 영수증 본문 admin 2022.11.07 69
100 STARTUP admin 2022.09.01 94
99 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 163
98 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 157
97 SQL DEVELOPER file admin 2022.03.17 113
96 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 126
95 QRCODE admin 2020.05.25 407
94 JK admin 2019.02.05 711
» ACTION admin 2019.01.11 6467
92 SELECT last_name FROM admin 2018.12.12 758
91 IMP admin 2018.10.08 736
90 CREATE TABLE admin 2018.09.25 482
89 Change Admin PASSWORD admin 2018.07.31 244
88 VERY IMPORTANT admin 2018.06.26 239
87 IF/ELSE ... CASE WHEN admin 2018.06.25 218
Write Tag