today:
1,018
yesterday:
1,189
Total:
1,008,398

SQL CREATE TABLE

admin 2018.09.25 19:56 Views : 471

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;
I want to
List
No. Subject Author Date Views
46 DATE Compare admin 2018.05.22 368
45 How to convert DATE to NUMBER admin 2018.05.27 198
44 GP PRINT admin 2018.05.31 921
43 TABLE PRINT admin 2018.06.18 186
42 eeeeee admin 2018.06.21 224
41 MISSIONARY_SUB admin 2018.06.25 201
40 IF/ELSE ... CASE WHEN admin 2018.06.25 209
39 VERY IMPORTANT admin 2018.06.26 228
38 Change Admin PASSWORD admin 2018.07.31 233
» CREATE TABLE admin 2018.09.25 471
36 IMP admin 2018.10.08 725
35 SELECT last_name FROM admin 2018.12.12 745
34 ACTION admin 2019.01.11 6458
33 JK admin 2019.02.05 703
32 QRCODE admin 2020.05.25 405
31 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 121
30 SQL DEVELOPER file admin 2022.03.17 108
29 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 152
28 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157
27 STARTUP admin 2022.09.01 86
Write Tag