随笔分类 -  sql

摘要：１语法： create table 表名 as select .......... 2用处： 是复制表结构和表数据 3例子：（1*） SQL> create table tt as select * from dept;Table created.SQL> select * from dept; D 阅读全文

摘要：一：典型安装的情况下包括Scott用户 ，默认情况下是锁定的状态，可以通过命令行来进行解锁； -:SQL> alter user scott account unlock identefied bu tiger;alter user scott account unlock identefied b 阅读全文

摘要：1:select distinct department_id from employees; 2:select distinct department_id from employees where department_id is not null; 3:select distinct depa 阅读全文

摘要：sql> startup ORA-01081：cannot start already-running ORACLE-shut it down first 数据库已经启动了，首先你要关掉它，才可以启动数据库。 sql> shutdown immediate 阅读全文

摘要：1 show user2 conn / as sysdba 3:alter user hr account unlock baocuo ORA-01017 1:conn / as sysdba 2: alter user hr identified by hr ; conn hr/hr 以上是关于h 阅读全文