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