0

I just created a table in Oracle sqlplus.

sql>create table test1
(Name varchar(15), Mobile _num number(15)) ;

so I want a solution where I can see again this definition. just typing a command or other solution.

output should be in same way 

create table test1
(Name varchar(15), Mobile _num number(15)) ;
Ateek
  • 5
  • 2
  • 2
    You can try this one: desc test1; – Eduard Uta Mar 01 '18 at 09:26
  • Yes just run: `desc test1;` to get the table description. – cdaiga Mar 01 '18 at 09:27
  • 1
    Definitely a duplicated question, and definitely @EduardUta has right. The fastest way is `desc test1` where `desc` stands for `describe`. – shadowsheep Mar 01 '18 at 09:27
  • I don't think that this is what you are talking about; it is not the `DESC`(ribe) command; the OP wants to see the whole `CREATE TABLE` statement - have a look at the question. If that's so, `select dbms_metadata.get_ddl('TABLE', 'TEST1', 'USER_WHO_OWNS_IT') from dual;` would be a better answer. Though, the question has been closed. Too bad. **EDIT** Ah, yes - I see it now, there's a link which leads to the same `GET_DDL`. OK then. – Littlefoot Mar 01 '18 at 09:43
  • `set echo on` - it should repeat the last statement. you create a table - it outputs the statement after you execute it. – g00dy Mar 01 '18 at 09:46

0 Answers0