文件名称:SQLManage
介绍说明－－下载内容均来自于网络，请自行研究使用
本人在工程上收集的比较常用的oracle sql语句
有问题请发email:leafboyman@tom.com-I collected in the project commonly used oracle sql statement in question please send an email: leafboyman@tom.com
有问题请发email:leafboyman@tom.com-I collected in the project commonly used oracle sql statement in question please send an email: leafboyman@tom.com
(系统自动生成,下载前可以参看下载内容)
下载文件列表
GetAllTables
............\result.sql
............\run.bat
............\run.sql
Oracle8i中生成创建对象的SQL
...........................\Create.bat
...........................\Create.sql
...........................\result.sql
...........................\查看数据库内容.rar
SQL
...\函数大全.txt
...\取整的函数.txt
...\工程维护.sql
...\批量导入.txt
...\表空间.txt
内蒙city
........\city200411
........\..........\result.bat
........\..........\result.sql
........\..........\run.bat
........\..........\run.sql
........\..........\说明.txt
........\result.bat
........\result.sql
........\run.bat
........\run.sql
........\Update
........\......\run.bat
........\......\run.sql
........\......\Update.rar
........\备分内蒙city.rar
........\说明.txt
分区
....\oracle 分区表数据定期迁移到其他数据库测试方案.files
....\...................................................\itpub.gif
....\...................................................\itpubblog.gif
....\...................................................\style.css
....\oracle 分区表数据定期迁移到其他数据库测试方案.htm
....\新建 文本文档.txt
删除所有没有分区的表
....................\result.sql
....................\run.bat
....................\run.sql
....................\run1.sql
删除用户和表空间
................\all.bat
................\all.ftp
................\drop.bat
................\drop.sql
................\drop2.sql
................\result.bat
................\result.sql
备份和恢复
..........\restore.sql
..........\run.sql
..........\备份.bat
..........\备份和恢复.rar
..........\恢复.bat
..........\说明.txt
备份所有没有分区的表
....................\dyt.dmp
....................\result.bat
....................\run.bat
....................\run.sql
....................\run1.sql
....................\备份所有没有分区的表.rar
....................\说明.txt
备份有分区的表
..............\partition.dmp
..............\result.bat
..............\run.bat
..............\run.sql
..............\run1.sql
..............\备份所有没有分区的表.rar
..............\说明.txt
查看表空间语句
..............\LookSpace.bat
..............\LookSpace.sql
..............\result.sql
查询消息发送情况
................\result.txt
................\run.sql
................\status.sql
................\查询消息发送情况.bat
................\查询消息发送情况.rar
欢迎短信V5.0测试库安装
......................\bakup.sql
......................\Create.sql
......................\dyt.dmp
......................\dytnorow.dmp
......................\result.bat
......................\备份.bat
......................\完全安装.bat
......................\说明.txt
生成No134脚本
.............\dytsms.exe
.............\result.bat
.............\result.sql
.............\run.bat
............\result.sql
............\run.bat
............\run.sql
Oracle8i中生成创建对象的SQL
...........................\Create.bat
...........................\Create.sql
...........................\result.sql
...........................\查看数据库内容.rar
SQL
...\函数大全.txt
...\取整的函数.txt
...\工程维护.sql
...\批量导入.txt
...\表空间.txt
内蒙city
........\city200411
........\..........\result.bat
........\..........\result.sql
........\..........\run.bat
........\..........\run.sql
........\..........\说明.txt
........\result.bat
........\result.sql
........\run.bat
........\run.sql
........\Update
........\......\run.bat
........\......\run.sql
........\......\Update.rar
........\备分内蒙city.rar
........\说明.txt
分区
....\oracle 分区表数据定期迁移到其他数据库测试方案.files
....\...................................................\itpub.gif
....\...................................................\itpubblog.gif
....\...................................................\style.css
....\oracle 分区表数据定期迁移到其他数据库测试方案.htm
....\新建 文本文档.txt
删除所有没有分区的表
....................\result.sql
....................\run.bat
....................\run.sql
....................\run1.sql
删除用户和表空间
................\all.bat
................\all.ftp
................\drop.bat
................\drop.sql
................\drop2.sql
................\result.bat
................\result.sql
备份和恢复
..........\restore.sql
..........\run.sql
..........\备份.bat
..........\备份和恢复.rar
..........\恢复.bat
..........\说明.txt
备份所有没有分区的表
....................\dyt.dmp
....................\result.bat
....................\run.bat
....................\run.sql
....................\run1.sql
....................\备份所有没有分区的表.rar
....................\说明.txt
备份有分区的表
..............\partition.dmp
..............\result.bat
..............\run.bat
..............\run.sql
..............\run1.sql
..............\备份所有没有分区的表.rar
..............\说明.txt
查看表空间语句
..............\LookSpace.bat
..............\LookSpace.sql
..............\result.sql
查询消息发送情况
................\result.txt
................\run.sql
................\status.sql
................\查询消息发送情况.bat
................\查询消息发送情况.rar
欢迎短信V5.0测试库安装
......................\bakup.sql
......................\Create.sql
......................\dyt.dmp
......................\dytnorow.dmp
......................\result.bat
......................\备份.bat
......................\完全安装.bat
......................\说明.txt
生成No134脚本
.............\dytsms.exe
.............\result.bat
.............\result.sql
.............\run.bat