文章分类 -  oracle

摘要：insert into geo_city(ID, GEONAMES_ID, NAME, COUNTRY_CODE, MODIFICATION_DATE) select GEO_CITY_SEQUENCE.nextval,'TSITT104IT',' Santomato-Pistoia PT ','IT',to_date('2011-11-23','yyyy-mm-dd') FROM DUAL WHERE NOT EXISTS( SELECT * FROM geo_city WHERE GEONAMES_ID = & 阅读全文

摘要：http://docs.oracle.com/cd/B10500_01/text.920/a96518/cqspcl.htmhttps://forums.oracle.com/forums/thread.jspa?threadID=466604SET ESCAPE ON;Escape CharactersTo query on words or symbols that have special meaning to query expressions such as and & or| accum, you must escape them. There are two ways t 阅读全文