Keepsmileq的博客

create user yun3151 identified by yun3151  default tablespace myschool temporary tablespace temp desc dba_users select username from dba_users where account_status='OPEN' grant connect,r

grant create any synonym to scott grant create public synonym to scott grant drop public synonym to scott

set serveroutput on declare  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;

步骤 1.现在运行窗口输入 sqlplus/nolog 2.conn /as sysdba 3 alter user system identified by system(改密码） 4.alter user scott account unlock(解账户）

create table employy as select * from student select * from employy

set serveroutput on declare v_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

set serveroutput on declare  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

create tablespace myschool datafile 'd:\Oracledb\myschool.dbf' size 20m autoextend on maxsize unlimited alter tablespace myschool add datafile 'd:\Oracledb\myschoo2.db' size 40m drop t

create table employy as select * from student select * from employy

1.存储过程可以返回多个值 2.函数只能返回一个值 3.复合类型记录相对应java类 4.复合类型表相对于java里面的数组，他的小标为整数，所以小标有可能为负数。 5.游标变量相对应java的集合 ...