Tag Info

Hot answers tagged

2

After a pretty good amount of digging, I found this blog post on doing this for date ranges, and it turns out to work equally well on numeric ranges, with a little modification for handling the 0 and 1 endpoints. Taking the query from there and renaming the columns to be a bit more clear, we have SELECT * FROM (SELECT MAX(T_END) OVER (ORDER BY T_START) ...


2

Output is from a 11.2.0.4.6 Enterprise Edition database on Oracle Linux 7.1 x86-64 platform. Lets start with question 2 and an easy example. DISTINCT and GROUP BY are handled differently: the optimizer is able to completely eliminate a DISTINCT under certain circumstances, but it can not do the same with GROUP BY. Here is an example: create table t4 as ...


1

The solution is really dependant on your environment. There are numerous options, from hardware firewalls, to software firewalls, to sqlnet.ora parameters. The first two are beyond the scope of this site. The quickest, probably, is sqlnet.ora. Have a look at the tcp.invited_nodes parameter: ...


1

Not supported. If you want to send e-mails (JavaMail?) from the database, you do not need Java in the database for that, just use the UTL_MAIL package, available in XE as well.


1

No way how to do that. XE version does not support Java Stored Procedures. You have to upgrade at least to "Standard Edition One" or "Oracle Personal Edition". See edition comparsion.



Only top voted, non community-wiki answers of a minimum length are eligible