Ctrl+z doesn't work after I save the file.

Toad for Oracle
1

Hi,

I recently started a new job and they use toad, I would have asked my collegues but the only other one working with toad is on holidays.

My problem is after I save a file I cannot undo changes made prior to saving, ctrl+z desn’t work.

BTW I’m using version 9.7 for oracle

Message was edited by: exhortae_984

2

This is normal behaviour for most editors.....

Groetjes,
Wim

On Fri, Apr 2, 2010 at 11:03, exhortae_984 wrote:

Message from: exhortae_984

Hi,

I recently started a new job and they use toad, I would have asked my
collegues but the only other one working with toad is on holidays.

My problem is after I save a file I cannot undo changes made prior to
saving, ctrl+z desn't work.

Historical Messages

Author: exhortae_984
Date: Fri Apr 02 02:03:06 PDT 2010
Hi,

I recently started a new job and they use toad, I would have asked my
collegues but the only other one working with toad is on holidays.

My problem is after I save a file I cannot undo changes made prior to
saving, ctrl+z desn't work.
__

3

I have created a job using DBMS_SCHEDULER and it is not showing up in the Jobs
under the schema browser. I am using Toad for Oracle 10.1.1.8 against Oracle
11g. Does that Jobs item only show jobs created with DBMS_JOBS?

Thanks,
Eva

4

JOBS tab is just for DBMS_JOBS

There are several sets of tabs for the DBMS_SCHEDULER interface in 10/11g. However, it is available to the users who have the optional DB Admin module.

5

Do you have the optional DB Admin module? Look in your Help–>About. Under the
Version it will tell you.

You will need that license to view the “Schedule Jobs” tab which is different
then the “Jobs” tab which is just dbms_jobs

Ed

[TeamT]

6

did you execute?
SELECT job_name FROM dba_scheduler_jobs

(norm and roger pls correct if syntax is incorrect for 11)
Martin Gainty

Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n’êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l’expéditeur. N’importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l’information seulement et n’aura pas n’importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

7

SET SERVEROUTPUT ON

BEGIN

END;

/

DBMS_OUTPUT.PUT_LINE('Hello World');

now I open the two files in toad. select the main.sql tab and hit F5. the output is Hello World.

Now say I edit the file proc.sql and I don't save hit.

I hit F5 on the main.sql and the output is still hello world because I didn't save it as I want to be able to undo.

Imagine now I want to do the same test, but proc.sql is a file with 1000 lines and I want to cut 500 lines. to be able to launch main.sql I need to save it => I lose the 500 lines I cut and cannot undo the thing.

This doesn't seem like a normal behavior :smiley:

thanks

Hi,

I come from a java background so sorry if my question seems stupid but.

Say I create a file named main.sql with this content:

@proc.sql

and a file named proc.sql with the following content

8

This is still normal behaviour for the most editors (which one are you using
that a save command does not flush the undo buffer?). And the @ feature uses
the files on disk not on memory. If you want to make a copy of the 1000
lines then make a copy of the file. What is wrong with a file called
proc_full_with_1000_lines.sql. Or start using a version control system. but
that is risky business. Even with version control you can make mistakes that
can lead to disasters like losing 500 lines of code or all 1000 of them.

Groetjes,
Wim

On Fri, Apr 2, 2010 at 17:33, exhortae_984 wrote:

Message from: exhortae_984

Hi,

I come from a java background so sorry if my question seems stupid but.

Say I create a file named main.sql with this content:

@proc.sql

and a file named proc.sql with the following content

SET SERVEROUTPUT ON

BEGIN
DBMS_OUTPUT.PUT_LINE('Hello World');

END;

/

now I open the two files in toad. select the main.sql tab and hit F5. the
output is Hello World.

Now say I edit the file proc.sql and I don't save hit.

I hit F5 on the main.sql and the output is still hello world because I
didn't save it as I want to be able to undo.

Imagine now I want to do the same test, but proc.sql is a file with 1000
lines and I want to cut 500 lines. to be able to launch main.sql I need to
save it => I lose the 500 lines I cut and cannot undo the thing.

This doesn't seem like a normal behavior :smiley:

thanks

Historical Messages

Author: exhortae_984
Date: Fri Apr 02 08:33:33 PDT 2010
Hi,

I come from a java background so sorry if my question seems stupid but.

Say I create a file named main.sql with this content:

@proc.sql

and a file named proc.sql with the following content

SET SERVEROUTPUT ON

BEGIN
DBMS_OUTPUT.PUT_LINE('Hello World');

END;

/

now I open the two files in toad. select the main.sql tab and hit F5. the
output is Hello World.

Now say I edit the file proc.sql and I don't save hit.

I hit F5 on the main.sql and the output is still hello world because I
didn't save it as I want to be able to undo.

Imagine now I want to do the same test, but proc.sql is a file with 1000
lines and I want to cut 500 lines. to be able to launch main.sql I need to
save it => I lose the 500 lines I cut and cannot undo the thing.

This doesn't seem like a normal behavior :smiley:

thanks

__

Author: Martin Gainty
Date: Fri Apr 02 06:12:06 PDT 2010
did you execute? SELECT job_name FROM dba_scheduler_jobs (norm and roger
pls correct if syntax is incorrect for 11) Martin Gainty
______________________________________________ Verzicht und
Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht
ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so
bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder
Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine
Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut
être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons
avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle
diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à
l'information seulement et n'aura pas n'importe quel effet légalement
obligatoire. Étant donné que les email peuvent facilement être sujets à la
manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu
fourni.
__

Author: Ed Klinger
Date: Fri Apr 02 06:04:50 PDT 2010
Do you have the optional DB Admin module? Look in your Help-->About. Under
the Version it will tell you. You will need that license to view the
"Schedule Jobs" tab which is different then the "Jobs" tab which is just
dbms_jobs Ed [TeamT]
__

Author: Jeff Smith
Date: Fri Apr 02 06:03:24 PDT 2010
JOBS tab is just for DBMS_JOBS There are several sets of tabs for the
DBMS_SCHEDULER interface in 10/11g. However, it is available to the users
who have the optional DB Admin module.

__

Author: Eva
Date: Fri Apr 02 05:43:40 PDT 2010
I have created a job using DBMS_SCHEDULER and it is not showing up in the
Jobs under the schema browser. I am using Toad for Oracle 10.1.1.8 against
Oracle 11g. Does that Jobs item only show jobs created with DBMS_JOBS?
Thanks, Eva
__

Author: Wim de lange
Date: Fri Apr 02 02:38:07 PDT 2010
This is normal behaviour for most editors..... Groetjes, Wim On Fri, Apr 2,
2010 at 11:03, exhortae_984

9

In MS Word, a save command does not flush the undo buffer. I have used this
feature on multiple occasions.

Nate Schroeder

IT Commercial Technical Services - Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167

314-694-2592

10

On 02/04/10 18:06, Wim de Lange wrote:

This is still normal behaviour for the most editors (which one are you
using that a save command does not flush the undo buffer?).

To be fair, I have used an editor (on Windows as well!) that offers me
the option to "allow undo after save" and to be equally fair, I've only
ever seen one editor that allowed this.

It was called Programmers File Editor (PFE0 and I still use it daily -
even though it has not been available for many many years.

Cheers,
Norm. [TeamT]

11

I did and it turns out I need access to those tables and the DBAs are working on
that now. Thanks!

12

Well that is just not right :slight_smile: Oh well…

----- Original Message ----

13

[quote]This is still normal behaviour for the most editors (which one are you using
that a save command does not flush the undo buffer?). [/quote]

Word, notepad++, ultraedit, eclipse, intellij idea, pl/sql developper, oxygen xml editor, code blocks…

To be honest I have never been confronted to this kind of behavior in any editor I used, and I don’t understand why the undo before is flushed after a save in toad. Isn’t there a way to get that behavior (an option, a file to edit, anything ???)

Thank you.

14

(which one are you using that a save command does not flush the undo buffer?).

EditPad Pro doesn't flush the buffer after save as well.
A very pleasant feature I must say, used it on many occasions.
Must say, I cannot think of any 'rationale' why you should flush the
buffer.

Peter

15

Here I am uploading my Collections of Interview Questions.
List of Post for Oracle Application Technical and Other Interview Questions and Answers.

http://erporacleapps.blogspot.com/2010/03/oracle-apps-question- answer-2.html


Please feel free to take a look on these sites for Most IMP Topics in Oracle Apps…

Please let me know if any body wants more Information about any topic…
Thanks
Nilesh

Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/