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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php