SQL*PLUSµÄ×÷ÓÃ
Ö»ÊÇÆðµ½²éѯ£¬¸üУ¬É¾³ýµÈ¹¦ÄÜÂð£¿
»¹ÓÐÆäËûÌØ±ðµÄ¹¦ÄÜÂð£¿
»¹ÓйÜÀí¹¦ÄÜ¡£±ÈÈç»Ö¸´Êý¾Ý¡¢Çл»ÈÕÖ¾¡¢ÉèÖÃÏà¹Ø²ÎÊýµÈµÈ¡£
Ŷ£¬¹ÜÀí¹¦ÄÜÊÇÈçºÎÀ´ÊµÏֵģ¿
±ÈÈç»Ö¸´Êý¾Ý£¬´úÂë¿ÉÒÔÔõôд£¿
sql>restore database;
sql>recover database;
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд
£º ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
String sql="insert into author values(?£¬?, ?);";
super.updateBySql(sql, new IParamBinding(){
public void bindParam(PreparedStatement pstmt) throws SQLException{
System.out.p ......