Skip to Main Content
  • Questions

  • queries are not running in Sql Developer

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Ashvani.

Asked: January 14, 2019 - 6:53 pm UTC

Last updated: June 03, 2024 - 5:49 pm UTC

Version: 18.3.0.277.2354

Viewed 10K+ times! This question is

You Asked

Hi Tom/Team,

I have installed Oracle 11g Database on my Windows 10 64-bit machine.All installation has been completed successfully. I have checked connections by sqlplus and it's running fine. I am able to run queries as well there. So database is working fine for me.

I have downloaded Sql developer 18.3.0.277.2354 and some other lower versions as well.
For all these versions, i am able connection with connections(for ex HR,SYSTEM..).
Once i write a query and try to run it, it's not working. for example if i am writing,
select * from employees;

it's not giving me any response, neither output nor error. If i check run button (on top bar of sql developer) all options are disable.
After making a connection, i am not able to delete them as well..

I have checked many videos,tutorials,blogs but noting helpful for me. I have re-installed database and sql-developer properly many times but no results.

Please help me out to resolve this issue.

and Connor said...

I checked with the SQL Developer product manager and he's never heard of anything like that.

But they are keen to help - if you post your question on the SQL Developer forum, they even offered to Zoom (webinar)
with you so you can show them your screen.

https://community.oracle.com/community/groundbreakers/database/developer-tools/sql_developer

But one thing you might want to consider is that you can download completely configured database/sql developer machines with labs etc all ready to use. Much easier than installing everything from scratch

https://www.oracle.com/technetwork/community/developer-vm/index.html


Rating

  (6 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Vamana Reddy DARAPU, April 23, 2019 - 8:33 pm UTC

Me also having similar issue, any one help / guaidance much appreciated.

PL/SQL connect but not giving query results

Manoj Singh, December 05, 2019 - 11:59 am UTC

Hi, I am facing the same problem, my pl/sql client is connect but when I run queries, I don't get any result. Any suggestion/help is much appreciated.
Regards,
Manoj

Chris Saxon
December 05, 2019 - 2:04 pm UTC

And what exactly is your PL/SQL doing?

Unable to execute the queries

vishala, July 22, 2021 - 2:52 am UTC

My execute button and F9 and Ctl+enter is not working when i try to execute any query. I have uninstalled and installed the develop again but still it does'nt helped.

Could you please help me on this.

Connor McDonald
July 23, 2021 - 7:21 am UTC

Version?

Check compatibility mode

Gregory Scott, November 19, 2021 - 4:18 pm UTC

I had this issue and found that my SQL Developer had Compatibility mode enabled with Windows 7 selected. Clearing this selection resolved the problem.
Connor McDonald
November 22, 2021 - 2:08 am UTC

Thanks for getting back to us on this. It will be useful for others.

How did it get checked?

PLSQL developer stopped generating results

Nilima, May 31, 2024 - 5:10 am UTC

I am executing queries but results not showing. What is the reason for this type of issue ? Oracle is 12c installed on machine and PLSQL developer 64 bit 14.0 version installed on machine and operating system is windows 11...
Chris Saxon
June 03, 2024 - 5:49 pm UTC

What exactly are the queries? How long do they take to run in other clients (SQL Developer/SQLcl/SQL*Plus/...)? When did this start happening and what changed at that time? Do any queries return results?

*** PLSQL developer 64 bit 14.0 ***

A reader, June 04, 2024 - 5:30 am UTC 

Hello,

PLSQL developer 64 bit 14.0 is not the same as SQL Developer.
Please check if the tool being used if SQL Developer (which has been developed by Oracle)

Hope it helps.

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.