Export data to a table of Oracle to text

xiaoxiao2021-03-06  73

Export data for a table

Set heading off

Set linesize 1000

SET PAGESIZE 0

Set trimspool on

Set trimout on

Spool d: /your_file.txt

SELECT MENUID || ',' || Menuname || ',' || Label_code

From EP_MENUS;

Spool OFF;

转载请注明原文地址:https://www.9cbs.com/read-108597.html

New Post(0)