Page 1 of 1

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Mon Feb 17, 2020 9:17 am
by Sergiy Romankov
stmt.enquoteIdentifier(mode, false) doesn`t make code safe, second parameter should be true

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Mon Feb 17, 2020 9:28 am
by admin
Why do you think so?
true and false values produce the same result for non-simple sql identifiers.
You might want to checkout the JavaDoc description.

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Wed Jan 06, 2021 6:23 pm
by philippe
Why is enquoteIdentifier used instead of enquoteLiteral? What you want to do here is pass a literal.

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Thu Jan 07, 2021 12:35 am
by admin
Yes, it should be enquoteLiteral. Fixed.
thank you for your feedback!

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Thu Jan 07, 2021 3:37 pm
by philippe
You're welcome. Is it possible to also push the change in the 1z0-816 question bank?

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Thu Jan 07, 2021 10:30 pm
by admin
Yes, done.

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Fri Jan 08, 2021 1:13 pm
by philippe
When I check the version for the 1z0-816 question bank, I still see version 1.30. Does the new version still have to be pushed?

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Fri Jan 08, 2021 10:34 pm
by admin
If multiple minor corrections reported during a small time frame, they are all applied together and then the version number is updated. This is done to ensure that users are not annoyed by too many update notifications in a short span.

If a critical error is fixed (such as a wrong answer to a question), we apply the fix, update the version number and release the new question bank file immediately.

In this case, the version number has also been updated to 31 and the notification will also be updated soon.

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Thu Feb 11, 2021 2:08 pm
by OliviaJohnson
How does the plus sign(+) syntax work? Oracle docs on Statement/PreparedStatement/java.sql/Wrapper does not have any plus sign(+).

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Thu Feb 11, 2021 2:13 pm
by admin
Not sure I understand your question. Which + sign and in what place are you talking about?

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Mon Feb 15, 2021 4:36 pm
by OliviaJohnson
Hi, I was talking about this

Code: Select all

+mode+

Re: About Question enthuware.ocpjp.ii.v11.2.3372 :

Posted: Tue Feb 16, 2021 1:51 am
by admin
Oh, that is just string concatenation. mode is a parameter. So,
String qr = "SET SESSION sql_mode = '"+mode+"';";
will actually produce this string:
SET SESSION sql_mode = MODEVALUE;

Where, MODEVALUE is the whatever was passed as the mode parameter.