Nearly 7,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!
7,552 Comments
Hi Jeff, I hope you can answer a question about editions (EBR). Which is the max number of editions in 19c ?? I’ve followed Doc ID 1507188.1 thechnique and I could create 15.000 editions without problem. In 11g max number was 2.000.
I’ve search into Oracle documents and could’t find that limit
Thank you very much
There’s not always an answer, but I will endeavor to find one for you.
That being said, how many do you actually need?
Thanks Jeff for the interest.
I really don’t know what could be the number.
The situation arise´d when we’ve exposed the edition’s main features and benefits to a client, and exposed the 11g limits, then they were cautios of using EBR.
They periodically (weekly) upgrade their applications…
15.000 editions is near editions for 95 years, asuming 3 editions a week and 53 weeks a year. I thinks there are enough editions, but to know the limit is a inquisitiveness
We only recommend 2 active editions at a time, I doubt there’s any practical limit to overall number of editions though, otherwise it’s be stated.
Remember that every Ebiz suite customer is using this feature, so it’s safe and well tested/supported.
Hey Jeff,
Is the SQLDeveloper plugin for webstorm in your roadmap?
Thanks in advance
No, not currently. If it were free and being used by tens of millions of developers, it would definitely be something to think about though.
Hi Jess,
Do you have a post about create a structured type using DataModeler? I see we have the option on the physical model but option to create is not there. We have in ther XMLTYPE & SDO_GEOMETRY. I can’t create a new one.
Any helpful link that describes how to do that?
Regards,
I don’t think I do, but just go look at the Browser, scroll down to ‘Data Types Model’ – use that to create a new Structured Type.
Hi Jeff,
Unfortunately, I don’t have the option to create a new one in there either. When I right click on Structured Types, I don’t have anything happening. On distinct type, if I right click, I have the possibility to create one. Same for Collection types. But, not on structured types. or predefined structured type.
Thank you anyway.
Either ask on the data modeler forums or create a service request with My Oracle Support.
Thanks Jeff.
Can you please explain or give an example for “you need the employ url rewrites somewhere in front of ORDS/apex.”
Regards.
Like use a loadbalancer – these aren’t really ORDS questions.
Some examples
Hi,
How can I ask a question?
I trie several time but my question is not displayed.
Thanks and regards.
Here is my question please:
Hi,
EBS 12.2.9, DB 19c on AIX
our E-business is protected by a web application firewall. Then a reverse proxy (I think).
From our E-Business we can conect ton an APEX interface.
We configured both EBS and web application firewall on HTTPS and it works fine.
We have a VIP URL to access EBS application
https://virtualserver.domain/
and from there by VIP URL to APEX
https://virtualserver.domain/ords
But
When we access APEX page we see backend (physical) server name in URL zone of brawser:
https://physicalserver.domain/ords
Is there any way to hide physical server name and display virtual server name for APEX?
Thanks and regards.
I think you need the employ url rewrites somewhere in front of ORDS/apex.
My spam filter flags anything with more than 1 link in it, so I had to manually approve the post.
Hi Jeff.
Trying to install ORDS on windows. I am going through the installation guides of Apex 23.2 and Ords 23.4, and the java -jar ords.war install command, which would work on windows, is not supported/recommended anymore.
But… I cannot find a windows installation process instead.
I am referring to chapters 2.1.2 and 2.1.3 in
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/23.4/ordig/installing-and-configuring-oracle-rest-data-services.html
(No mention of config folder preparation for windows…)
Thanks in advance
Yeah we made a real cli, now you run
ords install
Did you read the installation and configuration guide?
I have blog posts showing how to install ords here (look for the 22.1 one), and I do also everything on Windows.
Hi Jeff,
Need a help, We have migrated ORDS 19 from HTTP to HTTPS with certificate from CA few month back by following below doc which was shared by Oracle SR.
https://blogs.oracle.com/fusionmiddlewaresupport/post/simplified-ssl-configuration-for-ords-a-howto-guide
Post this configuration few application were able to connect but few are not connecting they are failing in cert chain and they are saying root and intermediate certificates need to be added along with server certificate.
I have concatenated root, intermediate and server .crt files into single file servercert-chain.crt and passed this to ssl.cert=servercert-chain.crt parameter in standalone properties and bounced the ORDS but no luck when we try to connect via browser getting connection is not private. please help
You really want to avoid having to deal with multiple/chained certs for your webserver. ORSD Standalone via Jetty can work with these certs, but it would be loads easier to setup a loadbalancer in front of ords, and then terminal HTTPS/SSL at the LB and do http between the lb and ords – then you manage your certs all on the lb.
Hey Jeff,
Hope that all is well!
In the SQL Developer application, you can download query results into .xls and .xlsx format but looks like you can’t do it in the VS Code Oracle SQL Developer extension.
Is this on the radar to be in a future release??
Thank you so much in advance for your time and consideration!
Absolutely it’s on the list!