Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Single column foreign key and left join - result depends from select column list

FilipFryOct 18 2013 — edited Oct 20 2013

create table test_fk(c1 date primary key deferrable);

create table test_fk1(b1 date references test_fk(c1) deferrable);

alter session set constraints=deferred;

insert into test_fk1 values(sysdate);

insert into test_fk1 values(sysdate);

insert into test_fk1 values(sysdate);

SELECT t1.C1, t.B1 FROM TEST_FK1 t LEFT JOIN TEST_FK t1 ON (t1.C1 = t.B1) WHERE t1.C1 IS NULL AND t.B1 IS NOT NULL;

C1                     B1                  

---------------------- ----------------------

                       18-OCT-2013 16.38.43  

                       18-OCT-2013 16.38.48  

                       18-OCT-2013 16.38.46 

SELECT t.B1 FROM TEST_FK1 t LEFT JOIN TEST_FK t1 ON (t1.C1 = t.B1) WHERE t1.C1 IS NULL AND t.B1 IS NOT NULL;

no rows selected

Comments

unknown-7404 
2781564 wrote:




Oracle CRM is blocked by Java 8 due to "medium" security being removed.  Possibly this is because the application requests all permissions.  Is there a reconfiguring that can be done to allow it to run/launch in Java "high" security mode.  The desktop administrators just upgraded all call center desktops to Java 8 (1.8_20) and Contact Center and other "Java forms" based application components are failing to launch.




We are working with the Admin/Security teams to see if our site can be added to the site Exceptions list but this is a lengthy process and hope we can configure CRM to work with the higher "Java" security requirement.

This is not really a Java 8 question. You need to post in a CRM forum or open an SR with Oracle support via your MOS account.

As you already noted Java 8 "medium" security was removed.

https://www.java.com/en/download/help/jcp_security.xml

Starting with Java 8 Update 20, the Medium security level has been removed from the Java Control Panel. Only High and Very High levels are available. 


The exception site list provides users with the option of allowing the same applets that would have been allowed by selecting the Medium option but on a site-by-site basis therefore minimizing the risk of using more permissive settings.

Seems like someone in your org approved the Java update without properly testing ALL of the possible affected apps.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 17 2013
Added on Oct 18 2013
#column, #list, #select
11 comments
899 views