Migrating Queries from One User To Another从一个用户迁移到另一个查询
来源:互联网 发布:tensorflow可视化 编辑:程序博客网 时间:2024/04/30 12:27
If you ever have a need to migrate queries from one user to another, you can do it quickly and easily with this useful SQL script. If you want to make the Query Public, simply change the NEWPSUSERID to a blank.
- UPDATE PSQRYDEFN SET OPRID = 'NEWPSUSERID'WHERE OPRID = 'OLDPSUSERID'
- UPDATE PSQRYRECORD SET OPRID ='NEWPSUSERID' WHERE OPRID ='OLDPSUSERID'
- UPDATE PSQRYFIELD SET OPRID = 'NEWPSUSERID'WHERE OPRID = 'OLDPSUSERID'
- UPDATE PSQRYEXPR SET OPRID ='NEWPSUSERID' WHERE OPRID ='OLDPSUSERID'
- UPDATE PSQRYBIND SET OPRID = 'NEWPSUSERID'WHERE OPRID = 'OLDPSUSERID'
- UPDATE PSQRYSELECT SET OPRID ='NEWPSUSERID' WHERE OPRID ='OLDPSUSERID'
- UPDATE PSQRYSTATS SET OPRID = 'NEWPSUSERID'WHERE OPRID = 'OLDPSUSERID'
- UPDATE PSQRYPREFS SET OPRID ='NEWPSUSERID' WHERE OPRID ='OLDPSUSERID'
- UPDATE PSQRYEXECLOG SET OPRID = 'NEWPSUSERID'WHERE OPRID = 'OLDPSUSERID'
- UPDATE PSQRYDEL SET OPRID ='NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID
- Migrating Queries from One User To Another从一个用户迁移到另一个查询
- Migrating Queries from One User To Another
- 从一个表的数据拷贝到另一个表,Copy all columns from one table to another table:
- Android Activity – From One Screen To Another Screen从一个屏幕切换到另一屏幕,Intent
- How to export/import data with LOB type from one user/schema to another
- Transferring Data from One Table to Another
- copy from one array to another
- Transfer Statistics from one Database to Another
- SQL:数据从一个表迁移到另一个表
- 如何将App从一个账号迁移到另一个账号?
- 从LM3S到LM4F TM4C ARM Cortex-M4 : Migrating Software Projects from StellarisWare® to TivaWare™
- 将数据从一个用户转移到另一个用户下
- How to switch to another database in oracle 11g(如何在oracle中从一个数据库切换到另一个数据库)
- 把数据从一个form传递到另一个from
- BAPI to Copy Materials from one Plant to Another
- BAPI to Copy Materials from one Plant to Another
- BAPI to Copy Materials from one Plant to Another
- BW--ABAP to copy aggregates from one cube to another
- error while loading shared libraries: libclntsh.so.10.1cannot open shared 问题解决
- C++常见的内存错误及其对策
- SVN提交报错(SVN的bug)
- MySQL 参考网址
- socket学习之电脑手机通信
- Migrating Queries from One User To Another从一个用户迁移到另一个查询
- 一个简单的计算从1到1000000000所花时间的小程序
- Jquery常用技巧和方法收集
- 子网掩码 子网划分
- 抓取Foursquare网页信息的爬虫
- 京东陷入融资与扩张怪圈
- 求四个数的最大公约数
- VirtualBox 中共享文件夹的设置
- 堆和栈的区别