oralce

-- Create table
		2	create table USERTBL
		3	(
		4	ID NUMBER(10) not null,
		5	NAME VARCHAR2(255 CHAR),
		6	PASSWORD VARCHAR2(255 CHAR),
		7	AGE NUMBER(10)
		8	)
		9
		10	-- 查看oracle的所有table
		11
		12	select * from user_tables; //当前用户的表
		13
		14	select * from all_tables; //所有用户的表
		15
		16	select * from dba_tables; //包括系统表
		17
		18	/**
		19	all_tables = dba_tables union all DBA_OBJECT_TABLES
		20	**/
		21
		22
		23
		24
		25	select * from USERTBL;
		26
		27	-- 插入数据
		28	insert into USERTBL values(1,'hanliangyuan','123456','25')
		29
		30	select count(*) from USERTBL;
		31
		32	commit;
		33
		34	-- 循环插入
		35	begin
		36	for i in 2..10 loop
		37	insert into USERTBL values(i,'hanliangyuan'||i,'123456','25');
		38	end loop;
		39	end;
		40
		41	select * from USERTBL;
		42
		43	commit;
		44
		45	-- 更新
		46	update USERTBL
		47	set name = 'hanliangyuan1'
		48	where name = 'hanliangyuan'
		49
		50	commit;
		51
		52	-- 标题: 什么命令可以查看tablespace!
		53
		54	以dba权限用户登陆:
		55
		56	select * from dba_tablespaces;
		57
		58	select * from user_tablespaces;
		59
		60	select * from v$tablespace;
		61
		62
		63
		64	-- 查看所有用户
		65
		66	select * from user_users; //当前用户
		67
		68	select * from all_users; //所有用户
		69
		70	select * from dba_users; //包括系统用户