摘要：
#!/bin/sh CURR_DIR=$(cd $(dirname $0);pwd) TD_BASE=`su - tduser -c "echo "${TD_BASE}""` function change_app_ip() { if [ $# -ne 3 ];then echo "The param is not correct." exit 1 ... 阅读全文
摘要：
!#/bin/bash echo -e "shutdown immdiate;\nexit">/tmp/shutdown.sql su - oracle -c "sqlplus / as sysdba@/tmp/shutdown.sql" if [ $? -eq 0 ] then echo "shutdown oracle successful!" rm -rf /tmp/sh... 阅读全文
摘要：
declare cursor proce is Select Object_Name,owner,object_type From All_Objects Where Status = 'INVANID' and (Object_type = 'PROCEDURE' or lower(Object_type) = 'function'); Strsql Varchar2(200); BE... 阅读全文
摘要：
declare hitoryid number; flow_id number; item_result_new_id number; node_item_result_id number; common_diag_seq varchar2(64); new_diag_seq varchar2(64); k number; indi... 阅读全文