SQL*Plus (MOSC)

MOSC Banner

Can I change the buffer file from 'afiedt.buf'?

edited Jul 1, 2009 10:43AM in SQL*Plus (MOSC) 3 commentsAnswered ✓
Is there a way to change the buffer file used by SQL*Plus prior to me typing 'edit'? I have a habit of having multiple SQL*Plus sessions open simultaneously, all launched from the same directory.
Since all sessions seem to use the same filename, this causes some minor headaches when I'm trying to edit two SQL statements simultaneously.
(define _editor='vi')

This usually occurs when I'm editing one large & complex SQL statement in one session while I need to edit a smaller one where i misspelled DUAL.

I would like to put something in my 'login.sql' file to take care of this so that each session uses its own file.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center