11g How to show table SQL in SQLPLUS?

Question

I don't have much experience with Oracle and its 11g database SQL language.

Does the SQLPLUS have some command or procedure to view the SQL that defines a table, stored procedure, or other database objects?

I know there's a DESCRIBE command, but it doesn't show the SQL.

DESCRIBE would have been my guess too. I feel like the end user isn't meant to see the PLSQL. What do you need to see that for anyhow? — Ryan Gray

a_horse_with_no_name a_horse_with_no_name · Accepted Answer · 2012-08-01T19:57:23

The following will show you the full DLL for the table FOOBAR in the current schema:

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

Btw: a CREATE TABLE statement is not PL/SQL, it's "just" SQL. PL/SQL is the language you use (only) in procedures (or PL/SQL blocks).