OraFAQ Forum: Client Tools » sqlplus command execution

Home » SQL & PL/SQL » Client Tools » sqlplus command execution (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus command execution [message #597368]

Thu, 03 October 2013 17:31

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

Littlefoot
Messages: 21759
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SQL> set serveroutput on time on;
07:24:18 SQL>

Report message to a moderator

Re: sqlplus command execution [message #597374 is a reply to message #597368]

Fri, 04 October 2013 00:27

Michel Cadot
Messages: 68415
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>

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 21 13:00:43 CDT 2023