5,000,000+ Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
6,508 Comments
Hi Jeff, is there a “sql only” script to install all the required ords objects/schemas in the database? Equal to the installer at the point “Enter 1 if you want to verify/install Oracle REST Data Services schema”. Background: I want to (re)create my pdb completely by sql script from scratch for automated tests.
No…but the schemas are in the db for your to say…data pump export or extract.
How to pass date and time parameters in ords query .
current datetime format: “2021-08-30T04:26:39.472Z
See today’s post.
Hi Jeff,
I have multiple connections defined in SQL Dev and i would like to have a script to call out via connect commands to multiple of those connections running specific scripts against each connection/schema.
I have tried the usual conn/connect user/[email protected] but that doesn’t work – I’m sure i saw a piece on it a while ago but cant recall the correct way to get it to work.
Thanks in advance
Paul
Using either ezconnect or tns on your CONNECT commands should work just fine.
Those connections will be closed as soon as your script session is concluded.
Hi, Jeff.
How do I open a second (or third) tab for a table in SQL Developer 20.2+?
I can right-click and split the table, but can’t find that “clone” option that existed in old versions?.
You cannot.
Hi,
we want to use ORDS services as a paid service for the clients of our customer. To be able to know how many times a services has been called, we log in each service the request of the customer.
Now we want to block the request when the customer has no more credits to call this service.
For the put, post, delete operations, we are able to inject a plsql call to verify this and react as necessary.
But how do we do this for a get-call? Is there a way to inject plsql logic, which writes data to the db, into a get call?
Thank you in advance.
Filip Huysmans
Use the prehook feature. That will get called for EVERY request. When your user exhausts their limit, kick in your logic. They’ll never even get to the actual ORDS code path if you return a FALSE from your prehook function.
Apart from the Docs, some nice examples here from a customer.
SQL Dev 21.2.1 and also 21.2.0
When trying to get the SQL for a Partitioned Table, there is nothing specifying the partition definition. This did not happen in 19.4.0
Regards
Did you turn it off?
Yeah, so SQL Developer wasfreezing up with a message about “Comparing body to … something or the other”.
So I put it into a Search Engine and I get this:
https://community.oracle.com/tech/developers/discussion/4283208/sql-developer-hangs-on-comparing-subprograms
So I disable “Supported Sync Spec and Body” in Preferences as you suggested there. Restart required.
Guess what? It deleted ALL my passwords. I know, I know, I SHOULD have backups somehwere but .. UGH, wow, man. What the heck? I did NOT expect that.
I have passwords that I can’t exactly get back very easily. The ones I really need. Of course.
Wow. Is it supposed to work this way? Shouldn’t there be some kind of notice?
Thanks again.
– Mike Kemp
So I JUST tried this in 21.2, and after restart, all of my connections are still here.
No, that’s obviously not supposed to happen. This was in version 21.2? It’s where I just tried your scenario as described.
OK, thank you. I’ll update my version. Thanks again!!
Hi Jeff,
Now that I know what you actually read this and respond, well. Huh … I can really have some fun!! Moohaha .
Just kidding.
Maybe not.
On a serious note, though, I do have another bug to report.
I am on 20.4.1.407, Build 407.0006.
When I navigate from tab to tab using the keyboard (Ctrl + Tab), I have to fire a “Mouse Over” event on the tabs themselves to get the screen to update to show that a new tab is active.
When the active tab is not showing as active, it is a bit confusing to know what you’re looking at on the screen.
This may be an issue only when several tabs are open, and when the application has been running for some time. Not sure about those two points.
I’ll stop there. If you need further clarification just let me know.
Thanks,
Mike Kemp
reproduce it on 21.2 and let me know if it’s still a thing…you do that, I’ll file the bug for you 🙂
Hello,
I’m trying to use sqlcl instead of SQL*Plus and having relative success on this attempt.
Except for the fact that when I paste code that has CRLF line endings, sqlcl adds an extra new line.
I know that if I use a text editor to convert text to LF it works.
Is there any way to make it work without this extra step? i.e. to paste text that has CRLF as line endings directly to sqlcl and have it not adding extra lines between them?
Regards!
we had an issue with extra line breaks in a recent release, but i’m not able to reproduce this in 21.3 which is due to go our SHORTLY. What version are you using?