Search code examples
sqloraclesqlplusddldatabase-metadata

Get table definition in oracle sql plus

I'm new to sql and I have created table using create table table_name. And now I want to get this table definition or let's say source code, I know command desc table_name but that's not what I want. Could you help me figure it out?

Solution

  • Check the function: DBMS_METADATA.GET_DDL

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