SERPland Flugverkehr/Airtraffic Zürich – Auto Direktimport Dänemark – Disneyland Paris – Legoland Deutschland


Oracle Sum Function

The Oracle Sum fuction is very useful. Also analytical Oracle Sum functions are available. Using sum(<column>) over (partition by <column>): with this oracle sum function, you can sum over a range within the result set.

Sample: I have 526 Rows of payed bills, unfortunatelly within this view I get bills with their position in the same view (not normalized). With this oracle sum function, I calculate a sum of all positions within its bill.

select persnr ,billnr ,positionnr ,betrag ,currency ,sum(betrag) over (partition by persnr, rechnungnr order by persnr, to_number(billnr),to_number(positionnr)) as oracle_sum   -- oracle sum function  from billing_view where 1=1 and persnr = 37797

Related Posts:


PHP and PEAR SOAP: How to pass attributes to a webservice operation (xml-wsdl)

Basing a PHP SOAP Client on a webservice’s WSDL is very easy using PEAR’s SOAP package.

Usually you can pass tons of XML ELEMENTS to the webservice. But how to pass XML ATTRIBUTES?


Sample XML REQUEST structure:

<airline id=”12”>Air Congo<airline>


With PHP PEAR SOAP I was thinking to use it this way:


$params = array(“airline" “ => array(“_” => “Air Congo”, “id” => “12”));

$result = $client->getAirline($params);


… but unfortunatelly this doesn’t work …

Related Posts:


Quest TOAD 10. ERROR on startup toad.exe: No argument for format ‘%s’

When trying to start up Quest's TOAD, an ERROR occurs:
startup of toad.exe No argument for format '%s'

See EurekaLog 6.0.20

1.2 Name/Description: Toad.exe - (Toad for Oracle)
1.3 Version Number :
1.4 Parameters :
1.5 Compilation Date: Mon, 16 Nov 2009 16:36:37 +0200
1.6 Up Time : 4 seconds

2.2 Address : 00412AB5
2.3 Module Name : Toad.exe - (Toad for Oracle)
2.4 Module Version:
2.5 Type : EConvertError
2.6 Message : No argument for format '%s'.
2.7 ID : 39BE
2.9 Status : New

Related Posts: