How to dump and pour text data in ORACLE

How ORACLE dumps and pours text data
ORACLE dumps data
Use the ORACLE spool command, steps:
(1) Control the display format
sql>set numwidth 8 --integer type output length
sql>set linesize 800
sql> ;set feedback off
sql>set echo off
sql>set heading off
sql>set pagesize 0
sql>set space 0
sql>set pause off
(2) Sql>Spool c:temp.txt
(3) Sql>Select * from table name
(4) Sql>Spool out
(5) Delete the SQL statements in the file
ORACLE and pour the data
Use the Sql*Load command. The control file (*.ctl) format is as follows:
Load data
Infile 'data file name'
Append - This item is available when appending data to the table
Into table table name
(
( l2),
... n field n position (*) char (ln)
)
Note: The field type must be char, and the date data cannot be poured.

The above is how ORACLE pours and pours text data. For more related articles, please pay attention to the PHP Chinese website (www.php.cn)!