https://blog.youkuaiyun.com/thmonozh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/thmono/article/details/6125855https://blog.youkuaiyun.com/thmono/article/details/6125855thmonoSun, 09 Jan 2011 22:11:00 +0800一.存储过程(PROCEDURE)
使用过程, 不仅可以简化客户端应用程序的开发和维护,而且可以提高应用程序的运行性能.
CREATE [OR REPLACE] PROCUDURE procedure_name
(arg1 [model1] datatype1, arg2[model2] datatype2)
IS [AS]
PL/SQL Block;
arg1,arg2用于指定过程的参数,IS/AS用于开始一个]]>https://blog.youkuaiyun.com/thmono/article/details/6125469https://blog.youkuaiyun.com/thmono/article/details/6125469thmonoSun, 09 Jan 2011 17:21:00 +0800Oracle 10g支持正则表达式的四个新函数分别是：REGEXP_LIKE、REGEXP_INSTR、REGEXP_SUBSTR、和REGEXP_REPLACE。
它们使用POSIX 正则表达式代替了老的百分号（%）和通配符（_）字符。

特殊字符：
'^' 匹配输入字符串的开始位置，在方括号表达式中使用，此时它表示不接受该字符集合。
'$' 匹配输入字符串的结尾位置。如果设置了 RegExp 对象的 Multiline 属性，]]>https://blog.youkuaiyun.com/thmono/article/details/6125468https://blog.youkuaiyun.com/thmono/article/details/6125468thmonoSun, 09 Jan 2011 17:19:00 +0800

--通过表找存储过程名称
select * from dba_source a    where upper(a.text) like upper('%sp_kr_bimv_sms_busi_day%');

过程查看表 dgdm_kr.sh_mon_def   CMD_NAME
查询表和分区信息  user_tab_partitions  TABLE_NAME  PARTITION_NAME

]]>https://blog.youkuaiyun.com/thmono/article/details/6125461https://blog.youkuaiyun.com/thmono/article/details/6125461thmonoSun, 09 Jan 2011 17:18:00 +0800echo "********************************************"
echo "倒数脚本"
echo "导入表为：hi.tb_test_input"
echo "********************************************"                            
echo "请先清空临时表数据 truncate table hi.tb_test_input;]]>https://blog.youkuaiyun.com/thmono/article/details/6044619https://blog.youkuaiyun.com/thmono/article/details/6044619thmonoTue, 30 Nov 2010 09:43:00 +0800awk '{if(length($1)>10) print substr($1,1,10);else print $1}  test1;
名字服务器   可以根据域名查IP   linux和windows都可以使用   nslookup  www.sina.com
awk中打印单引号  echo "a" |awk '{print "/47"$1"/47"}'
AIX
 查看内存 topas   vmstat   vmstat 2 10  每个两秒出一次]]>https://blog.youkuaiyun.com/thmono/article/details/6044617https://blog.youkuaiyun.com/thmono/article/details/6044617thmonoTue, 30 Nov 2010 09:42:00 +0800空间表 sys.dba_free_space    sys.dba_data_files dba_segments
. 从返回的结果中选择第m到n条记录
        SELECT *                                                                                                                                                  <]]>https://blog.youkuaiyun.com/thmono/article/details/6027338https://blog.youkuaiyun.com/thmono/article/details/6027338thmonoMon, 22 Nov 2010 16:08:00 +08001、首先全局设置：Options - Global Options - Terminal - Appearance - Maximum columns 最大只能设置成1024（推荐256），设置越大越占用内存，并选上show horizontal scroll bar，然后重启SecureCRT；

2、然后session设置：Options - Session Options(或者Global Options - General - Default Session - Ed]]>https://blog.youkuaiyun.com/thmono/article/details/5993724https://blog.youkuaiyun.com/thmono/article/details/5993724thmonoSun, 07 Nov 2010 20:32:00 +0800为方便日常的维护和监控，AIX为我们提供了大量的各种各样的日志系统，但每个日志存放的具体地方都不同，大家可以通过查看/etc /syslog.conf知道日志配置的具体情况。这些日志记录和监控的内容不一样，有些是系统默认开放的，有些是需要设置才可以打开的，但都给我们的工 作带来了很大的便利。下面我将我平时常用到的一些系统日志总结一下，希望对大家的工作有所帮助。

1、系统错误日志

存放路径：/var/adm/ras/errlog
<]]>https://blog.youkuaiyun.com/thmono/article/details/5993667https://blog.youkuaiyun.com/thmono/article/details/5993667thmonoSun, 07 Nov 2010 19:39:00 +0800

#!/bin/sh

export ORACLE_HOME=/oracle/products/10.2/db
export ORA_NLS33=/oracle/products/10.2/db/ocommon/nls/admin/data
export ORACLE_BASE=/oracle/products
export ORACLE_TERM=xterm
export SHELL=/b]]>https://blog.youkuaiyun.com/thmono/article/details/5983219https://blog.youkuaiyun.com/thmono/article/details/5983219thmonoTue, 02 Nov 2010 22:15:00 +0800for和case的混合运用
set -A region  hz hy  mz gz yf  qy zq  sg jm mm zj yj st sw jy cz fs zs zh sz dg
for loop in ${region[*]}
         do 
       
          print  "select "123$loop," count(*) from "$loop"zw.sp_hlr_resu]]>https://blog.youkuaiyun.com/thmono/article/details/5983202https://blog.youkuaiyun.com/thmono/article/details/5983202thmonoTue, 02 Nov 2010 22:09:00 +0800#前三个月
year=`date +%Y`
mon=`date +%m`
if [ $mon -lt '04' ]
then
mon=`expr $mon + 9`
year=`expr $year - 1`
else
mon=`expr $mon - 3|awk '{printf("%02d/n",$0)}'`
fi
validbillcyc=$year$]]>https://blog.youkuaiyun.com/thmono/article/details/5983182https://blog.youkuaiyun.com/thmono/article/details/5983182thmonoTue, 02 Nov 2010 22:01:00 +0800##FTP自动上传
##用法: FTP 文件名
#!/bin/sh
ftp -n< open 10.247.3.153
user zhang hello123@
bin
prompt off
cd /home/huzheng/fujian/
mput $1 
close
bye
!

https://blog.youkuaiyun.com/thmono/article/details/5980265https://blog.youkuaiyun.com/thmono/article/details/5980265thmonoMon, 01 Nov 2010 19:46:00 +0800
shell中调用sqlplus
sqlplus -s user/pwd@datebase</dev/null
spool b.txt
select * from a;
spool off
exit
EOF
cat b.txt|tr -d ''>b.txt
shell中调用dbtool
/dxyyt/kefu/dbtool cxtyd_rw/tyd]]>https://blog.youkuaiyun.com/thmono/article/details/5980262https://blog.youkuaiyun.com/thmono/article/details/5980262thmonoMon, 01 Nov 2010 19:44:00 +0800Ksh Scripting


--------------------------------------------------------------------------------


Contents

Principle of Script
Variables
Branching
Looping
Commandline Argumen]]>https://blog.youkuaiyun.com/thmono/article/details/5980257https://blog.youkuaiyun.com/thmono/article/details/5980257thmonoMon, 01 Nov 2010 19:42:00 +0800secureCRT自动登录脚本
名称beifen.vbs
#$language = "VBScript"
#$interface = "1.0"

Sub main
  crt.Screen.Synchronous = True

  crt.Screen.WaitForString "ogin: "
  crt.Screen.Send "username" & VbCrhttps://blog.youkuaiyun.com/thmono/article/details/5980249https://blog.youkuaiyun.com/thmono/article/details/5980249thmonoMon, 01 Nov 2010 19:38:00 +0800

改变时间格式 alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';
set heading off  set echo off   set linesize 20000 set numwidth 20   set termout off   set colsep "|"
set trimout on   set trimspool on 去除标准输出每行的拖尾空格，缺省为off]]>https://blog.youkuaiyun.com/thmono/article/details/5980246https://blog.youkuaiyun.com/thmono/article/details/5980246thmonoMon, 01 Nov 2010 19:36:00 +0800.


不挂起运行   nohup command &     使用 jobs 查看任务。 　　使用 fg %n　关闭。
awk  '{print $NF}'
FTP  -n 10.10.10.1< user user password
bin
prompt off
lcd /home/hi    //更改本地计算机目录
cd /usr/k      ]]>https://blog.youkuaiyun.com/thmono/article/details/5900222https://blog.youkuaiyun.com/thmono/article/details/5900222thmonoTue, 21 Sep 2010 22:18:00 +0800名称 login.vbs
 
#$language = "VBScript"
#$interface = "1.0"
Sub main
  crt.Screen.Synchronous = True
  crt.Screen.WaitForString "ogin: "
  crt.Screen.Send "ywewie" & VbCr
  crt.Screen.WaitForString "assword:"https://blog.youkuaiyun.com/thmono/article/details/5900217https://blog.youkuaiyun.com/thmono/article/details/5900217thmonoTue, 21 Sep 2010 22:14:00 +0800Ksh Scripting

--------------------------------------------------------------------------------

Contents
Principle of Script
Variables
Branching
Looping
Commandline Arguments
Comparisons
Variabl]]>https://blog.youkuaiyun.com/thmono/article/details/5900214https://blog.youkuaiyun.com/thmono/article/details/5900214thmonoTue, 21 Sep 2010 22:11:00 +0800
赋权给所有人 grant select on sz_1152696_oce to public;
to_char(a.CHGTIME,'yyyymmdd')>='20100403'
内部连接数据库 CONNECT user_name/passwd@db_alias
取消脚本替代中的显示 SET ECHO
sqlplus帮助 sqlplus /help 或者 sqlplus -h
关闭显示查询时间 set timing off