to see the framework of table use DESCRIBE tablename; or DESC tablename

How will we see framework of a table?

Question Posted / yam

Answer Posted / yam

to see the framework of table use

DESCRIBE tablename;
or DESC tablename

Is This Answer Correct ?

20 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How does one use sql*loader to load images, sound clips and documents? : aql loader

883

what is subquery? : Sql dba

773

What does partition by mean in sql?

690

what is the difference between delete and truncate statement in sql? : Sql dba

761

Does sql between include endpoints?

748

Is it possible for a table to have more than one foreign key?

774

Can a foreign key be null?

809

What are aggregate and scalar functions?

725

What are the most important ddl statements in sql?

750

What is rowtype?

767

What is an exception in pl/sql?

725

What are the key differences between SQL and PL SQL?

854

Explain the advantages and disadvantages of stored procedure?

853

How does sql developer connect to oracle database?

742

What are pl/sql packages?

766