today:
197
yesterday:
311
Total:
1,018,436

SQL CREATING A TABLE / SEQUENCE / TRIGGER

admin 2016.04.28 13:34 Views : 186

* CREATING A TABLE  *
CREATE TABLE  "CATEGORY_T"
   (    "CA_ID" NUMBER NOT NULL ENABLE,
    "CA_NAME" VARCHAR2(50),
    "LAST_MODIFIED_ON" DATE,
    "LAST_MODIFIED_BY" VARCHAR2(30),
     CONSTRAINT "CATEGORY_PK" PRIMARY KEY ("CA_ID") ENABLE
   )
/

* CREATING SEQUENCE *
 CREATE SEQUENCE   "CATEGORY_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 100 CACHE 20 NOORDER  NOCYCLE
/

* CREATING TRIGGER *
CREATE OR REPLACE TRIGGER  "INSERT_CATEGORY"
BEFORE INSERT ON CATEGORY_T
FOR EACH ROW
DECLARE
  CA_id_sv number;
BEGIN
  IF INSERTING THEN
 
  :New.LAST_MODIFIED_ON:= SYSDATE;
  :New.LAST_MODIFIED_BY:= V('APP_USER');

  SELECT CATEGORY_SEQ.nextval
    INTO CA_id_sv
    FROM dual;
  :new.CA_ID := CA_id_sv;

  ELSIF UPDATING THEN

  :New.LAST_MODIFIED_ON:= SYSDATE;
  :New.LAST_MODIFIED_BY:= V('APP_USER');

END IF;
 
End;
/
 
No. Subject Author Date Views
86 FOR LOOP admin 2016.05.20 293
85 SUBSTR admin 2016.05.26 289
84 CAPTCHA PLUG-IN admin 2016.05.27 314
83 Access Control List (ACL) admin 2016.06.07 355
82 Oracle 11g Access Control List for External Network Services admin 2016.06.07 310
81 ACL 보기 admin 2016.06.07 324
80 CREATE_ACL (1st STEP) admin 2016.06.07 329
79 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 373
78 Assign a network host to Access Control List admin 2016.06.07 321
77 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 357
76 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 372
75 APEX Web Services Proxy Settings admin 2016.06.07 380
74 How to set a proxy in UTL_HTTP admin 2016.06.07 341
73 function get area admin 2016.06.08 345
72 Membership Management admin 2016.06.09 454
71 control break admin 2016.06.25 411
70 SQL admin 2016.07.15 416
69 JavaScript for Member List admin 2016.08.17 453
68 APEX Password Change admin 2016.08.26 469
67 SQL Basics - Lesson 1 - Introduction admin 2017.06.17 106