You can use these as a backup of the object definitions or run them in another schema. SQL Developer provides the ability to export some or all of your object definitions to script files. The sql file will open into a SQL Worksheet. Select the new file DEPARTMENTS.sql from your file directory. To review the file created, click the Open Folder icon.In this example, we'll take the default of all the records and columns. You can also fine tune what is exported by selecting the columns and adding a where clause to reduce the number of records returned. This will produce a file of insert statements.Ĭhoose an appropriate directory and name for the file. Select insert from the Export Data context menu. Right-click anywhere on the data to invoke the context menu. We'll use this latter approach.Įxpand the Connections Navigator and the Tables node. 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. Access to the Sample User Account HR (See Step 2 of this Getting Started: Oracle SQL DeveloperGuide).In this How-To we start by exporting the data and then move onto exporting object definitions. Oracle SQL Developer provides utilities to export both the definitions of the objects in a schema and the data stored in those objects.
0 kommentar(er)
