-
工具栏编辑行号（编辑器） 连接其他数据库 mysql用户名root查看全部
-
瀑布模型查看全部
-
光标的属性：%found %notfound %isopen %rowcount查看全部
-
光标的限制：默认情况下，oracle数据库只允许在同一个会话中，打开300个光标查看全部
-
光标的属性： %found %notfound %isopen:判断光标是否打开 %rowcount:影响的行数查看全部
-
insert into teacher values(9611,'TURNER','PROFESSOR','8-Sep-2018',6000,1000,9468,40); insert into teacher values(9612,'ADAMS','ASSOCIATE PROFESSOR','12-Jan-17',4800,800,9611,40); insert into teacher values(9613,'JAMES','LECTURER','3-Dec-19',2800,200,9611,40); insert into teacher values(2031,'FORD','PROFESSOR','3-Dec-18',5500,null,9468,50); insert into teacher values(2032,'MILLER','ASSOCIATE PROFESSOR','23-Jan-2018',4300,null,2031,50); insert into teacher values(2033,'MIGEAL','LECTURER','23-Jan-2019',2900,null,2031,50); insert into teacher values(2034,'PEGGY','LECTURER','23-Jan-2020',2800,null,2031,50);查看全部
-
insert into teacher values(9468,'CHARLES','PROFESSOR','17-Dec-17',8000,1000,null,10); insert into teacher values(9469,'SMITH','PROFESSOR','17-Dec-17',5000,1000,9468,10); insert into teacher values(9470,'ALLEN','ASSOCIATE PROFESSOR','20-Feb-16',4200,500,9469,10); insert into teacher values(9471,'WARD','LECTURER','22-Feb-17',3000,300,9469,10); insert into teacher values(9581,'JONES','PROFESSOR','2-Apr-2016',6500,1000,9468,20); insert into teacher values(9582,'MARTIN','ASSOCIATE PROFESSOR','28-Sep-2018',4000,800,9581,20); insert into teacher values(9583,'BLAKE','LECTURER','1-May -2019',3000,300,9581,20); insert into teacher values(9791,'CLAKE','PROFESSOR','9-Jun-2016',5500,null,9468,30); insert into teacher values(9792,'SCOTT','ASSOCIATE PROFESSOR','09-Dec-17',4500,null,9791,30); insert into teacher values(9793,'BAGGY','LECTURER','17-Nov-2017',3000,null,9791,30);查看全部
-
insert into dep values(10,'计算机学院',9469,'62785234'); insert into dep values(20,'自动化学院',9581,'62775234'); insert into dep values(30,'无线电学院',9791,'62778932'); insert into dep values(40,'信息管理学院',9611,'62785520'); insert into dep values(50,'微纳电子学院',2031,'62797686');查看全部
-
alter table dep add(constraint pk_deptno primary key(dno)); alter table dep add(constraint dno_number_check check(dno>=10 and dno<=50)); alter table dep modify(tel default 62795032); alter table student add(constraint pk_sno primary key(sno)); alter table student add(constraint sex_check check(sex='男' or sex='女')); alter table student modify(birth default sysdate); alter table course add(constraint pk_cno primary key(cno)); alter table sc add(constraint pk_key primary key(cno,sno)); alter table teacher add(constraint pk_tno primary key(tno)); alter table sc add(foreign key(cno) references course(cno)); alter table sc add(foreign key(sno) references student(sno)); alter table student add(foreign key(dno) references dep(dno)); alter table teacher add(foreign key(deptno) references dep(dno));查看全部
-
create table dep( dno number(2), dname varchar2(30), director number(4), tel varchar(8) ); create table teacher( tno number(4), tname varchar2(10), title varchar2(20), hiredate date, sal number(7,2), bonus number(7,2), mgr number(4), deptno number(2) ); create table student( sno number(6), sname varchar2(8), sex varchar2(2), birth date, passwd varchar2(8), dno number(2) ); create table course( cno varchar2(8), cname varchar2(20), credit number(1), ctime number(2), quota number(3) ); create table sc( sno number(6), cno varchar2(8), grade number(3) );查看全部
-
pmon（process monitor） 会在异常发生以后关闭多余资源查看全部
-
系统例外: 1.No_date_found(没有找到数据) 2.Too_many_rows (select...into语句匹配多个行) 3.Zero_Divide (被零除) 4.Value_error (算术或转换错误) 负数开平方等and abc转成数字222 5.Timeout_on_resource (等待资源时发生超时)查看全部
-
数据库 参数设置查看更改 SQL> show user --切换到管理员 SQL>conn sys/password@192.168.56.101:1521/orcl as sysdba SQL>show parameter cursor --模糊查询 alter system set open_cursors =400 scope =both; scope 取值： both， memory（只更改当前实例）， spfile（只更改参数文件 需重启数据库）查看全部
-
%found %nofound %isopen %rowcount 影响行数查看全部
-
open cursor;close cursor; 事务隔离级别为read committed ACID 原子性 一致性 隔离性 持久性查看全部
举报
0/150
提交
取消