dual
- oracle
1
select 1 from dual;
- DB2
1
select 1 from sysibm.dual;
숫자 타입별 차이 정리
날짜, 시간
Db2 integer example
First, create a table named db2_integers that consists of some integer columns:
1
2
3
4
5
CREATE TABLE db2_integers(
smallint_col SMALLINT,
int_col INT,
bigint_col BIGINT
);
Second, insert some values into the table:
1
2
3
4
5
6
7
8
9
INSERT INTO db2_integers (
smallint_col,
int_col,
bigint_col )
VALUES (
32767,
2147483647,
9223372036854775807
);
Third, query data from the db2_integers table:
1
SELECT * FROM db2_integers;
참고 :