- 3,722,784 Users
- 2,244,413 Discussions
- 7,850,085 Comments
Forum Stats
Discussions
Categories
- 16 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 2K Databases
- 599 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 496 MySQL Community Space
- 7 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 420 SQLcl
- 58 SQL Developer Data Modeler
- 185K SQL & PL/SQL
- 21.1K SQL Developer
- 2.4K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.6K Development Tools
- 12 DevOps
- 3K QA/Testing
- 327 Java
- 10 Java Learning Subscription
- 12 Database Connectivity
- 71 Java Community Process
- 2 Java 25
- 11 Java APIs
- 141.2K Java Development Tools
- 8 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 14 Java SE
- 13.8K Java Security
- 4 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 147 LiveLabs
- 34 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 16 Español
- 1.9K Japanese
- 3 Portuguese
How to execute the query at cursor

New to SQL Developer when forced to leave TOAD. Trying to execute one query of several on the page without highlighting. All of the mentions I have found on Google are obviously from very old versions.
Best Answer
-
Thank you, Jim. It was the semi-colons that I had neglected to add. I got used to not having to add them while using TOAD.
Answers
-
F9 - Run Statement will run the statement under the cursor, or all highlighted statements. The large green arrow in the toolbar is also Run Statement. Ctrl-Enter also works.
F5 - run worksheet will run the entire worksheet. The green arrow on a page in the toolbar is the equivalent.
You need to have your statements terminated by semi-colons (or slashes for PL/SQL blocks) for it to work.
This hasn't changed since the orignal pre release days (Project Raptor), so your old versions instructions from google should work.
-
Thank you, Jim. It was the semi-colons that I had neglected to add. I got used to not having to add them while using TOAD.