today:
1,145
yesterday:
2,073
Total:
1,301,048

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
109 FINAL TEST admin 2023.05.08 104
108 GitHub.com/Oracle/APEX. admin 2023.05.04 138
107 TEST admin 2023.05.03 129
106 TEST admin 2023.04.28 191
105 WHDR email address admin 2023.04.13 118
104 TEST admin 2023.03.27 183
103 GP 영수증 (3) -01/04/2023 admin 2023.01.04 103
102 GP - 영수증 (2) admin 2022.11.07 125
101 GP 영수증 본문 admin 2022.11.07 117
100 STARTUP admin 2022.09.01 179
99 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 252
98 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 197
97 SQL DEVELOPER file admin 2022.03.17 201
96 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 176
95 QRCODE admin 2020.05.25 451
94 JK admin 2019.02.05 776
» ACTION admin 2019.01.11 6611
92 SELECT last_name FROM admin 2018.12.12 846
91 IMP admin 2018.10.08 867
90 CREATE TABLE admin 2018.09.25 576
Write Tag