All Tables SQL

[ridonet]

I want to get all table definitions with one click/command including table's triggers... PL/SQL developer does this very well for one table ( right click->view->view SQL) . I want to do this for all tables with one click. How could it be?

 

[Marco Kalter]

There are basically 2 methods for this.

You can use the Export User Objects tool to create one or more SQL files with the table/trigger definitions.

Alternatively, you can select the objects in the Object Browser (use Ctrl-Click or Shift-Click for multi-select), and drag & drop them into an editor. You can subsequently select the DDL item from the drag & drop popup menu.

------------------
Marco Kalter
Allround Automations

 

[ridonet]

Thanks first way is what I wanted.