1、客户端开发工具 PL/SQL Developer Version 7.1.5.1398
试用版有30天限制,到了限制时间后,将如下注册表删除,就可以继续使用30天!
HKEY_CURRENT_USER\Software\Allround Automations
HKEY_CURRENT_USER\Software\Microsoft\Security
1、查看用户
select username from dba_users;
2、创建admin用户,密码也为admin,并赋予三个权限
create user admin identified by admin;
grant connect,dba,resource to admin;
3、创建admin用户,密码也为admin,并赋予三个权限
create user admin identified by admin;
grant dba to admin;
grant connect to admin;
grant resource to admin;
5、查看当前用户权限
select * from session_privs;
4、删除用户admin:
drop user admin cascade;
5、查看序列
select * from user_sequences;
6、创建序列,序列名为 t_user_role_seq
create sequence t_user_role_seq cache 20 increment by 1 start with 100 nomaxvalue;
7、删除t_user_role_seq序列
drop sequence t_user_role_seq;
9、Oracle查询用户表空间
select * from user_all_tables;
9、Oracle查询所有函数和储存过程
select * from user_source;
8、查看建立的触发器
select * from user_triggers;
9、导出用户admin密码admin的数据:(在命令行里)
exp admin/admin@172.16.234.184 file=d:\name.dmp
10、导入数据:(在命令行里)
imp admin/admin@orcl file=d:\name.dmp full=y
2、Oracle数据库中一个汉字所占的字节数
这个其实和Oracle的配置是相关的,用以下语句查询:
select * from v$nls_parameters t where t.PARAMETER='NLS_CHARACTERSET';
可以查询到当前数据库的字符集,如果value=GB2312,那么一个汉字占用2个字节,如果value=AL32UTF8,那么一个汉字占用3个字节。
3、存储过程
创建存储过程(vehicle_statistic_infoo)语法:
create or replace procedure vehicle_statistic_infoo IS
BEGIN
DECLARE v_time CHAR(20);
BEGIN
for i in 10..30 loop
v_time:='201107'||i;
insert into vehicle_statistic_info(vehicle_statistic_id,cal_time,statistic_type,static_count,point_id,vehicle_type,front_plate_color,vehicle_colour)
values (sys_guid(),v_time,4,300,101,10197,10192,10190);
end loop;
end;
END;
/
执行存储过程(vehicle_statistic_infoo)语法:
BEGIN
vehicle_statistic_infoo;
END;