Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
New Release: 19.3.3. Lots of features! Try it out and let us know what you think
Comments
-
Thanks! We have received a lot of requests to support formatters and to include our own. It is on our list of features we hope to get in one of the coming releases.
-
Thanks for the feedback. The first two items are on our todo list for a future release.
The last one (searching) is possible today in a somewhat hacked form - we support VS Code tree control filtering. So if you expand the Oracle Explorer tree control so that all objects you want to search are fetched (for example, expand the Tables node to search tables) you can begin typing on the tree control and it will filter for you.
-
Hi, still living in here for about 75% of my tasks its great. I did notice one small tweak that would be wonderful. Right now in the database explorer I may have access to view but not edit an object. For example a package in a live DB. In the database explorer there is only edit, not view so I am unable to view the PLSQL of an object I cannot alter. A view or download without saving to the database option would be nice. If there is a way to do this and this is just user error let me know.
-
Shape-Fields still not working. :-(
-
So in that scenario when you choose "Edit", it throws an error?
If it does not give an error and displays the PL/SQL, you can then use FIle->Save As to save the PL/SQL to a local file. Then you can do what you want with it like any other script.
-
Hi I should have been clear it does indeed error: Object is invalid or doesn't exist in database
Redacted schema names and such for privacy but this is what occurs, the screenshots are out of order the bottom is what I am clicking, top is whot occurs.
I can view (but not modify) this package body as this user if I do the same in SQL developer
-
While you are in a responding mood, is there a way to have a startup/connection script when you initially hit a database/connect a file to it? Would love to set server output on and change my NLS formats automatically. Right now I am just storing a code snipped in my vs code snippets with this and then executing it each time I open a new file/connection.
-
I am always in a responding mood! 😂🤣
The startup script option has been a popular feature request. It is on our list and I hope we can get to it soon.
Thanks for pointing our the issue with Viewing PL/SQL. I will look into it.
-
LOL Sorry that did not sound like it was meant! I more meant that I could tell you were on the forum at the moment. Yea for now if others want to store a standard vs code snippet that does help me
-
I would really appreciate being able to format PL/SQL code. That's something I do constantly and is a great time saver when using other tools (e.g. DataGrip).