CODEWITHSUNDEEP
oracle-databaseplsqldeveloper
Isaac
Isaac

Reputation: 170

How to execute the current line in PL/SQL Developer without selecting?

I want to execute a line in the "PL SQL Developer" program without having to select it.

Up to the present moment I need to select the query line and press the F8 key.

Is there any way I don't need to select the line for my query?

SELECT * FROM PRODUCT;

SELECT * FROM ALL_OBJECTS; --execute that line without selecting

I am using PL / SQL DEVELOPER version 14

Upvotes: 1

Views: 2493

Answers (2)

Геннадий Смолкин
Геннадий Смолкин

Reputation: 11

Yes, to execute current sql-statement you can use: Ctrl+F8.

It works if you add ";" to all queries in your sql-file.

Upvotes: 1

M.Youssef
M.Youssef

Reputation: 148

you can do that.

you should go to preferences then go to Windows Type -> SQL window.

check "Auto Select Statment".

but you must add to your query ";"

Upvotes: 8

Related Questions