RE: Initialization of variables in functions
"Anhaus, Thomas" <[email protected]> Tue, 25 Sep 2007 08:22:08 +0200
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
Sorry, currently this is not possible. You always have to initialize the = variable via an additional statement. Maybe we will change this in the = future. Best Regards, Thomas=20 Thomas Anhaus MaxDB&liveCache SAP AG mailto: [email protected] www.sap.com Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), L=E9o = Apotheker (stellvertretender Sprecher / Deputy CEO), Werner Brandt, = Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: = Hasso Plattner=20 Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Gesch=E4ftsgeheimnisse oder sonstige = vertrauliche Informationen enthalten. Sollten Sie diese E-Mail = irrt=FCmlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, = eine Vervielf=E4ltigung oder Weitergabe der E-Mail ausdr=FCcklich = untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. = Vielen Dank. =20 This e-mail may contain trade secrets or privileged, undisclosed, or = otherwise confidential information. If you have received this e-mail in = error, you are hereby notified that any review, copying, or distribution = of it is strictly prohibited. Please inform us immediately and destroy = the original transmittal. Thank you for your cooperation. =20 > -----Original Message----- > From: [email protected] [mailto:[email protected]]=20 > Sent: Montag, 24. September 2007 13:56 > To: [email protected] > Subject: Initialization of variables in functions >=20 > Hello, >=20 > is there a possibility to initialize variables during the=20 > deklaration or have I always set a value with an second statement? >=20 > Example in MySQL: > declare <variable> varchar(200) DEFAULT 'test'; > Example in Oracle: > <variable> VARCHAR2(200) :=3D 'test'; >=20 > With Oracle or MySQL I only need one statement. >=20 >=20 > Regards, > Spiker > --=20 > GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. > Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail >=20 > --=20 > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: =20 > http://lists.mysql.com/[email protected] >=20 >=20 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[email protected]