today:
490
yesterday:
405
Total:
1,013,900

SQL CREATE TABLE

admin 2018.09.25 19:56 Views : 482

CREATE TABLE DEDUCTION_RESULT 
("DEDUCT_ID" NUMBER, "MISSIONARY_ID" VARCHAR2(20),"RECEIPT_NO" NUMBER,"SUPPORTER_ID" NUMBER, "AMOUNT" NUMBER,"CONTRIBUTION_DATE" DATE ,"DEDUCTION" NUMBER )

 CREATE SEQUENCE   "DEDUCTION_RESULT_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 START WITH 100 CACHE 20 NOORDER  NOCYCLE

CREATE OR REPLACE TRIGGER  "INSERT_DEDUCTION_RESULT" 
BEFORE INSERT ON DEDUCTION_RESULT
FOR EACH ROW
DECLARE
  DEDUCT_ID_sv number;
  SELECT DEDUCTION_RESULT_SEQ.nextval
    INTO DEDUCT_ID_sv
    FROM dual;
  :new.DEDUCT_ID := DEDUCT_ID_sv;
  
End;
No. Subject Author Date Views
21 TREE admin 2016.05.18 730
20 INSTR admin 2016.05.19 794
19 NVL admin 2016.05.19 158
18 ROWNUM admin 2016.05.19 246
17 FOR LOOP admin 2016.05.20 278
16 SUBSTR admin 2016.05.26 279
15 SQL admin 2016.07.15 402
14 How to Update Oracle XE admin 2018.04.25 149
13 Oracle SQL Developer: Online Migration 3.1 admin 2018.04.25 130
12 DATE Compare admin 2018.05.22 378
11 How to convert DATE to NUMBER admin 2018.05.27 205
10 GP PRINT admin 2018.05.31 928
9 TABLE PRINT admin 2018.06.18 201
8 MISSIONARY_SUB admin 2018.06.25 212
7 VERY IMPORTANT admin 2018.06.26 239
» CREATE TABLE admin 2018.09.25 482
5 SELECT last_name FROM admin 2018.12.12 756
4 ACTION admin 2019.01.11 6467
3 STARTUP admin 2022.09.01 93
2 LOOP TABLE UPDATE admin 2023.05.19 62