java（学习笔记第29天）

1、calendar c=c....getInstance();//取当前时间
c1.setTime(Date);

2、basePath   动态生成的相对路径的相对位置
lsnrctl start
oradim -startup -sid orcl

3、sqlplus
alter user scott account
disconn

4、
app/wzg/product/11.2.0/dbhome/network/admin

5、权限
   sys
   sqlplus/as
   sysdba
   scott
6、复制表格
   select table_name from user_tables;
   conn sys/orcl@192.168.3.6:1521/orcl as sysdba;
   creat table junfeng.dept as select * from scott.dept;
   creat table emp as select * from scot.emp;//创建与emp表相同的表

7、创建用户
   create user yan identified by yan;
   grant connect,resource to yan;
   grant unlimited tablespace to yan;
   create table yan.dept as select * from scott.dept;
   create table yan.emp as select * from scott.emp;

   set linesize 200;
8、显示当前用户
  show user
9、创建表
  create table users(id int,name varchar(10));
  create table junfeng.users(id int);
10、插入
  insert into users values(1,'a');
11、赋予权限 any
  grant crate resouce,connect to cao;
  grant crate table to cao;
  grant create any table to cao;
  grant unlinited tablespace to cao;

12、网络配置
  lsnrctl start listener1
13、
    二步：alter user scott account unlock;   //解 锁
    一步：sqlplus / as sysdba     //最高权限管理员进入SQL

http://itszt.losoon.com/plus/view.php?aid=305