Home » SQL & PL/SQL » Client Tools » sqlplus command execution (oracle 11g)
sqlplus command execution [message #597368] Thu, 03 October 2013 17:31 Go to next message
train.ramu
Messages: 1
Registered: October 2013
Junior Member
Hi Gurus,

I am generating text in a variable v1 like as follows:
v1= set serveroutput on; set time on;


Now these 2 commands need to be exceuted from single line in sqlplus,but its not allowing and fails.
any way for this?

Thanks for your help in advance

[Updated on: Thu, 03 October 2013 17:34]

Report message to a moderator

Re: sqlplus command execution [message #597373 is a reply to message #597368] Fri, 04 October 2013 00:24 Go to previous messageGo to next message
Littlefoot
Messages: 19623
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SQL> set serveroutput on time on;
07:24:18 SQL>
icon3.gif  Re: sqlplus command execution [message #597374 is a reply to message #597368] Fri, 04 October 2013 00:27 Go to previous message
Michel Cadot
Messages: 59143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SQL> def v1='serveroutput on time on'
SQL> set &v1
07:27:05 SQL> 

Previous Topic: Client Sql*Plus version
Next Topic: unable to connect to database
Goto Forum:
  


Current Time: Fri Sep 19 15:03:55 CDT 2014

Total time taken to generate the page: 0.19154 seconds