Home php教程 PHP开发 How to dump and pour text data in ORACLE

How to dump and pour text data in ORACLE

Dec 15, 2016 am 10:10 AM

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)!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
Two Point Museum: All Exhibits And Where To Find Them
1 months ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)