摘要:
set echo offpromptprompt shell 调用方法 prompt call_grant_dml.sql &1 prompt ==SQL 定义变量,以及执行的sql set echo off pagesize 0 feedback off verify off serveroutp 阅读全文
摘要:
set echo on feedback on spool ./log/01_change_schema.log -- -- schema change to v_idocdata_un -- -- -- switch to application user, use 业务 变量 -- connec 阅读全文
摘要:
#!/bin/bash #find files contains a keyword #write by xiaojing.zhao #2012.12.14 echo -e "\nThis is a script to find all the files in a specified path c 阅读全文
摘要:
define v_conn_str=misc1uat define v_system_un=system define v_system_pw=sys_test 阅读全文
摘要:
#! /bin/ksh ############### ### UAT ### ############### export ENVS=/test/change/env/env_test.sql export SCHEMA_HOME=/test/change/schema/test/2015_11_ 阅读全文
摘要:
######sample db_status=`sqlplus -S dbmo/dbmo@up:port/sid <<EOFset heading offset pagesize 0;set feedback off;set verify off;set echo off;select status 阅读全文