Whenever I have to deal with Oracle 10g projects at work, Oracle SQL Developer always comes in handy.
However yesterday, the backspace and delete button inside the SQL query editor, all of a sudden, stopped working!
I tried restarting the Oracle SQL Developer, even restarting the computer, but the problem persisted.
I didn’t want to uninstall/re-install the application, so I went on to search the Oracle official forums.
Seems like other people had the exact same problem, and the solution was quite simple!
To resolve the problem you have to go to:
Tools -> Preferences -> Accelerators -> Load Preset -> Default -> OK

decoding,
THANKS!!! You’ve just saved me a ton of extra work.
Perfec, it workst!!! I was going to reinstall the program, but tried to google the problem before. THANKS!
I am glad that this post was helpful.
Thanks for the feedback.
I just had this problem this morning. I was about to reinstall when I did a Google search. Thanks for your great post!
where I am going to find tools, preference, etc.
?!?!?
Tools is on the main menu (File, Edit… etc), on the left of Help.
You deserve a gold medal
I was beginning to think of TOAD and other nasty things.
Thanks a lot for your suggestion…yesterday I started having this problem and I thought my only solution was to re-install everything…you really deserve that medal
Thank you all
Not able to find Preferences -> Accelerators -> Load Preset -> Default -> under tools. Pls help
wow, thank you!
I had the same problem, did a search on google and found this page. Weird problem though (bug?).
Awesome!
I started experiencing this problem this morning. I googled “Oracle SQL Developer backspace not working”. Yours was at the top of the list. I read your advice. The whole problem solved in less that 30 seconds from the time I decided to google!
That never happens so smoothly for me!
Thanks!
Why didn’t I Google sooner??
Thanks man,
/E
Worked like a charm! Thanks a ton man!
Thanks a ton !!
What a lifesaver… I was ready to pull my hair out… Your the first hit on Google…
My version of Toad doesn’t have the accelerator option. This fix will work for everyone that doesn’t have the accelerator default option.
The file “plsqlkeys.bin” is getting corrupted. Do the following:
1. Close TOAD.
2. Delete “plsqlkeys.bin” from your \User Files directory.
(C:\Program Files\Quest Software\Toad for Oracle\User Files)
3. Reopen TOAD and see whether those keys now work.
Saved a lot of searching, thought my keybord was broken…
great man..saved me a lot of time!!!!!!!!!!
Thank you so much!!!! it helped me a lot !!!!
Thanks, it is working.
Hey Jordan your fix helped me a lot at a critical time. Thanks
man!
Thanks a lot!
I was searching very seriously for this issue after seeing this blog only. I get cooled. since the issue got fixed in my system.
once again thanks
I’m not sure what caused it to happen in the first place but your tip was very help helpful. Thanks!!
Same here. On Mac OS X with SQL Developer 1.5.0.53. Google lead me here. Thanks much!
Thank you! I have no idea why this started to happen, but I found your post and solved the problem within minutes!
I agree….”why didn’t I google sooner?”
But, does anybody know how this got changed in the first place? We all experience the same problem suddenly…there must be an explanation!
Echoing thanks big time for saving me from re-installation and frustration!
Awesome – I’ve seen this in JDeveloper as well, and jumped through many hoops trying to fix it, including an SR with Oracle (that didn’t bear fruit). Ugly bug, but an easy fix – many thanks!
hahahah thanks! That was really helpfull!
Hey,
Thanks a lot for the fix…
i was fighting to resolve this for a week…
finally this post helped.
Trillion thanks once again
Regards,
Sudhir
This saved me too! I’d been searching preferences for an hour already..
You’re awesome! Thanks for having this fix up!
Thanks a million decoding for the fix!!
Thanks a bunch! This has been frustrating me for weeks!
Hi All,
Thanks for publishing your posts. This helpmed me a lot. I repend why I did’t google it first.
Keep it up all your good work.
This was very helpful
Thanks
You save me
Thanks a lot 1000000 times !!
you saved me few hours
- Surya
Wow!!! THANK YOU! THANK YOU! THANK YOU!
I wanted to throw my computer out the window!
Thanks for the post, helped a lot!
Thanks mate!
Amen to all the other comments!!! Thank you!!!
wonderful man!
it helped me certainly.
Thank you!
Nice…
You saved me some micro sorry nano seconds!
just kidding!
That was lot of help
Thank You!
Perfect, phew, thanks for that!
Thanks alot ur solution solved my problem too
Thank you VERY MUCH i had the same problem and I solved it thanks to your article.
Bye
Federico
Thank you very much!!!!
Thanks a ton.. For the fix.. Have been struggling for days to resolve this Backspace issue in Sql developer.
hi..
thanks a lot man…
solution reduces my work a lot….
you’re a star saved me going nuts
Thanks Jordan for your TOAD issue fix to similar problem!
Deleting plsqlkeys.bin file.
My Toad worked like a champ after that.
Keep up the good work for us developer community.
[...] http://decoding.wordpress.com/2008/01/09/oracle-sql-developer-problem-backspace-delete-button-not-wo... [...]
Problem solved! Thank you for the solution.
Thank you very much Jordan. You saved me at least 2 hours.
Thanks!
The Intertubes are working!!!
Great help. I just encountered this problem a couple mins back, and I mentioned to a colleague. As luck would have it, he had used this same soln before and asked to google it. And yours was the first result.
Great help. Thanks a ton!!!
Thanks a lot! I was having this problem with my Oracle SQL Developer for quite some time now. I tried to create SQL queries without committing typo errors so I won’t use backspace but I can’t take it anymore. I decided to do a google search and your solution was the first hit. Thanks again!
Awesome.
Top hit on google – AND it worked, thanks man.
My ENTER keys had suddenly stopped working, and this did the trick!
P
THANK YOU. this was driving me crazy!
GREAT stuff. Thank you, very much. Quick Google search ad you have the answer. – Craig
Just had this problem and thanks to you its all sorted !!
Merci beaucoup !!!
I just had the same problem and came across this reference in Google. THANKS! Worked exactly as stated. Saved me from reinstall!!!!
Thanks for the tip. Found on Google. Big help.
Thanks a lot ! really helped …
that good one
thanks man!!!
Thank you a LOT!!!
Thanks a lot buddy, such a frustrating issue.u r a life saver man.
Thanks for the solution!
Does anyone know how this can happen though? Might come from attaching an external keyboard?
Thanks
Thanks a lot, this was a very frustrating issue !
Thank you!! How bizzare, just happened all of a sudden this morning. I’m thinking “what the hey???”, ready to uninstall the tool until I googled. Would have never figured this out on my own.
Thanks much.
Thank you for this posting. It finally resolved an issue that has been bugging me!
Thanks a ton for this posting. It was annoying me a lot.
Thanks your solution. Let me quick resolve probram…
Yup, same problem for me too! Found this blog within 10 secs from google.
Thanks for putting the solution up!
Thanks decoding, this is solved my prob too. Just FYI to all, since this post has been running, (Jan 2008), this problem seems to be a recurring issue, and any of the SQLDeveloper updates haven’t sorted it out!
I am on v1.5.1 Build 5440.. Which if i remember correctly was released quite recently.
gotta love it … After reinstalling everything including Java … etc this solved the problem ..
DO YOU THINK MAYBE SQL DEVELOPER HAS a hidden control sequence that garbages your key mappings ??!!
Thank you very much!!!!
Thanks much for the tip – enter key would not create a new line, copy/paste was not working – but now, all is well!
Thank you so much, that saved me a TON of unnecessary work!
It was really really very good and I was having this issue for quit some time.. today it fixed after reading this forum.
Thanks all helping others…
Keep the good work everyone…
Good Job!!
Thank you!
Thank you very much! I also ran into this problem today and was planning to re-install but found this solution! Very helpful!!!
Jordan your fix helped me too! thanks a bunch!! WOOO!!
Thanks alot man…………Very help full solution
Thanks a lot!
I actually reverted back to using TOAD for a couple days.
Then I asked my buds Larry and Sergey and seeing if they had knew someone who had run into this. First SERP entry.
Thanks Decode!
Thanks for the tip — this was very helpful.
This backspace problem has plagued me for 6 months! thank you so much!
Thanks Jordan Very help full solution
for this
My version of Toad doesn’t have the accelerator option. This fix will work for everyone that doesn’t have the accelerator default option.
The file “plsqlkeys.bin” is getting corrupted. Do the following:
1. Close TOAD.
2. Delete “plsqlkeys.bin” from your \User Files directory.
(C:\Program Files\Quest Software\Toad for Oracle\User Files)
3. Reopen TOAD and see whether those keys now work.
Good god, thank you for showing me this. I couldn’t copy or paste using the keyboard shortcuts, nor could I insert new lines in the code box. This fixed everything. Thank you very much.
Thanks. It was a pain in the….
aarghh… i experienced this problem months ago and tried to remove the sql developer and reinstall other version of it… still have the same problem till i decided to user dreamcoder..
today i search google for “sql developer cannot delete” and i found this post… followed the instruction and VOILA!!!
thanks, decoding..
Excellent – perfect solution to nasty bug in an imperfect tool.
Thanks!
Wow, thank you! I have had this on my list of things to fix for well over a month. Since i am working through the holidays, I have some down time to fix some issues. Thanks to your blog, I was able to take care of my #1 annoyance in record time!! THANK YOU!!!
Now onto why my display issue with Parallels and SQL Navigator. Whenever I try to view data, the video display in my parallels windows gets all messed up…
THANK YOU AGAIN!
Worked a treat !!
thanks,
wilf
Thanks a lot!
I go to Tools – Preferences – Accelerators, but “Load Presets” is not one of the actions listed. Any idea why or how I can fix the problem?
Sorry… I found it. Works like a charm! Thank you, thank you, thank you!! Saved me a lot of grief.
Oh! It’s work. Thanks.
Thanx a lot!
Pour les francophones: raccourcis/charger une valeur prédéfinie…
Thanks a lot, this was awesome.
thanks for the tips, this has been bothering me for a while. I’m glad I found your post
Thx @ lot !
It didn’t work for me. Thanks anyway. I tried the other presets (emacs, c++, classic and so on) too but the backspace still won’t work.
Thanks a million! I should have started with a web search and saved myself the last hour.
Acabo de empezar a trabajar con esta herramienta,, y tenia el mismo problema que indica al inicio decoding, pero con las flechas de desplazamiento y las teclas del bloque Insert, Supr,…
Tu consejo ha sido de gran ayuda
Tanks a lot ¡¡
Muchas gracias ¡¡¡
(mi ingles no es tan bueno como para escribir una respuesta correcta=
Thanks a lot man, did a search in google and came to this page, I was going crazy, worked like a charm
Thanks! I was having this problem for a week!
Super
cheers! you are wonderful, thank YOU!! this saved me a lot of time and many ppl from headaches!!
thank you!!!
Again, Google and helpful folks to the rescue. Thanks so much for this help.
Thank you very much. My up arrow stopped working suddenly and it was driving me mad. This fix worked for me
Y didn’t I googled y’day ???
This post is simply a brilliant one. anything more than of GOLD… if it is….this guy deserves that.
[...] als 3de hit staat dan deze pagina… Neen, zoals verwacht is er niks mis met Citrix of Windows of de ICA Client, het is [...]
Grazie mille amico!
Un suggerimento utilissimo: mi stavo incasinando.
——————————-
Thanks a lot, dear friend!
A very useful tip: I was going to lose a lot of time.
Great Post!
FYI…This also resolves other keyboard-related issues. I lost functionality of the Return, Tab and Right-arrow keys and this fixed them!
Goodbye Toad!
Thanks for the solution. Struggled with that since month.
Awesome. This has been bugging the crap outta me. Thought it was another Java App conflicting
Hi ,
I dont find plsqlkeys.bin file under any of the directories in Questsoftware folder ..
Pls help.
Thank you for posting this. This ends a week of frustration.
I thought my problem was because of remote operation, finally decided to google and this came up.
Thanks
i was on vpn when this happened.. thought i had to reinstalled googled it and it save my life.. thanks. real saver.. cannot tell you how frustrated i was… not only did backspace and delete was gone.. so was carriage return..
Great posting. Saved my day
your posting saved my day!!1
thanx a lot.
simple but fyi that you just saved me time and aggravation
thanks you very much,
You rock!
Thanks! That was driving me nuts!
Awesome! Worked!
I was using Notepad++ because the keyboard was not responding. Thank you this will help me a lot. I don’t know why I didn’t google this before.
It works now.
Thanks, worked a charm. but why does it do it in the first place??
You are the gr8
Thanks,
Vergelts Gott
thank you very much! that was driving me nuts!!
Great buddy, you cured my headache reg this issue….itz a great relief now…infact i started to hate this editor itself….
I wanna have your child. Thanks
Saved my life, BUT I HAVE TO KNOW WHAT CAUSED THIS! Will it happen again?
Thanks..It was really helpful.
God bless you.
This was winding me up. Backspace, left and down arrows stopped working suddenly a few weeks ago and for the life of me I could not figure out what I’d done wrong.
30 seconds to fix it.
thank you very much sir.
Thank you!!
You are the top one entry about this subjet on Google!
The long list of people affected sould make clear to Oracle that something is wrong on their product.
WOW — omg, you saved my life, or at the very least the walls of my cubicle. One more bash of my head and they were coming down. THANK YOU!
This was great. It is April Fool’s day, and I had been playing pranks all over the office (tape over mouse lasers, flipping mouse buttons, screenshot backgrounds…all the classics). I step away for a minute and my SQL Developer quits with not only back space, but also home, end, page up and down and arrow keys. I figured I had been pranked good. 15 minutes later I find this post and realize that it was really just God pranking me.
THANKS A TON! Saved me a lot of agony! Bless you for posting it.
Seem many suffered this problem but could solve the problem. Thanks you very very much.
Thanks a lot!!!!!
Thank you! I even did a “reinstall” with no effect.
Yet another thankful coder! Thanks.
Sequence of events :
1) No BackSpace or Delete (pulls hair)
2) Considered re-installation
3) reconsidered – Opened Google – found this site
4) 10 seconds later all is well…
Thank you!
I am using Toad 8.5.3 for Oracle 9i. Now I facing a Problem at It sql editor. When type any thing after that if I want to modify it by pressing delete key or Backspace key then it is not functioning both of this key. What can i do now.
My OS is Windows Vista Ultimate Edition.
Please anyone help me.
Thakns, Khalid
Good support Thanks a lot.
Thanks a lot… I am cursing myself not to try Google as soon as I have got the problem
This site has saved me twice now.
Thanks!
Wow Gr8 Awesome Worked like a CHarm :d thnx a ton
Saved me! Thanks!
So easy, I couldnt figure out why this was happening as there was no apparent reason for it too have turned off.
Sorted it out in a jiffy and made my day
LEGEND
Wow!! I had this problem for a long time.. was using SQL Developer instead of Oracle..just because i could not get over this problem…. just foung your post and it solved the problem. Thank you for help!!!!!
lol..my response is the same as Raj’s. Thanks for putting this tip out there; you certainly saved me some time.
Thanks! it helped me too
With all due respect, this may be your single highest achievement
… Think of all the time you saved… Of all the carbon emissions from Google servers on so many futile searches… Well done!
Awesome tip!
Thank You!
Thanks a lot for the fix. This has been driving me mad for months.
Many thanks!
I was wondering whether reinstall or not, you have saved me, thanks again.
Thanks for the tip! This is very very usefull
Thanks alot!!!
Thanks for the tip. I was just wondering, this post is since January 2008, 15 months old, and Oracle has not yet fixed this silly bug!
Wow!! You save me lot of time!! Thanks a bunch!!!!
WOW! This Post is AWESOME!!! THANKS!
Thanks a ton. I suffered like a pig in a rotten puddle for a month with this problem. Now I feel like a smoothly running unicorn easing itself ,( Believe it really) . Thanks again.
Worked!!! Thanks.. I saved alot of time..
As per all the above comments, this post was extremely useful. It was was short, simple and fixed a problem that was driving me insane.
thanks. it saved a ton of time and some of my hair as well.
worked, saved me from re-installing, thanks!
Like the other people that have posted here…I was just about ready to reinstall the product when I Googled to why my carriage return was not working and came up with this thread. you saved me lots of time
Thanks again.
Thanks a lot!. Saved my work.
Hi I am using Windows XP and have just started to have a problem with my delete and tab keys. I went into Tools, but only have the options, Map Network Drive, Disconnect Network Drive, Synchronize and Folder Options.
Please help.
Bernie
I love google, thank you for posting.
-steve
[...] remember doing anything out of ordinary, but those keys stopped working. I then Googled and found a solution. All you have to do is click on Tools menu – select Preferences, click on Accelerators on the left [...]
Thank you for posting this. I was getting noweher until I saw this post and a quick resolution of the issue.
Thanks,
sy
Hi Jordan,
Thanks alot, your fix helped me alot.I have been struggling with toad for days.Now its cool !!!!!! awesome
Swetha
Thanks. Its really working.
hey man! much appreciated! like other ppl here.. ur solution worked like a charm for me!!!
thanks!!
Thanks for the tip, saved potentially hours of frustration. I was going insane.
To Oracle: WTF, fix this bug please?
add me to the list, this just happend on my Vista machine.
thanks for the great solution.
Thank you! I was going to throw my pc through the window (or maybe try to reinstall sql developer first ^^ )
Thanks a lot it works!
Thanks a lot!!! its working
Thanks man!
As with everyone else, we owe you for the time you have saved us diagnosing the problem.
Thanks a lot for the solution!! It works great now
Great! thank you so much!
Wow! I wasted much time trying to figure this out but couldn’t. Thanks alot!
Thanks a lot..
Still amazingly useful after all this time. Has this something to do with Windows updates ?
Thank you so much. I know it doesn’t need to be said again, but thanks for this post, I would never have found the fix by just clicking around.
Thanks on this. I lost much time doing screenshoots and this tip is my saver.
Thanksssss
.
Very much!!
What a crappy Oracle tool.
I had the problem that suddenly the Enter key was not working anymore. I was almost desperate
But your solution fixed it.
Oracle, scrappy software
I just don’t have another alternative available here….
Thank you for the help.
Even the installing SQL Dev is easy task – Re-Install doesn’t solve the issue in this case.
Anyhow your suggestion is much MORE quicker and easier than a re-install.
THANKS!!!!
Thanks…
Thanx for solution.
But anyone can clear that how this problem occurs?
THANKS man!!!
thnaks dude
thanks you million times…. :p
thank u very much it worked
THANK YOU!!!!!!!!!!!!!!
Add me to the list: THANKS!!!
It worked! Thank You! You saved a lot of extra work…
thank you , i experience this problem yasterday morning and i uninstall all softwares i istalled before the problem , thank you again for you advice .
abdulhakim desuki
Libya
I was having this problem on and off with SQL Developer since last week. I’m glad I found this and got it fixed because not being able to use the backspace was extremely annoying
Thanksssssssssssssss !!
Thanks buddy…..You can see how useful your post..from day Jan 9 to till now people like me thanking you with all appreciation..
Thanks once again
Thanks a million! Works Perfectly – Stupid Program!
Thanks a ton buddy.
Times 10 dude! Times TEN!