Is it possible to execute the DESC tablename command using PHP to a Oracle
DB or is that a *SQLPlus command?
DB or is that a *SQLPlus command?
-
-
Re: ORACLE Describe Table
cbtguy_2000 (cbtguy_2000@ya hoo.com) wrote:
: Is it possible to execute the DESC tablename command using PHP to a Oracle
: DB or is that a *SQLPlus command?
Not exactly, DESCRIBE is actually a command of sqlplus.
In oracle, look up the columns in a table by SELECTing from the
USER_TAB_COLUMN S table.
Oracle has a number of tables such as that one that have data about
tables/colums/etc.
-
Re: ORACLE Describe Table
On Thu, 28 Jun 2007 23:02:02 -0700, cbtguy_2000 wrote:
What SQL*Plus does is to describe a cursor. Describing USER_TAB_COLUMN SIs it possible to execute the DESC tablename command using PHP to a
Oracle DB or is that a *SQLPlus command?
is equivalent to describing a cursor "select * from USER_TAB_COLUMN S".
OCI8 has plenty of functions to do just that:
oci_num_fields
oci_field_name
oci_field_is_nu ll
oci_field_preci sion
oci_field_scale
oci_field_size
oci_field_type
--
Comment
-
Re: ORACLE Describe Table
Thanks for your help.
That info was very helpful.
The following SELECT gives the basic same info as DESCRIBE
SQLDESCRIBE BB_TAX
Name
Null? Type
----------------------------------------------------------------- --------
---------------
IDSTATE
NOT NULL NUMBER(2)
STATE
CHAR(2)
TAXRATE
NUMBER(4,3)
SQLcol column_name format a15
SQLcol data_type format a15
SQLcol nullable format a4
SQLSELECT column_name, data_type,
2 data_length, data_precision,
3 data_scale, nullable
4 FROM user_tab_column s
5 WHERE table_name = 'BB_TAX';
COLUMN_NAME DATA_TYPE DATA_LENGTH DATA_PRECISION
DATA_SCALE NULL
--------------- --------------- -----------
--------------- ---------
----
IDSTATE NUMBER 22
2 0
N
STATE CHAR 2
Y
TAXRATE NUMBER 22
4 3
Y
"Mladen Gogala" <mgogala.SPAM_M E.NOT@verizon.n etwrote in message
news:pan.2007.0 6.30.01.24.18@v erizon.net...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_COLUMN S
is equivalent to describing a cursor "select * from USER_TAB_COLUMN S".
OCI8 has plenty of functions to do just that:
oci_num_fields
oci_field_name
oci_field_is_nu ll
oci_field_preci sion
oci_field_scale
oci_field_size
oci_field_type
--
http://www.mladen-gogala.com
Comment
-
Re: ORACLE Describe Table
On Sat, 30 Jun 2007 05:45:00 +0000, cbtguy_2000 wrote:
It does, but it will not work for views or V$ tables.The following SELECT gives the basic same info as DESCRIBE
--
Comment
-
Re: ORACLE Describe Table
On Mon, 02 Jul 2007 12:33:08 GMT, Mladen Gogala
<mgogala.SPAM_M E.NOT@verizon.n etwrote:
Um, yes it will. Views' columns appear in USER_TAB_COLUMN S.>On Sat, 30 Jun 2007 05:45:00 +0000, cbtguy_2000 wrote:
>>>The following SELECT gives the basic same info as DESCRIBE
>It does, but it will not work for views or V$ tables.
--
Andy Hassall :: andy@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Comment
-
Re: ORACLE Describe Table
On Mon, 02 Jul 2007 19:31:52 +0100, Andy Hassall wrote:
You are right, my mistake.On Mon, 02 Jul 2007 12:33:08 GMT, Mladen Gogala
<mgogala.SPAM_M E.NOT@verizon.n etwrote:
>>>>On Sat, 30 Jun 2007 05:45:00 +0000, cbtguy_2000 wrote:
>>>>>>The following SELECT gives the basic same info as DESCRIBE
>>It does, but it will not work for views or V$ tables.
Um, yes it will. Views' columns appear in USER_TAB_COLUMN S.
Comment
-
Re: ORACLE Describe Table
On Mon, 02 Jul 2007 19:31:52 +0100, Andy Hassall wrote:
It does work for views, but not for V$ tables:>>>It does, but it will not work for views or V$ tables.
Um, yes it will. Views' columns appear in USER_TAB_COLUMN S.
SQLselect column_name from dba_tab_columns
2 where table_name='V$P ROCESS';
no rows selected
SQLselect column_name from dba_tab_columns
2 where table_name='V$S ESSION';
no rows selected
SQLselect column_name from dba_tab_columns
2 where table_name='DBA _USERS';
COLUMN_NAME
-----------------------------------
USERNAME
USER_ID
PASSWORD
ACCOUNT_STATUS
LOCK_DATE
EXPIRY_DATE
DEFAULT_TABLESP ACE
TEMPORARY_TABLE SPACE
CREATED
PROFILE
INITIAL_RSRC_CO NSUMER_GROUP
EXTERNAL_NAME
12 rows selected.
--
Comment
-
Re: ORACLE Describe Table
On Thu, 05 Jul 2007 23:45:10 GMT, Mladen Gogala
<mgogala.SPAM_M E.NOT@verizon.n etwrote:
That's because V$PROCESS is a synonym, not a table or view. Dereference it>On Mon, 02 Jul 2007 19:31:52 +0100, Andy Hassall wrote:
>>>>>>>It does, but it will not work for views or V$ tables.
> Um, yes it will. Views' columns appear in USER_TAB_COLUMN S.
>It does work for views, but not for V$ tables:
>SQLselect column_name from dba_tab_columns
2 where table_name='V$P ROCESS';
>
>no rows selected
first.
SQLselect table_owner, table_name
2 from dba_synonyms
3 where synonym_name = 'V$PROCESS'
4 and owner = 'PUBLIC';
TABLE_OWNER TABLE_NAME
------------------------------ ------------------------------
SYS V_$PROCESS
SQLselect column_name from dba_tab_columns
2 where owner = 'SYS'
3 and table_name = 'V_$PROCESS';
COLUMN_NAME
------------------------------
PGA_USED_MEM
PGA_ALLOC_MEM
PGA_FREEABLE_ME M
PGA_MAX_MEM
ADDR
PID
SPID
USERNAME
SERIAL#
TERMINAL
PROGRAM
TRACEID
BACKGROUND
LATCHWAIT
LATCHSPIN
15 rows selected
--
Andy Hassall :: andy@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Comment
Comment