數(shù)據(jù)字典總結(jié)(oracle10g)(完整版)
【正文】 E temp QUOTA 5M ON system PROFILE app_user PASSWORD EXPIRE。25 A plex example on table structure 復(fù)雜的表結(jié)構(gòu)SQL CREATE TABLE s_emp (id NUMBER(7) CONSTRAINT s_emp_id_pk PRIMARY KEY, last_name VARCHAR2(25) CONSTRAINT s_emp_last_name_nn NOT NULL, first_name VARCHAR2(25), userid VARCHAR2(8) CONSTRAINT s_emp_userid_nn NOT NULL CONSTRAINT s_emp_userid_uk UNIQUE, start_date DATE DEFAULT SYSDATE, ments VARCHAR2(25), manager_id NUMBER(7), title VARCHAR2(25), dept_id NUMBER(7) CONSTRAINT s_emp_dept_id_fk REFERENCES s_dept(id), salary NUMBER(11,2), mission_pct NUMBER(4,2) CONSTRAINT s_emp_mission_pct_ck CHECK (mission_pct IN(10,15,20)))。17 View current time查看當(dāng)前的系統(tǒng)時(shí)間SQLselect sysdate from dualwhile in sql server getdate is used as a functionsql server的語(yǔ)法SQLselect getdate()18 select current date查看當(dāng)前的日期SQLselect current_date from dual19 Change current date display type設(shè)置日期的顯示格式的方法SQLalter session set NLS_date_formate=39。12 alter its owner for tablespace改變表空間的擁有者SQLalter tablespace MyFirstSpace ow
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1