spool had a good use, but formatted data, not very familiar with the set command, so the Internet is the next in this note are: SQL> set colsep ''; / / - domain output separator SQL> set newp none / / set check out how many pages of dat ...
System environment: rn1, the operating system: Windowsrn2000 Server rn2, Database: Oraclern8i R2 (8.1.6) for NT Enterprise Edition / Oracle 9i for NT Enterprise Edition rn3, installation path: D: ORACLE Steps: 1, hand to create the relevant directori ...
On SPOOL (SPOOL is SQLPLUS command, not the things inside the SQL syntax.) SPOOL data for SQL, the best definition to its own format, to facilitate the direct import procedures, SQL statements such as: select taskindex ||'|'|| commonindex ||& ...
On SPOOL (SPOOL is SQLPLUS command, not the things inside the SQL syntax.) SPOOL data for SQL, the best definition to its own format, to facilitate the direct import procedures, SQL statements such as: select taskindex ||'|'|| commonindex ||& ...
In the volume of data in oracle with sqlplus export the spool is achieved. Bulk import of data is achieved through sqlload. Export large amounts of data are as follows: /*************************** * Sql script part of the demo.sql begin ************ ...
