Title: Message Title
|
|
I'm the opposite of an Oracle expert, but I begin to suspect that Oracle's SQL dialect cannot express the "fix the affected items" operation above. It does not have UPDATE...FROM. I think we are going to need some procedural code to step through the filtered joined tables, pluck out metadata_field_id and handle, and UPDATE the matching metadatavalue(s) one metadata_field_id at a time. BTW in "SET text_value = 'http://hdl.handle.net/14' || handle" where does the "14" come from?
|
|
|
|
|
|
|
------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel