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

15Jul/110

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:

24May/110

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:

8May/101

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

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

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

Related Posts: