Forums Active Threads
Print Thread
SQL Export, turn off extra lines
#60737 11/22/19 12:57 PM
Joined: Feb 2017
Posts: 20
V
Valgar Offline OP
Member
OP Offline
Valgar
Member
V
Joined: Feb 2017
Posts: 20
Is it possible to turn off

prompt Importing table {table}...
set feedback off
set define off


when exporting result set?
Re: SQL Export, turn off extra lines
Valgar #60738 11/23/19 08:04 AM
Joined: Aug 1999
Posts: 22,206
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,206
This is currently no possible. I have added this to the list of enhancement requests.

Marco Kalter
Allround Automations
Re: SQL Export, turn off extra lines
Marco Kalter #60742 11/25/19 03:50 PM
Joined: Jul 2010
Posts: 16
A
Allen Marshall Offline
Member
Offline
Allen Marshall
Member
A
Joined: Jul 2010
Posts: 16
Upvote.... particularly the PROMPT statements that SQL*PLUS does not understand. Helpful when sending stuff to backward colleagues stuck with Stone Age tools....

Last edited by Allen Marshall; 11/25/19 03:51 PM.
Re: SQL Export, turn off extra lines
Allen Marshall #60745 11/25/19 04:34 PM
Joined: Sep 2008
Posts: 143
Ireland
W
WexSoft Offline
Member
Offline
WexSoft
Member
W
Joined: Sep 2008
Posts: 143
Ireland
+1
Re: SQL Export, turn off extra lines
Allen Marshall #60753 11/26/19 10:48 AM
Joined: Aug 2011
Posts: 339
T
T-Gergely Offline
Member
Offline
T-Gergely
Member
T
Joined: Aug 2011
Posts: 339
[quote=Allen Marshall]particularly the PROMPT statements that SQL*PLUS does not understand.[/quote]

Hmm, what version of SQL*Plus?
Here's the doc for 3.3 (DB 7.3.4).

Last edited by T-Gergely; 11/26/19 10:49 AM.

Moderated by  support 

Link Copied to Clipboard
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.035s Queries: 15 (0.010s) Memory: 2.5121 MB (Peak: 3.0395 MB) Data Comp: Off Server Time: 2024-04-28 04:41:12 UTC
Valid HTML 5 and Valid CSS