oracle数据库创建每天每15分钟间隔表语句

最新推荐文章于 2022-03-24 14:20:46 发布
最新推荐文章于 2022-03-24 14:20:46 发布
阅读量1.9k 收藏 1
点赞数
分类专栏： oracle数据库 文章标签： 数据库 plsql developer oracle 15分钟间隔 建表语句
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zz87250976/article/details/11898277
版权 
prompt PL/SQL Developer import file
prompt Created on 2013年9月22日星期日 by Administrator
set feedback off
set define off
prompt Creating TB_TIME...
create table TB_TIME
(
  TSEGMENTID   VARCHAR2(10) not null,
  TSEGMENT     VARCHAR2(20) not null,
  TSEGMENTTYPE VARCHAR2(20) not null,
  STARTTIME    VARCHAR2(20) not null,
  ENDTIME      VARCHAR2(20) not null
)
;
comment on column TB_TIME.TSEGMENTID
  is '	时段划分信息表  时间段ID';
comment on column TB_TIME.TSEGMENT
  is '时间段';
comment on column TB_TIME.TSEGMENTTYPE
  is '时间段类型(用于区别高峰期和平峰期)';
comment on column TB_TIME.STARTTIME
  is '起始时间 ';
comment on column TB_TIME.ENDTIME
  is '终止时间';

prompt Loading TB_TIME...
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('17', '04:00-04:15', '0', '04:00', '04:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('18', '04:30-04:45', '0', '04:30', '04:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('19', '05:00-05:15', '0', '05:00', '05:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('20', '05:15-05:30', '0', '05:15', '05:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('21', '05:30-05:45', '0', '05:30', '05:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('22', '05:45-06:00', '0', '05:45', '06:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('23', '06:00-06:15', '0', '06:00', '06:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('24', '06:15-06:30', '0', '06:15', '06:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('25', '06:30-06:45', '0', '06:30', '06:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('26', '06:45-07:00', '0', '06:45', '07:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('27', '07:00-07:15', '0', '07:00', '07:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('28', '07:15-07:30', '0', '07:15', '07:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('29', '07:30-07:45', '0', '07:30', '07:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('30', '07:45-08:00', '0', '07:45', '08:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('31', '08:00-08:15', '0', '08:00', '08:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('32', '08:15-08:30', '0', '08:15', '08:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('33', '08:30-08:45', '0', '08:30', '08:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('34', '08:45-09:00', '0', '08:45', '09:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('35', '09:00-09:15', '0', '09:00', '09:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('36', '09:15-09:30', '0', '09:15', '09:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('37', '09:30-09:45', '0', '09:30', '09:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('38', '09:45-10:00', '0', '09:45', '10:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('39', '10:00-10:15', '0', '10:00', '10:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('40', '10:15-10:30', '0', '10:15', '10:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('41', '10:30-10:45', '0', '10:30', '10:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('42', '10:45-11:00', '0', '10:45', '11:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('43', '11:00-11:15', '0', '11:00', '11:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('44', '11:15-11:30', '0', '11:15', '11:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('45', '11:30-11:45', '0', '11:30', '11:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('46', '12:00-12:15', '0', '12:00', '12:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('47', '12:15-12:30', '0', '12:15', '12:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('48', '12:30-12:45', '0', '12:30', '12:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('49', '12:45-13:00', '0', '12:45', '13:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('50', '13:00-13:15', '0', '13:00', '13:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('51', '13:15-13:30', '0', '13:15', '13:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('52', '13:30-13:45', '0', '13:30', '13:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('53', '13:45-14:00', '0', '13:45', '14:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('54', '14:00-14:15', '0', '14:00', '14:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('55', '14:15-14:30', '0', '14:15', '14:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('56', '14:30-14:45', '0', '14:30', '14:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('57', '14:45-15:00', '0', '14:45', '15:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('58', '15:00-15:15', '0', '15:00', '15:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('59', '15:15-15:30', '0', '15:15', '15:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('60', '15:30-15:45', '0', '15:30', '15:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('61', '15:45-16:00', '0', '15:45', '16:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('62', '16:00-16:15', '0', '16:00', '16:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('63', '16:15-16:30', '0', '16:15', '16:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('64', '16:30-16:45', '0', '16:30', '16:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('65', '16:45-17:00', '0', '16:45', '17:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('66', '17:00-17:15', '0', '17:00', '17:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('67', '17:15-17:30', '0', '17:15', '17:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('68', '17:30-17:45', '0', '17:30', '17:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('69', '17:45-18:00', '0', '17:45', '18:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('70', '18:00-18:15', '0', '18:00', '18:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('71', '18:15-18:30', '0', '18:15', '18:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('72', '18:30-18:45', '0', '18:30', '18:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('73', '18:45-19:00', '0', '18:45', '19:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('74', '11:45-12:00', '0', '11:45', '12:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('75', '04:15-04:30', '0', '04:15', '04:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('76', '04:45-05:00', '0', '04:45', '05:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('77', '19:00-19:15', '0', '19:00', '19:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('78', '19:15-19:30', '0', '19:15', '19:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('79', '19:30-19:45', '0', '19:30', '19:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('80', '19:45-20:00', '0', '19:45', '20:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('81', '20:00-20:15', '0', '20:00', '20:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('82', '20:15-20:30', '0', '20:15', '20:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('83', '20:30-20:30', '0', '20:30', '20:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('84', '20:45-20:45', '0', '20:45', '21:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('85', '21:00-21:15', '0', '21:00', '21:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('86', '21:15-21:30', '0', '21:15', '21:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('87', '21:30-21:45', '0', '21:30', '21:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('88', '21:45-22:00', '0', '21:45', '22:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('89', '22:00-22:15', '0', '22:00', '22:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('90', '22:15-22:30', '0', '22:15', '22:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('91', '22:30-22:45', '0', '22:30', '22:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('92', '22:45-23:00', '0', '22:45', '23:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('93', '23:00-23:15', '0', '23:00', '23:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('94', '23:15-23:30', '0', '23:15', '23:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('95', '23:30-23:45', '0', '23:30', '23:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('96', '23:45-23:59', '0', '23:45', '23:59');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('16', '03:45-04:00', '0', '03:45', '04:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('15', '03:30-03:45', '0', '03:30', '03:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('14', '03:15-03:30', '0', '03:15', '03:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('13', '03:00-03:15', '0', '03:00', '03:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('12', '02:45-03:00', '0', '02:45', '03:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('11', '02:30-02:45', '0', '02:30', '02:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('10', '02:15-02:30', '0', '02:15', '02:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('9', '02:00-02:15', '0', '02:00', '02:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('8', '01:45-02:00', '0', '01:45', '02:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('7', '01:30-01:45', '0', '01:30', '01:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('6', '01:15-01:30', '0', '01:15', '01:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('5', '01:00-01:15', '0', '01:00', '01:15');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('4', '00:45-01:00', '0', '00:45', '01:00');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('3', '00:30-00:45', '0', '00:30', '00:45');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('2', '00:15-00:30', '0', '00:15', '00:30');
insert into TB_TIME (TSEGMENTID, TSEGMENT, TSEGMENTTYPE, STARTTIME, ENDTIME)
values ('1', '00:00-00:15', '0', '00:00', '00:15');
commit;
prompt 96 records loaded
set feedback on
set define on
prompt Done.

帅明
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ORACLE的SQL练习---2. 实现15分钟一个间隔的记录统计
yuyan64的博客
11-25 1787
有如下一张记录表，如何查询出每隔15分钟的记录数，例如电商网站统计一个间隔的交易数等等…… 预期结果如下： --建表语句 --创建练习表 create table LX_02 ( id NUMBER, inputtime DATE ); --插入数据 insert into lx_02 (ID, INPUTTIME) values (1, to_date('14-01-2020 09:07:23', 'dd-mm-yyyy hh24:mi:ss')); commit; ins
oracle每隔一段时间统计数据,Oracle数据库之oracle 按时间段统计15分钟内的数据
weixin_36232899的博客
04-02 1887
本文主要向大家介绍了Oracle数据库之oracle 按时间段统计15分钟内的数据，通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。stringsql="selectto_char(StartTime,‘yyyy‘)||‘-‘||to_char(StartTime,‘mm‘)||‘-‘||to_char(StartTime,‘dd‘)||‘‘||to_ch...
Oracle以15分钟为界，统计一天内各时间段的数据笔数
binghuozhi的博客
05-20 2430
string sql = "select to_char(StartTime, 'yyyy')||'-'|| to_char(StartTime, 'mm')||'-'|| to_char(StartTime, 'dd')||' '|| to_char(StartTime, 'hh24')||':'|| floor(to_char(StartTime, 'mi')/15)*15 statim...
查询某个时间段内每隔十五分钟的数据（整15分钟的倍数有数据）
热门推荐
z13197919100的博客
04-24 1万+
需求：选定时间段，每隔十五分钟查询一次数据SELECT   DATA_TIME FROM、  DR_DC_RIPPLE_HOUR_201804 WHERE DATA_TIME BETWEEN '2018-04-17 00:00:00'   AND '2018-04-17 23:59:59'   AND DATE_FORMAT(DATA_TIME, '%i') % 15 = 0   AND DATE...
此命令的意思是在每天的15点15分使用oracle用户执行脚本/home/oracle/backup/backup.sh...
cuiji1279的博客
01-26 132
此命令的意思是在每天的15点15分使用oracle用户执行脚本/home/oracle/backup/backup.sh 修改第一个域的参数会改变执行的分钟，修改第二个参数会改变执行的小时，修改，修改第三个参数会修改执行的日期，...
oracle10g全文索引自动同步语句使用方法
09-10
在创建索引时指定此参数，如：`create index MY_INDEX on t(object_name) indextype is ctxsys.context parameters('sync (every "sysdate+(1/96)")')`，这里表示每隔15分钟同步一次（1/96天相当于15分钟，因为1天有...
完美Oracle数据库知识学习文档总汇.docx
11-19
首先，DDL（Data Definition Language）是用于创建和修改数据库对象如表、视图、索引等的SQL语句。在Oracle中，执行DDL语句时，系统会自动进行隐式提交，这意味着在DDL语句执行前的所有未提交更改都将被提交，无法...
oracle AWR报告解读
最新发布
05-09
Oracle AWR（Automatic Workload Repository）报告是Oracle数据库性能监控的重要工具，主要为数据库管理员提供系统性能的详细信息。这份报告适用于新手数据库运维人员和系统维护人员，帮助他们理解和诊断数据库性能...
oracle命令中英文对照.doc
06-14
Oracle数据库是世界上最流行的数据库管理系统之一，它提供了丰富的SQL命令来管理数据、定义数据结构和控制数据库操作。在本文中，我们将深入探讨Oracle命令的主要类别及其功能。 **数据操作** 1. **SELECT**: 用于...
sql计算班组func.zip_oracle_sql_某个时间班组
09-21
1. **日期函数**: Oracle提供了一系列日期函数，如`SYSDATE`获取当前系统日期，`ADD_MONTHS`增加或减少月份，`TRUNC`截断日期到指定的精度（如年、月、日等），`EXTRACT`提取日期/时间的特定部分（如小时、分钟等）...
Oracle入门笔记（五）——Oracle表间关系、SQL语句、基本函数
weixin_46560512的博客
03-24 1005
主要介绍Oracle表间关系、SQL语句、基本函数的使用
查询两条数据间隔5分钟或10分钟内的人员或设备
cdsn123jian的专栏
01-18 914
比如要查处5分钟间隔的人员或设备，或15分钟间隔的人员或设备 思路也简单：按时间排序，按设备或人员分组，查出第二条数据列表，在用exists 进行设备或人员的一条条关联查询，在用每个设备或人员的所有时间去比对第二条数据的时间，如果时间大于5，10分钟，则能查出所要的人员或设备。 select * from device_today dt2 where exists ( select 1 from (select * from ( SELECT ...
oracle按15分钟统计数据,oracle 按时间段统计15分钟内的数据
weixin_28964839的博客
04-02 1113
string sql = "select to_char(StartTime, ‘yyyy‘)||‘-‘|| to_char(StartTime, ‘mm‘)||‘-‘||to_char(StartTime, ‘dd‘)||‘ ‘|| to_char(StartTime, ‘hh24‘)||‘:‘||floor(to_char(StartTime, ‘mi‘)/15)*15 statime, su...
oralce 查询一天每隔15分钟一个点 时刻
m0_37372422的博客
07-18 1317
oralce 查询一天每隔15分钟一个点 15分钟 select to_char((daybegin + (level - 1) * 15 / 1440), ‘hh24:mi’) as this15time from (select (trunc(sysdate, ‘dd’)) as daybegin from dual) connect by level <= 96 例如 每隔5分钟的话...
oracle按15分钟统计数据,统计每15分钟内的数据量
weixin_35752122的博客
04-02 1650
大家好：小弟遇到一个关于数据统计方面的问题。具体这样：统计每15分钟内的数据量(从晚上0点开始算，就是00:00,00:15,00:30,00:45.....23:30,23:45)想得到如下效果时间点 SUM00:00 100:15 1000:30 1000:45 .。 .。。23:30 ...
vc6.0在oracle数据库中创建表读取表语句
04-24
因此，我无法直接帮助您执行创建和读取表语句。不过，我可以告诉您一些基本的语法和步骤。 在Oracle数据库中，可以使用以下语句来创建一个表： CREATE TABLE table_name ( column1 datatype [ NULL | NOT NULL ],...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值