- 博客(7)
- 资源 (3)
- 收藏
- 关注
原创 Oracle插入随机生成的数据行
我们将向OE.ORDERS表中插入10万行数据,这10万行数据是随机生成的DECLARE order_id INT; customer_id INT; ORDER_MODE VARCHAR(10); ORDER_TOTAL NUMBER(10,2); ORDER_STATUS INT;BEGIN SELECT MAX(order_id) INTO order_id F
2016-12-29 18:01:06 3095
原创 Oracle按日期累计求和
求各个部门在员工入职时(年份-月份)的该部门的总人数写法1:SELECT DISTINCT HIRE_YEAR_MONTH, DEPARTMENT_ID, COUNT_FROM (SELECT DEPARTMENT_ID, TO_CHAR(HIRE_DATE, 'yyyy/mm') HIRE_YEAR_MONTH, COUNT(*) OVER(PARTITION BY DEPARTMEN
2016-12-14 19:38:41 10472
原创 Sql分组统计top-n或bottom-n
各个部门工资最高的前N个员工Oracle写法SELECT department_id, first_name, last_name, salaryFROM( SELECT department_id, first_name, last_name, salary, ROW_NUMBER() OVER (PARTITION BY department_id ORDE...
2016-12-09 17:21:08 1642
原创 常见Oracle日期处理问题
How to know what date it is today SELECT TO_CHAR(SYSDATE, 'D') INTO W_D FROM DUAL; or SELECT TO_CHAR(SYSDATE, 'DAY') INTO W_D FROM DUAL;1 means Sunday 7 means SaturdayHow to get Weekends from a p
2016-12-07 20:48:54 763
原创 Oracle Frequently Encountered Questions
-Can I use ```INSERT INTO TABLE VALUES (...),(...),(...)```?(20161202)-How to create Trigger for auto-increment ID when inserting rows.(20161202)
2016-12-01 16:49:40 454
谷歌跨域插件 Allow-Control-Allow-Origin
2020-11-16
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人