블로그
-
13. Context Switching
*Possibilities -Scan process table for first runnable process -Might spend much time searching -Results -Link together the runnable processes into a queue -Dispatcher takes from the head of the queue -Runnable
blog.naver.com · 2014.02.03
-
DBMS SQL
USR PCTFREE 10 INITRANS 5; P14 create table employee ( EMP_NO NUMBER PRIMARY KEY, EMP_NAME VARCHAR(40 department (DEPT_CD,DEPT_NAME) values (0000,'TmaxSoft'); insert into department va.......
blog.naver.com · 2013.04.18
-
워드프레스 데이터베이스 구조
참조 : http://codex.wordpress.org/Database_Description#Table:_wp_posts WordPress 3.4 Tables (11)Table NameDescriptionRelevant table.Administration > Comments > Commentswp_linksThe wp_links holds information related to the links entered into
blog.naver.com · 2013.02.11
-
4일차(10월25일) INSERT, VARCHAR2, NVARCHAR2, 제약 조건
INSERT 문의 테이블에 새 행(row)을 추가하는데 이용하며, single table insert나multi table insert를 수행할 수 있다. single table insert 형식 INSERT INTO 테이블명(컬럼명, ...) VALUES(값, ...);-->컬.......
blog.naver.com · 2012.12.01
-
7일차(10월30일) PROCEDURE, 권한관리
로그인할 떄 주로 사용.CREATE TABLE test18 ( id VARCHAR2(10) --PK ,pw VARCHAR2(10)); ALTER TABLE test18 ADD CONSTRAINT test18_id_pk PRIMARY KEY(id); INSERT INTO test18(id, pw) VALUES ('test', '1234');INSERT INTO test18(
blog.naver.com · 2012.12.01
-
[Trigger]
UPDATE EXAMPLE> CREATE TRIGGER Employee_Trg_Upd ON emplyeeORG AFTER UPDATE AS INSERT INTO employeeTRK . 1.Insert statement -> New record inserted -> Insert table 2.Update Statement -> Old record
blog.naver.com · 2012.10.11
-
프로시저에서 배열, 커서 Type 사용 해 보자..
-- VARCHAR2 형 배열 선언 TYPE ARRAY_VARCHAR IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER; -- NUMBER 형 배열 선언 TYPE ARRAY_NUMBER IS TABLE OF NUMBER(18,3) INDEX BY BINARY_INTEGER; -- 커서 타입 선언 TYPE TYPE_CURSOR
blog.naver.com · 2011.06.16
-
오라클(Oracle) Merge into 자료...
출처 : http://www.oracleclub.com/lecture/1880 MERGE INTO target_table_name USING (table|view|subquery) VALUES(...) - INTO : DATA가 UPDATE되거나 INSERT 될 TABLE 이름을 지정. - USING : 대상 TABLE의 DATA와 비교한 후 UPDATE 또는
blog.naver.com · 2010.12.31
-
Netflix on AWS
After the talk I got into a more detailed discussion with many folks from Netflix and Canada’s Research The discussion ended up in a long lunch over a big table with folks from both teams.
blog.naver.com · 2010.10.21
-
DoD AF 2.0 Models
Models Model List The DoDAF-described Models that are available in DoDAF V2.0 are listed in the table The DoDAF-described Models are grouped into the following viewpoints: All Viewpoint (AV) Capability Viewpoint
blog.naver.com · 2010.09.01
