COMPARE: Compares two entire LOBs or parts of two LOBs. You can only compare LOBs of the same datatype.
CONVERTTOBLOB: Reads character data from a source CLOB or NCLOB instance, converts the character data to the specified character, writes the converted data to a destination BLOB instance in binary format, and returns the new offsets. You can use this interface with any combination of persistent or temporary LOB instances as the source or destination. Both the source and destination LOB instances must exist. If the destination LOB is a persistent LOB, the row must be locked. To lock the row, select the LOB using the FOR UPDATE clause of the SELECT statement.
A -> ref " This function compares two entire LOBs or parts of two LOBs."
E -> ref " Both the source and destination LOB instances must exist. "
ref link -> https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_lob.htm#BABDDFDH
A,E. D would have been true only if the lob was persistent.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
orakell
Highly Voted 5 years, 2 months agoRakeshpro
Most Recent 2 years, 4 months agoRakeshpro
2 years, 4 months agoRakeshpro
2 years, 4 months agochrishillinger
2 years, 5 months agoCosminCof
4 years, 2 months agojcamt
4 years, 3 months agocertyk
4 years, 4 months agopeguynya
4 years, 6 months ago