Re: how to see the complete description of table in oracle

On 18 Feb, 08:52, juned2...@xxxxxxxxx wrote:
hi,
 i want to see the complete description of table with it's structure
and constraints.
I also want to see the column name on which the constraints are
applied.

Depending on Oracle version, check out the DBMS_METADATA package.

Example: http://www.psoug.org/reference/dbms_metadata.html

HTH

-g
.

Relevant Pages

  • Re: FF/SS with lag/lead and Forward/Backward Pass Calculation
    ... (depending on the other links to the task, and on constraints) ... he predecessor plus the lag if any. ...
    (microsoft.public.project)
  • Re: spreading code with low autocorrelation
    ... keeping your computer humming for a while, depending on ... your constraints. ... I think it might blow the budget of my project if I were to rent a super ...
    (comp.dsp)
  • Re: How can I reduce variance in this LP problem?
    ... And if I plug this into Excel Solver with the standard LP engine, ... Or several other possibilities depending on exactly ... you put in such constraints. ...
    (sci.math)
  • Re: Monitor individual tasks within a DTS package
    ... > tasks that will redirect the package flow to the EMail task in the event ... > failure, rather than using multiple Failure constraints. ...
    (microsoft.public.sqlserver.dts)
  • Re: Help: Multi-table design
    ... Each type of package required tracking a different set of dates. ... JobID INTEGER NOT NULL, ... BTW those CHECK constraints can be replaced using the Table Validation ... INSERT INTO JobStateTrasitions (job_type, previous_state, ...
    (microsoft.public.access.tablesdbdesign)