Oracle 查看统计信息SCRIPT - Select to show Optimizer Statistics for CBO (Doc ID 31412.1)https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=1638430201757426&id=31412.1&_adf.ctrl-state=17ud5ixo9v_65 [oracle@my2950 admin]$ cd /u01/app/oracle/product/11.2.4/db_1/rdbms/admin[oracle@my2950 ad...【阅读全文】
数据库的启动和关闭startup openshutdown immediate创建用户 create user xxx IDENTIFIED BY xxx;删除用户 drop user xxx cascade;赋权限 grant 权限 to user;收回权限 REVOKE 权限 ON table FROM 用户查看权限&n...【阅读全文】
一、执行多次查询:SQL> beginfor i in 1..100 loopexecute immediate 'select * from emp where empno=' || i;end loop;end;/二、创建测试表SQL> create table test as select sql_text from v$sqlarea; Table created三、添加字段SQL> alter table test add constraintname varchar2(1000); Tab...【阅读全文】