Createing web service interface from a wsdl
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)
Add comment September 2nd, 2010
checking constraints on the columns of a oracle table
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
Add comment August 30th, 2010
what is the oracle equivalent for datediff in sql sever?
Floor(sysdate - to_date(’100825′,’yymmdd’))=0
Add comment August 30th, 2010
VMware admin
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.
Add comment August 27th, 2010
Business objects how to call web service to create a report instance
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
Add comment August 25th, 2010
Bat command how to do number compare
IF %ERRORLEVEL% gtr 0 GOTO ExitError
ECHO “Load data into %table% complete successfully”
Add comment August 25th, 2010
Oracle 10g how to change default date time display
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’
Add comment August 25th, 2010
Composing Bo link to the last instance of the report
Find the report object, right click and choose properties
>> got the document id
>>compose link as
Add comment August 24th, 2010
oracle 10g SQL loader exit code
Result Exit Code
All rows loaded successfully
EX_SUCC
All or some rows rejected
EX_WARN
All or some rows discarded
EX_WARN
Discontinued load
EX_WARN
Command-line or syntax errors
EX_FAIL
Oracle errors nonrecoverable for SQL*Loader
EX_FAIL
Operating system errors (such as file open/close and malloc)
EX_FTL
For UNIX, the exit codes are as follows:
EX_SUCC 0
EX_FAIL 1
EX_WARN 2
EX_FTL 3
For Windows NT, the exit codes are as follows:
EX_SUCC 0
EX_WARN 2
EX_FAIL 3
EX_FTL 4
Add comment August 20th, 2010
Oracle how to print a ref cursor content out?
create or replace package pkgTestCurPrint as
type typeCur is ref cursor;
procedure testcurP(output out typeCur);
end;
/
type typeCur is ref cursor;
procedure testcurP(output out typeCur);
end;
/
create or replace package body pkgTestCurPrint as
procedure testcurP(output out typeCur) is
begin
open output for select * from account;
end;
end;
/
procedure testcurP(output out typeCur) is
begin
open output for select * from account;
end;
end;
/
var refCur refcursor
exec pkgTestCurPrint.testcurP(:refCur)
exec pkgTestCurPrint.testcurP(:refCur)
spool c:\temp\printstaff.dat
print refCur
spool off
print refCur
spool off
Add comment August 18th, 2010