today:
164
yesterday:
242
Total:
1,004,322

SQL ACTION

admin 2019.01.11 11:13 Views : 6456

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
21 UPDATE PROCESS admin 2016.04.28 167
20 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 172
19 TABLE PRINT admin 2018.06.18 186
18 How to convert DATE to NUMBER admin 2018.05.27 198
17 MISSIONARY_SUB admin 2018.06.25 199
16 Name Show admin 2016.04.28 203
15 CREATE VIEW admin 2016.05.13 218
14 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 220
13 VERY IMPORTANT admin 2018.06.26 226
12 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 234
11 ROWNUM admin 2016.05.19 240
10 FOR LOOP admin 2016.05.20 269
9 SUBSTR admin 2016.05.26 272
8 DATE Compare admin 2018.05.22 366
7 SQL admin 2016.07.15 396
6 CREATE TABLE admin 2018.09.25 471
5 TREE admin 2016.05.18 722
4 SELECT last_name FROM admin 2018.12.12 742
3 INSTR admin 2016.05.19 789
2 GP PRINT admin 2018.05.31 918
Write Tag