Question: how to export oracle database in sql developer?
Answer: In SQL Developer, click Tools, then Database Export. ...  Accept the default values for the Source/Destination page options, except as follows: ...  Click Next. On the Types to Export page, deselect Toggle All, then select only Tables (because you only want to export data for a table).