Re: sending set NUMBERFORMAT
| From: | Richard Lynch | Date: | Fri, 04 Feb 2005 17:23:04 +0000 |
| Subject: | Re: sending set NUMBERFORMAT | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-208096@lists.php.net to get a copy of this message | ||
Nuzzo Art-CINT116 wrote:
> Hopefully this is an easy question. I need to set the default numeric
> data format when selecting data from an oracle database using PHP OCI
> interface.
>
>
> The SQLPLUS command is:
>
> SET NUMBERFORMAT 99990.999
>
> How would I send this from PHP? I need to do the format at the datebase
> server instead of reformatting in PHP to work around PHP bug 30726.
It's a query.
Just send it the same way you send every query.
$query = "set numberformat 99990.999";
$result = sqlplus_query($query); //Use the SAME thing as for SELECT query.
--
Like Music?
http://l-i-e.com/artists.htm