In order to export the data from a table you can either use the SQL Worksheet and write a SQL query to retrieve the required data or you can Click on the Data tab of a table definition.SQL Developer provides the ability to export user data to a variety of formats: CSV, XML, LOADER, TEXT, INSERT, HTML and XLS. We'll use this latter approach.Įxpand the Connections Navigator and the Tables node. Right-click anywhere on the data to invoke the context menu. Select insert from the Export Data context menu. This will produce a file of insert statements.Ĭhoose an appropriate directory and name for the file. You can also fine tune what is exported by selecting the columns and adding a where clause to reduce the number of records returned. To review the file created, click the Open Folder icon.In this example, we'll take the default of all the records and columns. Select the new file DEPARTMENTS.sql from your file directory. The sql file will open into a SQL Worksheet. SQL Developer provides the ability to export some or all of your object definitions to script files. You can use these as a backup of the object definitions or run them in another schema. In this exercise, you export all the object definitions and the data for the Departments table. Using the main menu, select Tools->Database Export.In this step, you can slect what Object Types to export.Īt the top of the screen, enter a directory and file name.We will take the default for all object types. In this step, you can specify the objects to export.Instead of querying all objects by immediately selecting Go, you can enter a restriction criteria. You can restrict the list of choices further by using the drop list on the right.Select Table from the list of object types.Ĭlick Go. The list now displays tables that start with "D". Select the table Departments and shuttle to the right hand panel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |