Posted by Mladen Gogala on 06/30/07 01:24

On Thu, 28 Jun 2007 23:02:02 -0700, cbtguy_2000 wrote:

> Is it possible to execute the DESC tablename command using PHP to a
> Oracle DB or is that a *SQLPlus command?

What SQL*Plus does is to describe a cursor. Describing USER_TAB_COLUMNS
is equivalent to describing a cursor "select * from USER_TAB_COLUMNS".
OCI8 has plenty of functions to do just that:
oci_num_fields
oci_field_name
oci_field_is_null
oci_field_precision
oci_field_scale
oci_field_size
oci_field_type
--
http://www.mladen-gogala.com

• Next in forum: Re: To allow access only from the designated site.
• Prev in forum: Re: To allow access only from the designated site.
• Thread view: Re: ORACLE Describe Table

[Reply to this message]