Oracle数据库命令记录

来源：互联网发布：java项目描述怎么写编辑：程序博客网时间：2024/06/15 16:51

1，查找重复项：
select * from VIEW_INIT_GPS_TARGET where V_TERMINAL_ID in ( select V_TERMINAL_ID from VIEW_INIT_GPS_TARGET group by V_TERMINAL_ID having count (V_TERMINAL_ID) > 1);
2，
select * from VIEW_INIT_GPS_TARGET t where t.v_dept_id in (SELECT DISTINCT (d.v_dept_id) FROM gps_dept d CONNECT BY PRIOR d.v_dept_id = d.v_dept_parentid
START WITH d.v_dept_id ='XXXXXXXXXXXXXXXXXXX');
3，
select t.v_targ_name,count(t.v_targ_name) from VIEW_INIT_GPS_TARGET t group by t.v_targ_name;
4，清空表空间命令：truncate table 表名字

5，通过设备ID查找数据
select * from gps_equp t where t.v_equp_id = 'xxx';

6，通过车牌号查找车辆id
select * from gps_targ_detail d where d.v_targ_id =( select v_targ_id from gps_targ g where g.v_targ_name='鲁H1001')
7，查找索引
select * from user_indexes
8，更新车主联系方式：
select * from gps_targ_detail d where d.v_targ_id =( select v_targ_id from gps_targ g where g.v_targ_name='鲁H1001')

update gps_targ_detail d set d.v_targ_ownertel = 'xxxx' where d.v_targ_id =( select v_targ_id from gps_targ g where g.v_targ_name='鲁H1001')

9，用windows的cmd进行oracle连接：
sqlplus username/passwd@192.168.1.233:1521/ora11g
cmd查询oralce数据，并带条件：
select * from gps_user u where u.v_user_id = 'xxxxxxxxxxxxxxxxxxx'

10，BEGIN PAK_QUERY_BASICDATA.PRC_LOGIN(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;，关于这一条，其实际是一个函数，可在233数据库packages->PAK_QUERY_BASICDATA->PRC_LOGIN函数里面看到具体的细节内容。

0 0