How will we see framework of a table?
Answers were Sorted based on User's Feedback
Answer / yam
to see the framework of table use
DESCRIBE tablename;
or DESC tablename
| Is This Answer Correct ? | 20 Yes | 1 No |
Answer / sudheer kumar mikkilineni
select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from
dual;
| Is This Answer Correct ? | 12 Yes | 0 No |
how to calculate expressions with sql statements? : Sql dba
Explain constraints in sql?
Can we use having without group by in sql?
What is a temporal data type?
How do I view a sql trace file?
how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query
What is the purpose of the primary key?
How is debugging done?
Does sql profiler affect performance?
What is $$ in sql?
How can I delete duplicate rows?
Which certification is best for sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)