Re: ORACLE Describe Table

cbtguy_2000 (cbtguy_2000@xxxxxxxxx) 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_COLUMNS table.

Oracle has a number of tables such as that one that have data about
tables/colums/etc.

.

Relevant Pages

  • ORACLE Describe Table
    ... Is it possible to execute the DESC tablename command using PHP to a Oracle ... DB or is that a *SQLPlus command? ...
    (comp.lang.php)
  • SUMMARY: sudo version 1.6.7p5 : using -H -u options on Solaris 8
    ... Many thanks to those that responded, as expected all responses were helpful. ... This will allow you to do the thing that the user oracle requires while also ... designated in the sudoers file who requires to use the command, ... there is a CLASSPATH variable set which, as the oracle user I can see by ...
    (SunManagers)
  • Re: Basic question | run multiple queries without reconnecting
    ... :>From an oracle client like oracle sqldeveloper, I can run the DCL - ... : system as role: sysdba - but then I cant even connect to the db.. ... as default - I get the same error when I run this command: ...
    (comp.databases.oracle.server)
  • Re: How many names and addresses can you have for ID card
    ... Think command line only (except when you're installing, ... which is unsettling to we Linux users. ... This is NOTHING to do with Oracle though. ...
    (uk.legal)
  • Re: AIX Performance issue
    ... however approx 30 users normally access AIX server ... > through oracle application, every thing was running fine during last 3 ... > sar and lpstat command and their output was as given below. ... > Mostly when error occurred our database daily backup was in process ...
    (comp.unix.aix)