CJ's Tech Notes

Oracle 10g how to check current session default schema?

techguru — Tue, 07 Sep 2010 11:15:31 +0000

select sys_context( ‘userenv’, ‘current_schema’ ) from dual;

How to alert another session’s trace setting?

techguru — Tue, 07 Sep 2010 10:21:40 +0000

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);

oracle 10g data pump quick example

techguru — Tue, 07 Sep 2010 09:11:54 +0000

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

Createing web service interface from a wsdl

techguru — Thu, 02 Sep 2010 09:57:33 +0000

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)

checking constraints on the columns of a oracle table

techguru — Mon, 30 Aug 2010 12:05:02 +0000

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

what is the oracle equivalent for datediff in sql sever?

techguru — Mon, 30 Aug 2010 12:04:25 +0000

Floor(sysdate - to_date(’100825′,’yymmdd’))=0

VMware admin

techguru — Fri, 27 Aug 2010 10:06:17 +0000

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.

Business objects how to call web service to create a report instance

techguru — Wed, 25 Aug 2010 07:35:55 +0000

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

Bat command how to do number compare

techguru — Wed, 25 Aug 2010 06:23:17 +0000

IF %ERRORLEVEL% gtr 0 GOTO ExitError

ECHO “Load data into %table% complete successfully”

Oracle 10g how to change default date time display

techguru — Wed, 25 Aug 2010 06:21:41 +0000

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’