In the program development, we usually use the program development and test in the test library. After testing the time, then move the information in the relevant test library to the official library;
Rough data flow direction: Test Library -> SQL Script -> official library
1) PL / SQL connection to the test library, select the menu -> Tools-> Export Tables ... Select the data table to be exported (size_code_ccl_tab & size_code_pp_tab)
=> Select the "SQL INSERTS" option and do not select "Delete Records" so all adds all; then "Output File" icon; Septecode.SQL); click "Archive" => Down the picture "Export" starts exporting ... 2) After the export is complete, open the file that has just been generated again with TextPad; actually it is a SQL INSERT script; 3) PL / SQL Connect to the official library, select the menu -> Tools-> Import Tables ...; simultaneously click "SQL INSERTS" option; => Replay the icon behind "Import File", select the information you want to import (Sizecode.SQL), continue to "open"; point "import "I started importing, => After the import is complete, use the SQL statement to query, see if the information has been imported correctly ...
