CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloperddl
sravan kumar
sravan kumar

Reputation: 15

how to find the query used for creation of Temporary table in Oracle sql developer

I have created a temporary table in oracle sql developer but I forgot to save it and now I want to reuse the query but I don't remember the code used then. Is there a process to get query used creation of temp table?

Upvotes: 0

Views: 1360

Answers (1)

user330315
user330315

Reputation:

You can use dbms_metadata.get_ddl() 

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

The result is a CLOB with the complete DDL. You might need to adjust the display in SQL Developer to make the content of that value fully visible (I don't use SQL Developer, so I don't know if that is necessary and if so, what you would need to do)

Edit:

It seems SQL Developer can't display the result of this query properly unless you use the "Run Script" option. And with that you need to use a SET LONG 60000 (or some other big number) before you run it, to see the complete source code:

enter image description here

Upvotes: 1

Related Questions