摘要:
alter system set db_recovery_file_dest_size=4g scope=both; connect system/1qaz2wsx as sysdba; archive log list; shutdown immediate; startup mount; alt 阅读全文
摘要:
create directory dump_dir as 'd:\dump'; grant read,write on directory dump_dir to scott; --在cmd下 expdp scott/1qaz2wsx directory=dump_dir dumpfile=tab. 阅读全文
摘要:
create or replace procedure trun_table(table_deleted in varchar2) as --创建一个存储过程,传入一个表示表名称的参数,实现清空指定的表 cur_name integer;--定义内部变量,存储打开的游标 begin cur_name 阅读全文
摘要:
create user mr identified by mrsoft default tablespace users temporary tablespace temp; create user east identified by mrsoft default tablespace users 阅读全文
摘要:
create index emp_deptno_index on emp(deptno) pctfree 25 tablespace users; create bitmap index emp_salary_bmp on employees(salary) tablespace users; co 阅读全文
摘要:
col tablespace_name for a10 col file_name for a50 col bytes for 999,999,999 select tablespace_name,file_name,bytes from dba_data_files order by tables 阅读全文
摘要:
set serveroutput on declare a int:=100; b int:=200; c number; begin c:=(a+b)/(a-b); dbms_output.put_line(c); exception when zero_divide then dbms_outp 阅读全文
摘要:
select empno,ename,sal from scott.emp; SELECT empno,ename,sal FROM scott.emp; selECT empno,ename,sal frOM scott.emp; select empno,ename,sal from scott 阅读全文
摘要:
set pause on set pause '按<enter>键继续' select user_id,username,account_status from dba_users; show newpage set newpage 1 select user_id,username,account 阅读全文