How will we see framework of a table?

Answer Posted / sudheer kumar mikkilineni

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from
dual;

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the authentication modes in sql server? : Sql dba

536


how to run 'mysql' commands from a batch file? : Sql dba

610


When should I use nosql database?

553


What is memory optimized?

558


Why procedure is used in sql?

534






Why do we use sql constraints? Which constraints we can use while creating database in sql?

549


What is the difference between inner join and natural join?

513


What is oracle and pl sql?

663


Is sql a backend language?

625


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

536


How do I trace sql profiler?

491


How is debugging done?

531


Which join is like an inner join?

525


Are stored procedures faster than queries?

524


How do you delete data from a table?

546