Oracle 常用SQL语句

1.基本查询SQL语句

  sqlplus sys as sysdba                                        //管理员登陆

 ALTER USER mapabc_mobilemap ACCOUNT UNLOCK;  // 解除锁定

  select table_name,num_rows from user_tables;     //查看当前用户所有表名称

  desc tableName;                                                 //查看表结构

  select * from tableName where rownum<=1;           //查看n行信息

  select * from user_tab_comments;                         //获取表注释

  select * from user_col_comments;                         //获取字段注释

  select * from user_sequences where sequence_name='ORDER_USER_SEQ';   //查询序列信息

2.基本表结构操作SQL语句

   alter table t_admin modify (ID varchar2(32));          //修改表字段类型

  

3.导入导出数据

    1. cmd命令行导入dmp文件

      E:\app\shuai.qi\product\11.1.0\db_2\BIN>imp username/pwd file=e:\oracledatabackup0829.dmp

    2.sqlplus命令行导入sql脚本

       sql>@D:/test.sql;

       sql>commit;