摘要:
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 阅读全文