tpwulawula的博客

使用to_date()函数例如select p.bid_end_time, p.* from t_bid_document p where p.bid_end_time > to_date('2011-06-10 16:00:00','yyyy-mm-dd hh24:mi:ss');

原sql语句：select project_ name from project_info where project_name like "%北京%"1.建立索引（最为有效）我们都知道，因为索引最左前缀匹配原则，全模糊匹配，sql是不走索引的。所以采用另一种机制，为project_name建立索引，从索引表中模糊匹配索引值去查询索引值。原sql语句中我只需要project_nam...

listAGG (BID_SECTION_ID, ',') WITHIN GROUP (ORDER BY BID_SECTION_ID) AS bid_section_id,listAGG (BID_NAME, ',') WITHIN GROUP (ORDER BY BID_NAME) AS BID_NAME

 主要就两个Tips:生成不带-的随机主键 REPLACE (UUID(), '-', '')生成指定范围的随机值数据 FLOOR(6000 + RAND() * 2000)   其中FLOOR（）是舍去小数位取整INSERT INTO bd_fz_average_land_price_trend ( ID, AVERAGE_LAND_PRICE, MONTH, YEAR)...