DB Operation

最新推荐文章于 2020-06-02 06:00:00 发布

samfang

最新推荐文章于 2020-06-02 06:00:00 发布

阅读量837

点赞数

分类专栏：其他

本文链接：https://blog.csdn.net/samfang/article/details/8582194

版权

其他专栏收录该内容

12 篇文章 0 订阅

订阅专栏

tnsnames.ora already copied to 4,4u and 4q under ${ORACLE_HOME}/network/admin.
export ORASERVER=***01

export ORACLE_HOME=/opt/oraClient/11.2.0.3
export SQLPLUS=$ORACLE_HOME/bin/sqlplus; export SQLPLUS
export ORALOGNAME=USER
export ORALOGPASS=PASS
export ORASERVER=***01
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:"${ORACLE_HOME}/lib"
export LD_LIBRARY_PATH_64=$LD_LIBRARY_PATH_64:"${ORACLE_HOME}/lib"
$SQLPLUS $ORALOGNAME/$ORALOGPASS@$ORASERVER

ALTER SESSION SET CURRENT_SCHEMA=MYSCHEMA
/
@@MY1.sp ----- SP can't contain GO.
/
quit

select text from USER_SOURCE where NAME='MY2' order by name,line
SELECT * FROM User_Procedures;
select * from all_procedures where OWNER='TEST';

SYBASE/MSSQL:
sp_helptext <proc_name>

ORACLE:
select text
from dba_source
where owner = 'USERNAME' and NAME='proc_name'
order by name,line