pky789-CSDN博客

原创 Navicat数据库管理软件

navicat各个版本的下载链接：https://www.navicat.com/download我是用的是目前最新的navicat premium 11.2.7(64-bit),数据库Oracle11gR2(64-bit)以下是我使用的一些情况和记录：优点：轻量级，便于数据库的管理，premium版本可以实现多中数据库的连接，是最推荐的一个版本。当然，也有多个针对不同数据库的版本，可

2016-08-04 18:45:05 467

转载 Oracle试卷02

1. 以系统管理员身份登录，创建账号tom，设置tom的默认表空间为neuspace。为tom分配connect和resource系统角色，获取基本的系统权限。然后为tom分配对用户scott的表emp的select权限。（5分）2. 按如下要求创建表class和student。（10分）属性类型(长度)默认值约束含义

2016-05-15 21:58:17 5114

转载 Oracle试卷01

Java数据库编程测试题一、下面是《学员操评系统》的数据库的基本表的设计：表1：学员基本信息字段类型长度是否空约束说明学号char13否主键姓名varchar8否性别

2016-05-15 21:46:42 679

转载 PLSQL练习

--使用pl/sql块编程实现，注意必要的异常处理。--1 输入一个员工号，输出该员工的姓名、薪金和工作时间（按年月日显示）。DECLAREemp_name SCOTT.EMP.ename%type;emp_sal SCOTT.EMP.sal%type;emp_hiredate SCOTT.EMP.hiredate%type;BEGIN select enam

2016-05-15 21:38:36 1681

转载 oracle查询练习2

1 显示所有雇员名、雇员工资及所在部门名--select ename 雇员名,sal 雇员工资,dname 部门名 from emp,dept where emp.deptno=dept.deptno;select ename 雇员名,sal 雇员工资,dname 部门名 from emp,dept where emp.deptno=dept.deptno;2 显示部门代码为20的

2016-04-29 12:00:33 6289

转载 Oracle查询练习1

1.创建用户并且授予权限create user linklin identified by 123;grant create session to linklin;grant create table to linklin;grant create tablespace to linklin;grant unlimited tablespace to linklin;

2016-04-26 22:02:04 781

原创 Oracle服务详解

电脑配置：Oracle 11g，win7 64位操作系统，AMD处理器。首先得安装oracle，安装完后会发现电脑多了七个服务：OracleServiceORCL 默认自动启动 OracleOraDb11g_home1TNSListener 默认自动启动OracleOraDb11g_home1ClrAgent 默认手动启动OracleMTSRecoveryService

2016-04-24 12:18:39 1006

原创 MicroSoft Office 2007各版本解析

Microsoft Office Basic 2007：此版本只仅包含了最基本的应用程序：Word、Excel和Outlook。Microsoft Office Home & Student 2007：包含了Word、Excel、PowerPoint和OneNote。 Microsoft Office Standard 2007：

2015-01-11 14:20:57 860

原创统计页码中数字出现的次数

//方法：拆分数字法 #includeint main(){ int n,a[10]={0},i,j,t; scanf("%d",&n); for(i=0;i<=n;i++) { j=i; while(j) { t=j%10; j/=10; a[t]++; } } for(j=0;j<10;j++) printf("%d出现的次数：%d\n

2014-03-05 20:40:04 1222 1

原创 HDU_2042 不容易系列之二

不容易系列之二Time Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 13233 Accepted Submission(s): 10649Problem Description你活的不容易，我活的不容易，他活的也不容

2013-10-15 01:26:28 474

原创 HDU_2123 An easy problem

An easy problemTime Limit: 5000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 4511 Accepted Submission(s): 3151Problem DescriptionIn this proble

2013-09-18 20:41:49 449

原创 HDU_2561 第二小整数

第二小整数Time Limit: 3000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 5428 Accepted Submission(s): 3420Problem Description求n个整数中倒数第二小的数。每一个整数都独立

2013-09-16 21:14:48 608

原创 HDU_2524 矩形A + B

矩形A + BTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 3355 Accepted Submission(s): 2546Problem Description给你一个高为n ，宽为m列的网格，计算出这个

2013-09-16 20:52:01 441

原创 HDU_1018 big number

Big NumberTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 21581 Accepted Submission(s): 9713Problem DescriptionIn many applicatio

2013-09-13 20:55:43 354

原创 HDU_2101 A + B Problem Too

A + B Problem TooTime Limit: 3000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 9531 Accepted Submission(s): 7185Problem DescriptionThis problem

2013-09-12 21:42:35 426

原创 HDU_2114 Calculate S(n)

Calculate S(n)Time Limit: 10000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 6292 Accepted Submission(s): 2384Problem DescriptionCalculate S(n)

2013-09-12 21:29:04 819

原创 HDU_2098 分拆素数和

分拆素数和Time Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 16771 Accepted Submission(s): 7333Problem Description把一个偶数拆成两个不同素数的和，有几种拆法呢？

2013-09-11 21:35:31 379

原创 HDU_2097 Sky数

Sky数Time Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 10738 Accepted Submission(s): 6260Problem DescriptionSky从小喜欢奇特的东西，而且天生对数字特别敏感

2013-09-11 21:04:44 511

原创 HDU_1013 Digital Roots

Digital RootsTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 40201 Accepted Submission(s): 12398Problem DescriptionThe digital root of

2013-09-09 20:15:13 399

原创 HDU_1040 As Easy As A+B

As Easy As A+BTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 30150 Accepted Submission(s): 12916Problem DescriptionThese day

2013-09-08 21:12:58 367

原创 HDU_1012 u Calculate e

u Calculate eTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 24962 Accepted Submission(s): 11109Problem DescriptionA simple mathematica

2013-09-08 12:42:47 396

原创 HDU_2081 手机短号

手机短号Time Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 13340 Accepted Submission(s): 8459Problem Description大家都知道，手机号是一个11位长的数字串，同时，作为学生，还

2013-09-06 23:47:51 639

原创 HDU_2052 Picture

PictureTime Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 13141 Accepted Submission(s): 6838Problem DescriptionGive you the width and heig

2013-09-06 23:18:08 473

原创 HDU_2092 整数解

整数解Time Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 16640 Accepted Submission(s): 5782Problem Description有二个整数，它们加起来等于某个整数，乘起来又等于另

2013-09-06 14:40:35 483

原创 HDU_2071 Max Num

Max NumTime Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 10955 Accepted Submission(s): 7036Problem DescriptionThere are some st

2013-09-05 23:44:43 629

原创 HDU_2075

***长春赛区网络选拔赛时间有改变，详见杭电ACM新浪微博***A|B?Time Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 9770 Accepted Submission(s): 7582

2013-09-05 21:24:41 521

原创 HDU_2053 Switch Game

Switch GameTime Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 8918 Accepted Submission(s): 5327Problem DescriptionThere are many

2013-09-05 20:46:11 682

原创 HDU_2055 An easy problem

An easy problemTime Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 11067 Accepted Submission(s): 7561Problem Descriptionwe define

2013-09-05 20:36:39 722

原创 HDU_2057 A + B Again

A + B AgainTime Limit: 1000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 12160 Accepted Submission(s): 5314Problem DescriptionThere must be

2013-09-05 19:42:42 539

原创 HDU_2040

亲和数Time Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 16552 Accepted Submission(s): 10324Problem Description古希腊数学家毕达哥拉斯在自然数研究中

2013-09-02 20:24:29 390

原创素数判定

改进算法：#include#includeint prime(int a){if(a==2)return 1;if(aint i;for(i=3;i{if(a%i==0){return 0;break;}}return 1;};int main(){int a,b,i;scanf("%d%d",&a,&b);f

2013-08-23 17:28:10 428

原创 HDU_1465 不容易系列之一

不容易系列之一Time Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 11922 Accepted Submission(s): 4975Problem Description大家常常感慨，要做好一件事情真的不

2013-08-23 11:13:53 399

原创 HDU_1161 Eddy's mistakes

Eddy's mistakesTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 6147 Accepted Submission(s): 3487Problem DescriptionEddy usual

2013-08-21 20:36:45 365

原创关于next_permutation的用法

next_permutation是STL中的一个函数，头文件是#include,作用是生成全排列，默认是后一个比前一个大例如aacc，生成全排列后为：acac acca caac caca ccaa ，根据ASCALL码的顺序排列，加上本身共6个！函数模型：bool next_permutation(first, last);bool next_permutation(fir

2013-08-21 15:44:29 864

原创 HDU_1005 Number Sequence

Number SequenceTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 84042 Accepted Submission(s): 19920Problem DescriptionA number

2013-08-21 11:34:00 368

原创 HDU_1004 Let the Balloon Rise

Let the Balloon RiseTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 58567 Accepted Submission(s): 21505Problem DescriptionCon

2013-08-21 10:20:56 371

原创 HDU_1003 Max Sum

Max SumTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 114708 Accepted Submission(s): 26587Problem DescriptionGiven a sequence a[

2013-08-21 09:32:47 353

原创 HDU_2036 改革春风吹满地

改革春风吹满地Time Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 14789 Accepted Submission(s): 7549Problem Description“ 改革春风吹满地,不会AC没

2013-08-20 20:09:32 400

原创 HDU_2035 人见人爱A^B

人见人爱A^BTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 16969 Accepted Submission(s): 12051Problem Description求A^B的最后三位数表示的整数。

2013-08-20 19:43:57 365

原创 HDU_2034 人见人爱A-B

人见人爱A-BTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Others)Total Submission(s): 34905 Accepted Submission(s): 9824Problem Description参加过上个月月赛的同学一定还记得其

2013-08-20 17:17:09 418

空空如也

oracle关于序列的nextval取值