PowerDesigerµ¼³öµÄsql¿ÉÒÔɾ³ý±í¿Õ¼ä
ûÓб¸·Ý±í¿Õ¼äÈçºÎ»Ö¸´?
ÁíÒ»ÌåÌû£ºhttp://topic.csdn.net/u/20090918/13/b3232b54-551d-40c9-9fc0-f46fb292910b.html?seed=2098035935&r=59894650#r_59894650
ûÓб¸·Ý£¬È·ÈÏÄÑ°ì°¡
¿¼ÂÇÏ ÓÃרÃŵÄÊý¾Ý¿âÐÞ¸´¹¤¾ß£¬´Ó¹éµµÈÕÖ¾ÀïÃæ»Ö¸´°É
¹éµµ ÊÇÐèÒª×Ô¼º×öµÄÂð£¿Ó ......
select to_char(rq,'yyyy-mm-dd hh24:mi:00') from table1;
´íÎó£ºÈÕÆÚ¸ñʽÎÞ·¨Ê¶±ð£¬ÎÒÏë°ÑÃ뼶µÄʱ¼äÏÔʾ³É00
Ôõô¸Ä°¡£¬°ïÎÒ¿´¿´
select to_char(trunc(rq,'mi'),'yyyy-mm-dd hh24:mi:ss') from table1;
select to_char(rq,'yyyy-mm-dd hh24:mi:ss') from table1;
SQL c ......
Oracle ÖÐÓÐÒ»Êý¾Ý¿â dBOracle Êý¾Ý¿â±í tableOracle£¨time£¬data£©
±ðµÄÊý¾Ý¿â£¨·ÇOracleÊý¾Ý¿â£© dBOther Êý¾Ý¿â±í tableOther£¨time£¬data£©
ÏÖÓÐÒÔÏÂÎÊÌ⣺
tableOracle ÖÐ ÓÐÊý¾Ý±ä»¯
tableother ÖÐ Á¢¼´¸ú×űä
ÇëÎÊÓÐʲôºÃµÄ·½·¨ÊµÏÖÉÏÃæµÄ¹¦ÄÜ¡£
лл£¡
DB ......
ÒòÕÒ¹¤×÷ÐèÒª,ÏëѧһÏÂORACLEÊý¾Ý¿â
¸öÈ˵ĵçÄÔ,×°ÁËÒ»¸ö¿Í·þ¶Ë·¢ÏÖ·þÎñÀïÉÙÒ»¸ö±ØÒªµÄ·þÎñ,Oracle²»ÄÜÓÃ,
ÊDz»ÊDZØÐëҪװOracleµÄ·þÎñ¶Ë²ÅÄÜÓÃ?
ÏÂÔØÁ˸öʲôʲôORACLEµÄÓ¦Ó÷þÎñÆ÷»¹ÊÇʲô,ÔÚ¹Ù·½ÏµÄ,Á½¸öѹËõ°ü,Ò»¹²2.08G,
ÎÒ¸öÈËÁ·Ï°Òª°²×°Õâ¸ö·þÎñÆ÷µÃÁô¶à´óµÄ¿Õ¼ä,²ÅÄÜ×°µÄÏÂ?
Ï£ÍûÓоÑéµÄ ......
OracleConnection oledbCon = new OracleConnection("Data Source = zghouseDB; User Id = scott; Password = oracle; Integrated Security = no;");
if (oledbCon.State == ConnectionState.Closed)
{
& ......
¼ÙÈ磬ÎÒÏÖÔÚÒª²éѯ±íaÖеÄ2¸ö×Ö¶Îx,y
¾ÍÊÇ select x,y from a
ÏÔÈ»Ëü»áÊä³ö2ÁеÄ
µ«ÊÇ£¬ÎÒÏÖÔÚÏëÈÃËûÖ»Êä³öÒ»ÁУ¬µ«ÊÇ£¬x,y×ֶεÄÄÚÈݱØÐ붼ÓÐ
×Ö¶ÎÄÚÈÝÒÔ x-yÐÎʽÊä³ö£¬ÇëÎÊÔõô×ö£¿
select x||'-'||y from a;
лл£¬»¹ÕæÐÐ
Ư¹ý~
select x||y from a;
select a||''||b ......