http://occex.com Just another WordPress weblog Tue, 07 Sep 2010 11:15:31 +0000 http://backend.userland.com/rss092 en select  sys_context( 'userenv', 'current_schema' ) from dual; http://occex.com/?p=69081 select sid, serial#, program, machine from v$session where program like 'My_Program_Name%'; exec dbms_system.set_sql_trace_in_session(10 /* sid */,20 /* serial# */,true); http://occex.com/?p=69080 here is a quick example for oracle datapump to copy over schema objects   expdp user/pass@sitbox schemas=rei directory=rei_dump dumpfile=rxi.dmp logfile=expdpREI.log impdp user/pass@rxi schemas=rei directory=IMP_EXP dumpfile=rxi.dmp logfile=impdpREI.log     http://occex.com/?p=69079 C:\Program Files\Microsoft Visual Studio 9.0\VC>wsdl /si c:\test\wsdl\bizprocessadmin.wsdl /out:c:\test\wsdl\ (the c# interface file will generated under this folder) http://occex.com/?p=69078 SELECT b.table_name, b.column_name FROM SYS.ALL_CONSTRAINTS S , SYS.ALL_CONS_COLUMNS B WHERE S.OWNER=TEST' AND S.TABLE_NAME='ACCOUNT'  AND S.CONSTRAINT_NAME=B.CONSTRAINT_NAME http://occex.com/?p=69077 Floor(sysdate - to_date('100825','yymmdd'))=0 http://occex.com/?p=69076 ou can decide to remove this software from your system at any time by invoking the following command: "rpm -e VMware-server". instead of puting in the whole package name, just put in VMware-server  in order to remove the vm ware from your box. http://occex.com/?p=69075 available business object web service can be access http://biportalsite.com/dswsbobje/services/listServices use the session service to establish a connection http://biportalsite.com/dswsbobje/services/Session?wsdl  use the biplatform to schedule a run (scheduel for run now) http://biportalsite.com/dswsbobje/services/BIPlatform?wsdl   http://occex.com/?p=69072   IF %ERRORLEVEL% gtr 0 GOTO ExitError   ECHO "Load data into %table% complete successfully" http://occex.com/?p=69071   change system wide alter system set NLS_DATE_FORMAT='DD-Mon-YYYY HH24:MI:SS' change session  alter session set NLS_DATE_FORMAT='DD-Mon-YYYY HH24:MI:SS' http://occex.com/?p=69070