Posted by Richard Lynch on 10/04/84 11:07
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
Navigation:
[Reply to this message]
|