Oracle数据库学习Oracle数据库学习............................................................................................................11基本使用....................................................................................................................51.1常用命令........................................................................................................51.1.1Connect/Disconnect数据库连接命令...........................................................51.1.2PL/SQL连接数据库配置，Oracle客户端的配置文件.........................................51.1.3配置Oracle数据库监听Assistant................................................................61.1.4Passw[ord]修改密码命令...........................................................................61.1.5Show显示登录用户....................................................................................61.1.6Clear清屏...............................................................................................61.1.7Exit退出命令...........................................................................................61.1.8文件操作命令............................................................................................61.1.9&交互式命令............................................................................................61.1.10显示和设置环境的变量..........................................................................72用户管理....................................................................................................................72.1用户管理........................................................................................................72.1.1Createuser创建用户................................................................................72.1.2Password修改密码....................................................................................72.1.3Dropuser删除用户....................................................................................72.1.4赋予和收回权限.........................................................................................82.1.5Profile管理用户口令.................................................................................82.1.6给账户解锁...............................................................................................92.1.7终止口令..................................................................................................92.1.8口令历史..................................................................................................92.1.9删除profile文件......................................................................................93数据类型..................................................................................................................103.1字符型..........................................................................................................103.1.1Char定长字符.........................................................................................103.1.2Varchar2变长字符..................................................................................103.1.3Clob字符型大对象..................................................................................103.2数值型..........................................................................................................103.2.1Number数值型......
