Home » SQL & PL/SQL » Client Tools » Set up the attributes of SQL PLUS permanently. (oracle 10.2.0.1.0 - windows XP)
Set up the attributes of SQL PLUS permanently. [message #493258] Mon, 07 February 2011 02:54 Go to next message
muktha_22
Messages: 526
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
Re: Set up the attributes of SQL PLUS permanently. [message #493261 is a reply to message #493258] Mon, 07 February 2011 03:09 Go to previous messageGo to next message
Frank Naude
Messages: 4532
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.
Re: Set up the attributes of SQL PLUS permanently. [message #493264 is a reply to message #493261] Mon, 07 February 2011 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
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 Go to previous message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi Frank,Michel,

Thanks a lot for an input...
Previous Topic: To run a query in background in toad or sqlplus
Next Topic: Disable and Enable Constraints
Goto Forum:
  


Current Time: Thu Feb 22 14:53:33 CST 2018

Total time taken to generate the page: 0.02219 seconds