Re: ORACLE Describe Table

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
.

Relevant Pages

  • Re: grandma-rated mail reader
    ... So things have had plenty of time to stabilise! ... behind the main mail client window - which won't have been sent. ... cursor is - and make sure that the cursor is in "that" window before you ... When selecting recipients from a list again a clear explanation to make ...
    (Fedora)
  • Re: Display Problems
    ... ghost "shadow". ... and the cursor is ... plenty of problems:( ... Prev by Date: ...
    (alt.os.linux.suse)
  • ADODB.RecordSet, RecordCount always return -1
    ... I have an ADODB.RecordSet that RecordCount alway return -1 and this ... RecordSet is plenty of record! ... Is the cursor is lost somewhere? ...
    (microsoft.public.inetserver.asp.general)
  • Re: how to get data from database as string
    ... There are working examples in the documentation at ... Basically you need to call fetch or fetch_hash on your cursor to get the ... Alternatively, if you call execdirectly on the OCI8 object, you can pass ...
    (comp.lang.ruby)