DB Operation

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