10000 oraclesql · coder-caicai/APIJSON@acfd930 · GitHub
[go: up one dir, main page]
Skip to content

Commit acfd930

Browse files
justinfengchenjustinfengchen
committed
oraclesql
1 parent 3870818 commit acfd930

File tree

1 file changed

+23
-0
lines changed

1 file changed

+23
-0
lines changed

‎OracleSQL/sys.sql

Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
2+
create table db3.CONTRACT
3+
(
4+
ID NUMBER not null
5+
primary key,
6+
CNT_NAME VARCHAR2(100),
7+
CNT_BUYER_NAME VARCHAR2(100),
8+
CNT_SELLER_NAME VARCHAR2(100)
9+
);
10+
11+
12+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (1, '合同名称', '买方名称', '卖方名称');
13+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (2, '合同名称', '买方名称', '卖方名称');
14+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (3, '合同名称', '买方名称', '卖方名称');
15+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (4, '合同名称', '买方名称', '卖方名称');
16+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (5, '合同名称', '买方名称', '卖方名称');
17+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (6, '合同名称', '买方名称', '卖方名称');
18+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (7, '合同名称', '买方名称', '卖方名称');
19+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (8, '合同名称', '买方名称', '卖方名称');
20+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (9, '合同名称', '买方名称', '卖方名称');
21+
INSERT INTO db3.CONTRACT (ID, CNT_NAME, CNT_BUYER_NAME, CNT_SELLER_NAME) VALUES (10, '合同名称', '买方名称', '卖方名称');
22+
23+
commit;

0 commit comments

Comments
 (0)
0