Oracle
关注
分享
扫一扫
DcuiF
Rome was not built in a day
展开
-
Oracle中创建用户
create user yun3151 identified by yun3151 default tablespace myschooltemporary tablespace tempdesc dba_usersselect username from dba_userswhere account_status='OPEN'grant connect,r原创 2017-02-26 20:12:02 · 825 阅读 · 0 评论 -
Oracle中授予创建同义词
grant create any synonym to scottgrant create public synonym to scottgrant drop public synonym to scott原创 2017-02-26 20:29:56 · 422 阅读 · 0 评论 -
Oracle中plsql游标
set serveroutput ondeclare cursor cr_dept (dno number)is select * from dept where deptno=dno; row_dept dept%rowtype;begin open cr_dept(20); fetch cr_dept into row_dept;原创 2017-02-26 20:22:27 · 239 阅读 · 0 评论 -
Oracle中修改密码，账号解锁
步骤1.现在运行窗口输入 sqlplus/nolog2.conn /as sysdba3 alter user system identified by system(改密码）4.alter user scott account unlock(解账户）原创 2017-02-26 20:25:39 · 350 阅读 · 0 评论 -
Oracle中
create table employyasselect * from studentselect * from employy原创 2017-02-26 20:24:31 · 236 阅读 · 0 评论 -
Oracle中plSql中If语句
set serveroutput ondeclarev_socre number:=80;begin if v_socre>=80 then dbms_output.put_line('优秀'); elsif v_socre>=60 then dbms_output.put_line('良好'); else dbms_output.put_l原创 2017-02-26 20:21:51 · 5322 阅读 · 1 评论 -
Oracle中plsqlCase语句
set serveroutput ondeclare v_score number; begin v_score:=99; case when v_score>=80 then dbms_output.put_line('优秀'); when v_score>=60 then dbms_output.put_line('良好'); else db原创 2017-02-26 20:19:34 · 916 阅读 · 0 评论 -
Oracle中创建表空间
create tablespace myschooldatafile 'd:\Oracledb\myschool.dbf'size 20mautoextend onmaxsize unlimitedalter tablespace myschooladd datafile 'd:\Oracledb\myschoo2.db'size 40mdrop t原创 2017-02-26 20:09:19 · 311 阅读 · 0 评论 -
Oracle中复制表
create table employyasselect * from studentselect * from employy原创 2017-02-26 20:14:00 · 340 阅读 · 0 评论 -
Oralce的存储过程和函数
1.存储过程可以返回多个值2.函数只能返回一个值3.复合类型记录相对应java类4.复合类型表相对于java里面的数组，他的小标为整数，所以小标有可能为负数。5.游标变量相对应java的集合...原创 2019-04-09 15:01:40 · 258 阅读 · 0 评论