Question: how to export data from oracle database using sql developer?
Answer: Using the main menu, select Tools->Database Export. An Export wizard will open. ...  Set the DDL Options for this Export. ...  In this step, you can slect what Object Types to export.