Oracle uses delimiters to combine whatever the query wants to say.
In the implementation, we may encounter customer requirements for the display title. For example, the original title was: notice of Guangxi Longtan Hospital on further strengthening the reporting of government information. Then the format they want to display is: "File name" (Guilong Medical hair (2015) No. 23). Then we just need to use the delimiter of the sql statement to combine the query. As shown below:
The effect picture is as follows:
Original address: http://bbs.delit.cn/thread-168-1-1.html
Please indicate the source of the reprint
Written by: measurement Technology http://www.delit.cn