![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
一枚哦吼
GIS
展开
-
某个字段重复内容 sql
select count(stuage),stuage as a from tb_student t group by stuage having count(stuage)>1原创 2016-04-07 08:46:44 · 255 阅读 · 0 评论 -
oracle创建dblink 并应用
-- dba 权限下执行grant create public database link,create database link to kangxu;-- Create database link create database link DBLINK_Studnet connect to kangxu IDENTIFIED BY kangxu using '(DESCRIP原创 2016-04-06 17:00:52 · 226 阅读 · 0 评论 -
备份表sql
-- backupTable 备份表 ; needbackuptable需要备份的表select table backupTable as select * from needbackuptable原创 2016-04-06 15:19:16 · 625 阅读 · 0 评论 -
mysql 将查询结果拼接输出到本地文件
--①第一种create procedure proc(in stuid int,in stuname VARCHAR(255),in stuage VARCHAR(255))begin declare cnt int ; declare str VARCHAR(255); declare temp VARCHAR(255); declare i int;原创 2016-03-21 16:01:31 · 918 阅读 · 0 评论 -
oracle 数据库 查询结构拼接输出到本地文件
①创建目录create or replace directory ORACLE_TEST as 'd:\\testtmp';②写存储过程create or replace procedure proc(stuid tb_student.stuid%type, stuname tb_student.stuname%type, stuage tb_student.stuage%type) as cou原创 2016-03-21 15:22:18 · 467 阅读 · 0 评论