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, Commented Aug 1, 2012 at 19:58

user330315user330315 · Accepted Answer · 2012-08-01 19:57:23Z

2

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).

answered Aug 1, 2012 at 19:57

user330315

Add a comment |

1 Answer 1