Menu

menu:
首页: /
归档: /archives
标签: /tags
分类: /categories

you can create tags and categories folders in ../source.

And create a index.md file in each of them.

set front-matteras

layout: tags (or categories)

title: tags (or categories)

—

Widgets

widgets:

• github-card
• category
• tag
• archive
• tagcloud
• rss

  provide eight widgets:github-card,category,tag,rss,archive,tagcloud,links,weibo

RSS

rss: /atom.xml ## RSS address.

Image

imglogo:
enable: true ## display image logo true/false.
src: img/logo.png ## .svg and .png are recommended,please put image into the theme folder /jacman/source/img.
favicon: img/favicon.ico ## size:32px32px,.ico is recommended,please put image into the theme folder /jacman/source/img.
apple_icon: img/jacman.jpg ## size:114px114px,please put image into the theme folder /jacman/source/img.
author_img: img/author.jpg ## size:220px220px.display author avatar picture.if don’t want to display,please don’t set this.
banner_img: #img/banner.jpg ## size:1920px200px+. Banner Picture

Theme Color

theme_color:
theme: ‘#2ca6cb’ ##the defaut theme color is blue

代码高亮主题

available: default | night

highlight_theme: default

index post is expanding or not

index:
expand: true ## default is unexpanding,so you can only see the short description of each post.
excerpt_link: Read More

close_aside: false #close sidebar in post page if true
mathjax: false #enable mathjax if true

Creative Commons License Support, see http://creativecommons.org/

you can choose: by , by-nc , by-nc-nd , by-nc-sa , by-nd , by-sa , zero

creative_commons: none

Author information

author:
intro_line1: “程序员上辈子都是折翼的天使” ## your introduction on the bottom of the page
intro_line2: “This is my blog,Try to do better.” ## the 2nd line
weibo: ## e.g. wuchong1014 or 2176287895 for http://weibo.com/2176287895
weibo_verifier: b3593ceb ## e.g. b3593ceb Your weibo-show widget verifier ,if you use weibo-show it is needed.
tsina: ## e.g. 2176287895 Your weibo ID,It will be used in share button.
douban: ## e.g. wuchong1014 or your id for https://www.douban.com/people/wuchong1014
zhihu: ## e.g. jark for http://www.zhihu.com/people/jark
email: ## e.g. imjark@gmail.com
twitter: ## e.g. jarkwu for https://twitter.com/jarkwu
github: tengj ## e.g. wuchong for https://github.com/wuchong
facebook: ## e.g. imjark for https://facebook.com/imjark
linkedin: ## e.g. wuchong1014 for https://www.linkedin.com/in/wuchong1014
google_plus: ## e.g. “111190881341800841449” for https://plus.google.com/u/0/111190881341800841449, the “” is needed!
stackoverflow: ## e.g. 3222790 for http://stackoverflow.com/users/3222790/jark

if you set them, the corresponding share button will show on the footer

Toc

toc:
article: true ## show contents in article.
aside: true ## show contents in aside.

you can set both of the value to true of neither of them.

if you don’t want display contents in a specified post,you can modify front-matter and add toc: false.

Links

links:

Comment

duoshuo_shortname: 嘟嘟MD ## e.g. wuchong your duoshuo short name.
disqus_shortname: ## e.g. wuchong your disqus short name.

Share button

jiathis:
enable: false ## if you use jiathis as your share tool,the built-in share tool won’t be display.
id: ## e.g. 1889330 your jiathis ID.
tsina: ## e.g. 2176287895 Your weibo id,It will be used in share button.

Analytics

google_analytics:
enable: false
id: ## e.g. UA-46321946-2 your google analytics ID.
site: ## e.g. wuchong.me your google analytics site or set the value as auto.

You MUST upgrade to Universal Analytics first!

https://developers.google.com/analytics/devguides/collection/upgrade/?hl=zh_CN

baidu_tongji:
enable: true
sitecode: e6d1f421bbc9962127a50488f9ed37d1 ## e.g. e6d1f421bbc9962127a50488f9ed37d1 your baidu tongji site code
cnzz_tongji:
enable: false
siteid: ## e.g. 1253575964 your cnzz tongji site id

Miscellaneous

ShowCustomFont: true ## you can change custom font in variable.styl and font.styl which in the theme folder /jacman/source/css.
fancybox: true ## if you use gallery post or want use fancybox please set the value to true.
totop: true ## if you want to scroll to top in every post set the value to true

Custom Search

google_cse:
enable: false
cx: ## e.g. 018294693190868310296:abnhpuysycw your Custom Search ID.

https://www.google.com/cse/

To enable the custom search You must create a “search” folder in ‘/source’ and a “index.md” file

set the ‘front-matter’ as

layout: search

title: search

—

baidu_search: ## http://zn.baidu.com/
enable: false
id: ## e.g. “783281470518440642” for your baidu search id
site: http://zhannei.baidu.com/cse/search ## your can change to your site instead of the default site

tinysou_search: ## http://tinysou.com/
enable: false
id: ## e.g. “4ac092ad8d749fdc6293” for your tiny search id

作者：嘟爷MD
链接：https://www.jianshu.com/p/df19bb51c6ea
來源：简书
简书著作权归作者所有，任何形式的转载都请联系作者获得授权并注明出处。

创建表：
create table emp (eno number(2),ename char(14));

数据删除：
delete emp where empno=123;

数据修改：
update emp set ename =’akdi’,job=’maker’ where eno =4;

插入数据：
insert into dept(dname,deptno) values(‘autoo’,10);

从其他表中选择插入数据：
insert into emp (empno, ename) select id,name from old_emp where department in (10,20,30,40);

使用参数：
insert into dept values(&eno,&ename);

查询表：
select * from dept;

修改表名：
alter table 表名 rename to 新表名；

添加数据：
update student set tname =’网站’ where sno =2;

改变字段类型：
alter table T1 modify id char (10);

创建自增字段：（主键）
create table menu( menuId number(10) not null primary key,
/primary key 主键 /
name varchar2(40) not null,
id_parent number(10) not null,
url varchar2(300) null);

创建视图：
create view new as select ename ,job , sal from emp where job =’manager’;

拷贝视图或者表：
create table new2 as select * from emp;

查询不从复值，倒序：
select distinct id,name,adress from T3 order by tid desc;

–绝对值：abs()
select abs (id) value from emp;

–取整函数（大）：ceil（）
select ceil（-2.1）value from emp;

–取整函数（小）：floor()
select floor (-2.1) value from emp;

–四舍五入：round（）
select round (1.235) value from emp ;

–取整函数（截取）：trunc()
select trunc(-2.11) value from emp;

–取平方根：sqrt()
select sqrt() value from emp;

–取随机数： dbms_random (minvalue,maxvalue )
select dbms_random.value (2,7) value from emp;

–取符号：sign()
select sign (-3) value from emp;
select sign (2) value from emp;

–取集合的最大值:greatest(value)
select greatest(-1,3,5,7,9) value from dual; –(9)

–取集合的最小值:least(value)
select least(-1,3,5,7,9) value from dual; –(-1)

–处理Null值：nvl(空值，代替值)
select nvl(null,10) value from dual; –(10)　
select nvl(score,10) score from student;

–rownum小于某个数时可以直接作为查询条件（注意oracle不支持select top）
select * from student where rownum <3;

–区间查询
select from (select rownum rn, student. from student) where rn >3 and rn<6;

–排序+前n条
select from (select rownum rn, t. from ( select d.* from DJDRUVER d order by drivernumber)t )p where p.rn<10;

–排序+区间查询1
select from (select rownum rn, t. from ( select d.* from DJDRIVER d order by DJDRIVER_DRIVERTIMES)t )p where p.rn<9 and="" p.rn="">6;

–排序+区间查询2
select from (select rownum rn, t. from ( select d.* from DJDRIVER d order by DJDRIVER_DRIVERTIMES)t where rownum<9 )p="" where="" p.rn="">6;–效率远高于方式一

–分页查询效率高
select from (select rownum rn, d. from DJDRIVER d where rownum<=20 )p

–在查询的字段后追加符号
select t.id||’%’, t.rowid from table1 t

并一列
select SS a from a1
union
select SS b from b1

to_char(‘xx’,’YYYY’ )变年
substr(F_xada,1,length(F_xada)-4)缩减字段

把数据库授权给yx，授权链接把资源给yx；
grant dba to yx;
grant connect,resource to yx;

NVL条件
NVL(E1, E2)的功能为：如果E1为NULL，则函数返回E2，否则返回E1本身。但此函数有一定局限，所以就有了NVL2函数。
拓展：NVL2函数:Oracle/PLSQL中的一个函数,Oracle在NVL函数的功能上扩展，提供了NVL2函数。NVL2(E1, E2, E3)的功能为：如果E1为NULL，则函数返回E3，若E1不为null，则返回E2。string1和replace_with必须为同一数据类型，除非显式的使用TO_CHAR函数。
select nvl(sum(t.dwxhl),1)
from tb_jhde t

获取当前时间，并赋值：
select
F_PROVINCE,F_CITY,F_COUNTY,F_PROVINCEID,F_CITYID,F_COUNTYID,F_ADRESS,F_TITLE,F_DATAFROM,F_SJLY,F_FSSJ,F_RAINFALL,F_WATERDEPTH,F_WATERTYPE,F_BZ,F_TENANTID
from
W_CSLQFSXX t,
(select trunc(sysdate, ‘yyyy’) as bn from dual) bn
where
to_char(F_DATATIME,’yyyy’) = to_char(bn.bn,’yyyy’)

/创建表空间/
create tablespace yxh
logging
datafile ‘F:\03software\oracle11g\win64_11gR2_database_1of2\oradata\eyv\lwz01.dbf’
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
/删除表空间/
drop tablespace yxh;

=============================================================================

报表传值：：

有参数——-<iframe id=””style=”” frameborder=”0” scrolling=”no” src=”http://10.XX.XXX.XX:8082/art/runReport?public=true&reportId=99&p-year=2015">

下拉框——–
function changeMC(value){
var arry=[‘one’,’two’];
if(value==array[0]){
document.getElementById(‘maji’).src=”http://10.XX.XXX.XX:8082/art/runReport?public=true&reportId=99&p-year=2015"
}
else if (value==array[1]){
document.getElementById(‘maji’).src=”http://10.XX.XXX.XX:8082/art/runReport?public=true&reportId=99&p-year=2016"
}

}

<select id='tt' onchange="changeTzSrc(this.option[this.options.selectedIndex].value)">
<option value=' ' >--请选择--</option>
<option value='one' >1</option>
<option value='two' >2</option>
</select>
<iframe id="maji"style="" frameborder="0" scrolling="no" src="http://10.XX.XXX.XX:8082/art/runReport?public=true&reportId=99&p-year=2015"></iframe>

jsp 传值：

$(fuction(){
$(‘#one’).arrt (“planLength”,”$[start.lenth_sum]”);

});

1、首先进入命令提示符，输入sqlplus指令登录；

2、输入用户名和密码，但要记住用户名需输入system，(因为创建、删除、赋予权限、解锁加锁……都需通过system系统用户执行)；

3、创建用户：create user <用户名> identified by <密码> [default tablespace users];
4、用户创建成功后，给用户赋予权限：greate create session to <用户名>;

5、命令提示符给出授权成功提示后，还可以切换所创建的用户conn <用户名>/<密码> [as <角色>]，验证是否创建成功。
grant create session to yxh;

conn yxh/123456;

-添加数据源：

驱动：oracle.jdbc.OracleDrive

url ： jdbc:oracle:thin:@11X.XX.XXX.XX:1521:orcl