OraFAQ Forum: Client Tools » Set up the attributes of SQL PLUS permanently.

Home » Other » Client Tools » Set up the attributes of SQL PLUS permanently. (oracle 10.2.0.1.0 - windows XP)

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

Set up the attributes of SQL PLUS permanently. [message #493258]

Mon, 07 February 2011 02:54

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Is it possible to set the below settings permanently?
1) In UNIX - DEFINE_EDITOR=VI
2) SET SERVEROUTPUT ON
3) SET LINESIZE n

How to set the AUTOCOMMIT on/off, while using PLSQL Program.

Regards:
Muktha

Report message to a moderator

Re: Set up the attributes of SQL PLUS permanently. [message #493261 is a reply to message #493258]

Mon, 07 February 2011 03:09

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Q1: Add the command to your glogin.sql script so it executes every time you start sqlplus.

Q2: Not sure it's possible. It doesn't sound like a sensible thing to do anyway.

Report message to a moderator

Re: Set up the attributes of SQL PLUS permanently. [message #493264 is a reply to message #493261]

Mon, 07 February 2011 03:24

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Q2) You cannot do it in PL/SQL. Autocommit is a CLIENT program notion not a server one and PL/SQL is executed on the server. And as Frank said, it is not a good idea to set it.

Regards
Michel

[Updated on: Mon, 07 February 2011 05:01]

Report message to a moderator

Re: Set up the attributes of SQL PLUS permanently. [message #493278 is a reply to message #493264]

Mon, 07 February 2011 03:45

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Frank,Michel,

Thanks a lot for an input...

Report message to a moderator

Previous Topic:	To run a query in background in toad or sqlplus
Next Topic:	Disable and Enable Constraints

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 10:57:50 CDT 2024