建表文件CREATE TABLE cc_runyue_info (
id float,
col1 float,
col2 float,
col3 float,
col4 float,
col5 float,
col6 float,
col7 float,
col8 float,
col9 float,
col10 float,
col11 float,
col12 float,
col13 float,
col14 float);
INSERT INTO cc_runyue_info VALUES (
0,
0,
31,
59,
90,
120,
151,
181,
212,
243,
273,
304,
334,
365,
396);
INSERT INTO cc_runyue_info VALUES (
1,
0,
31,
60,
91,
121,
152,
182,
213,
244,
274,
305,
335,
366,
397);
id float,
col1 float,
col2 float,
col3 float,
col4 float,
col5 float,
col6 float,
col7 float,
col8 float,
col9 float,
col10 float,
col11 float,
col12 float,
col13 float,
col14 float);
INSERT INTO cc_runyue_info VALUES (
0,
0,
31,
59,
90,
120,
151,
181,
212,
243,
273,
304,
334,
365,
396);
INSERT INTO cc_runyue_info VALUES (
1,
0,
31,
60,
91,
121,
152,
182,
213,
244,
274,
305,
335,
366,
397);
解决方案 »
- oracle创建索引的问题
- PL/SQL 如何执行带返回游标的存储过程 !(SQL 窗口中如何调用)
- 如何利用oci接口来向oracle数据库里插入lob二进制数据(文件)
- 如何读取某一天二十四小时的数据
- 安装oracle出现解压错误怎么解决?
- 为什么我的trigger这样写不起作用啊
- 取ORCALE数据库表字段问题
- show sga;后的Fixed Size加上Variable Size,为什么不等于Total System Global Area?
- ORACLE数据库 ora-12154问题
- oracle 能不能一条查询语句生成某种规则的数据。
- 一个oracle表最多可以存多少条记录?
- 急问:可以在SqlServer里面直接把oracle数据库导入吗?
curyear float,
col1 float,
col2 float,
col3 float,
col4 float,
month1 float,
month2 float,
month3 float,
month4 float,
month5 float,
month6 float,
month7 float,
month8 float,
month9 float,
month10 float,
month11 float,
month12 float,
month13 float);
INSERT INTO cc_year_info VALUES (
1936,
23,
3,
2,
17,
1,
0,
0,
1,
0,
0,
1,
1,
0,
1,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
1937,
41,
0,
4,
23,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1938,
30,
7,
5,
28,
1,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1939,
49,
0,
6,
33,
1,
1,
0,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1940,
38,
0,
0,
38,
1,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1941,
26,
6,
2,
44,
1,
1,
0,
1,
1,
0,
1,
0,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1942,
45,
0,
3,
49,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1943,
35,
0,
4,
54,
0,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1944,
24,
4,
5,
59,
1,
0,
1,
0,
1,
0,
1,
0,
1,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1945,
43,
0,
0,
5,
0,
0,
1,
0,
0,
1,
0,
1,
1,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1946,
32,
0,
1,
10,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1947,
21,
2,
2,
15,
1,
1,
0,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1948,
40,
0,
3,
20,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1949,
28,
7,
5,
26,
1,
0,
1,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1950,
47,
0,
6,
31,
0,
1,
1,
0,
1,
1,
0,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1951,
36,
0,
0,
36,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1952,
26,
5,
1,
41,
0,
1,
0,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1953,
44,
0,
3,
47,
0,
1,
0,
0,
1,
1,
0,
1,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1954,
33,
0,
4,
52,
1,
0,
1,
0,
0,
1,
0,
1,
1,
0,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
1955,
23,
3,
5,
57,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1,
1);
INSERT INTO cc_year_info VALUES (
1956,
42,
0,
6,
2,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1,
1);
INSERT INTO cc_year_info VALUES (
1957,
30,
8,
1,
8,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1958,
48,
0,
2,
13,
1,
1,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1959,
38,
0,
3,
18,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1960,
27,
6,
4,
23,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1961,
45,
0,
6,
29,
1,
0,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1962,
35,
0,
0,
34,
0,
1,
0,
0,
1,
0,
1,
1,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1963,
24,
4,
1,
39,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
1964,
43,
0,
2,
44,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
1965,
32,
0,
4,
50,
0,
1,
0,
1,
0,
0,
1,
0,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1966,
20,
3,
5,
55,
1,
1,
1,
0,
1,
0,
0,
1,
0,
0,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
1967,
39,
0,
6,
0,
1,
1,
0,
1,
1,
0,
0,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1968,
29,
7,
0,
5,
0,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1969,
47,
0,
2,
11,
0,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1970,
36,
0,
3,
16,
1,
0,
0,
1,
0,
1,
1,
0,
1,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1971,
26,
5,
4,
21,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1972,
45,
0,
5,
26,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1973,
33,
0,
0,
32,
1,
0,
1,
0,
0,
1,
0,
0,
1,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1974,
22,
4,
1,
37,
1,
1,
0,
1,
0,
0,
1,
0,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1975,
41,
0,
2,
42,
1,
1,
0,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1976,
30,
8,
3,
47,
1,
1,
0,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1977,
48,
0,
5,
53,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
0,
1);
INSERT INTO cc_year_info VALUES (
1978,
37,
0,
6,
58,
1,
0,
1,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1979,
27,
6,
0,
3,
1,
0,
0,
1,
0,
1,
1,
0,
1,
1,
0,
1,
0);
1980,
46,
0,
1,
8,
1,
0,
0,
1,
0,
1,
0,
1,
1,
0,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
1981,
35,
0,
3,
14,
0,
1,
0,
0,
1,
0,
0,
1,
1,
0,
1,
1,
1);
INSERT INTO cc_year_info VALUES (
1982,
24,
4,
4,
19,
1,
0,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
1);
INSERT INTO cc_year_info VALUES (
1983,
43,
0,
5,
24,
1,
0,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
1);
INSERT INTO cc_year_info VALUES (
1984,
32,
10,
6,
29,
1,
0,
1,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
1985,
50,
0,
1,
35,
0,
1,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1986,
39,
0,
2,
40,
0,
1,
1,
0,
1,
1,
0,
1,
0,
1,
0,
0,
1);
INSERT INTO cc_year_info VALUES (
1987,
28,
6,
3,
45,
1,
0,
1,
0,
1,
1,
0,
1,
1,
0,
1,
0,
0);
INSERT INTO cc_year_info VALUES (
1988,
47,
0,
4,
50,
1,
0,
1,
0,
1,
0,
1,
1,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1989,
36,
0,
6,
56,
1,
0,
0,
1,
0,
0,
1,
1,
0,
1,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
1990,
26,
5,
0,
1,
0,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
1,
1);
INSERT INTO cc_year_info VALUES (
1991,
45,
0,
1,
6,
0,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
1992,
34,
0,
2,
11,
0,
1,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
1993,
22,
3,
4,
17,
0,
1,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1994,
40,
0,
5,
22,
1,
1,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
1995,
30,
8,
6,
27,
0,
1,
1,
0,
1,
0,
1,
1,
0,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1996,
49,
0,
0,
32,
0,
1,
0,
1,
1,
0,
1,
0,
1,
1,
0,
0,
1);
INSERT INTO cc_year_info VALUES (
1997,
37,
0,
2,
38,
1,
0,
1,
0,
1,
0,
1,
1,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1998,
27,
5,
3,
43,
1,
0,
0,
1,
0,
0,
1,
1,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
1999,
46,
0,
4,
48,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2000,
35,
0,
5,
53,
1,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2001,
23,
4,
0,
59,
1,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2002,
42,
0,
1,
4,
1,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2003,
31,
0,
2,
9,
1,
1,
0,
1,
1,
0,
1,
0,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
2004,
21,
2,
3,
14,
0,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2005,
39,
0,
5,
20,
0,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2006,
28,
7,
6,
25,
1,
0,
1,
0,
1,
0,
1,
0,
1,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
2007,
48,
0,
0,
30,
0,
0,
1,
0,
0,
1,
0,
1,
1,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
2008,
37,
0,
1,
35,
1,
0,
0,
1,
0,
0,
1,
0,
1,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
2009,
25,
5,
3,
41,
1,
1,
0,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
2010,
44,
0,
4,
46,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1);
INSERT INTO cc_year_info VALUES (
2011,
33,
0,
5,
51,
1,
0,
1,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2012,
22,
4,
6,
56,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
2013,
40,
0,
1,
2,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
2014,
30,
9,
2,
7,
0,
1,
0,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2015,
49,
0,
3,
12,
0,
1,
0,
0,
1,
0,
1,
1,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2016,
38,
0,
4,
17,
1,
0,
1,
0,
0,
1,
0,
1,
1,
0,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
2017,
27,
6,
6,
23,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1,
1);
INSERT INTO cc_year_info VALUES (
2018,
46,
0,
0,
28,
0,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
2019,
35,
0,
1,
33,
0,
1,
1,
0,
1,
0,
0,
1,
0,
0,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
2020,
24,
4,
2,
38,
0,
1,
1,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2021,
42,
0,
4,
44,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2022,
31,
0,
5,
49,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0);
INSERT INTO cc_year_info VALUES (
2023,
21,
2,
6,
54,
0,
1,
0,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2024,
40,
0,
0,
59,
0,
1,
0,
0,
1,
0,
1,
1,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2025,
28,
6,
2,
5,
1,
0,
1,
0,
0,
1,
0,
1,
0,
1,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
2026,
47,
0,
3,
10,
1,
0,
1,
0,
0,
1,
0,
0,
1,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2027,
36,
0,
4,
15,
1,
1,
0,
1,
0,
0,
1,
0,
0,
1,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2028,
25,
5,
5,
20,
1,
1,
1,
0,
1,
0,
0,
1,
0,
0,
1,
1,
0);
INSERT INTO cc_year_info VALUES (
2029,
43,
0,
0,
26,
1,
1,
0,
1,
0,
1,
0,
1,
0,
0,
1,
0,
1);
INSERT INTO cc_year_info VALUES (
2030,
32,
0,
1,
31,
1,
1,
0,
1,
1,
0,
1,
0,
1,
0,
1,
0,
0);
INSERT INTO cc_year_info VALUES (
2031,
22,
3,
2,
36,
0,
1,
1,
0,
1,
0,
1,
1,
0,
1,
0,
1,
0);