tags:

views:

19

answers:

1
Q: 

How to know constraints,indexes,sequences without reading data dictionary?

I want to show indexes,sequences,constraints in DESC command ,is it possible, or any other cammand by which i can see structure(design) of a table along with constraints, sequences,indexes.

+1  A: 

Calling the DBMS_METADATA.GET_DDL() (or it could be FETCH_DDL(), I don't have 9i documentation online) command can show you everything.

Adam Musch  2010-03-14 16:24:21

related questions

Does this SQL statement needs to be refactored?
Altering Oracle sequence using result of expression
stored procedure to transfer data from a table in one database to a table in another database in oracle
Oracle Event Count Query
SQL Server 2008 Linked server to Oracle 9i
How to run REPLACE function in Oracle9i with strings larger than 4000 characters
Oracle: Find previous record for a ranked list of forecasts
plsql oracle parent child
Oracle Dynamic Join Challenge
Pattern Matching with Like Clause
Problem with joining db tables
oracle 9i get highest member of tree with given child
Oracle 9 - Resetting Sequence to match the state of the table
Oracle Date format - Strange behaviour
count number of rows that occur for each date in column date range.
Configuring Oracle 11g client to work with 9i, in order to use ODP.NET for VS 2008 and C# or ASP.net, issues
Delete an oracle-user with single quotes in the username
Does Oracle 10g automatically escape double quotes in recordsets?
Oracle Builtin String Character Classes
Oracle performance with multiple same column indexes
when will oracle discontinue the 9i database?
What is the best layer to use to format Currency numbers?
.NET and Oracle: Joining a table to an empty set of another table
Problems importing SQL script from Oracle 9i to Oracle 10g express
How do I do a manual uninstall of Oracle?