²»Ñ§sql serverÖ±½Óѧϰoracle¿ÉÒÔѧ»áÂ𣿳ÔÁ¦Âð
¸÷λÀÏ´ó¸øµã½¨Òé
ËäÈ»¶¼ÊǹØÏµÊý¾Ý¿âÖеÄٮٮÕߣ¬µ«¶þÕßÊÇÍêÈ«²»Í¬µÄ²úÆ·£¬Ã»ÓÐÏÈѧÄÄÒ»¸öµÄÇø·Ö£¬¹Ø¼üÊÇÊý¾Ý¿â»ù±¾¸ÅÄîºÍSQLÓï¾äµÄѧϰÉÏ
¡£¡£¡£Ë¸æËßÄãѧoracleÒªÏÈѧSqlServerµÄ£¿
Ëæ±ãÏÈѧÄÄÖÖ
¡£¡£¡£Ë¸æËßÄãѧoracleÒªÏÈѧSqlServerµÄ
лл´ó¼ÒÁË£¬Ò»¸öȺÀïµÄȺÓÑ˵ÎÒÖ±½Óѧoracle»áºÜÉËÐÄ£¬ËùÒÔÎÊÁË¡£Ho~Ho~лл´ó¼Ò
ÆäʵÁ½¸öÊý¾Ý¿âµÄһЩ»ù±¾µÄ֪ʶ¶¼²î±ð²»´ó¡£
ÎÞËùνÏȺóѧϰ֮·Ö£¡
µ±ÄãÊìϤÆäÖÐÒ»¸öºóÔÙѧÁíÒ»¸ö»áºÜÇáËÉ£¬£¨Ïà¶ÔÓÚ¸ÕѧÀ´Ëµ£©¡£
ÎÒ¾õµÃ 6¥˵µÄ ͦ¶ÔµÄ
ÏàÐÅÄã×Ô¼º£¬ÓÐʲô²»¿ÉÒԵģ¿
¼ÓÓͰɣ¬Ö§³ÖÄ㣡
ÓïÑÔ¶¼ÊÇÏàͨµÄ£¬Ë¼Ïë¶¼ÊÇÒ»Öµģ¬ºÇºÇ
¿ÉÒÔÏÈѧOracle¡£
µ±È»ËùÓÐÊý¾Ý¿â±ØÑ§µÄÊÇSQL¡£
ѧÉîÁËÒԺ󣬲ŻáÈ¥Éæ¼°²»Í¬Êý¾Ý¿âSQL²»Í¬¡£
µ±È»¿ÉÒÔѧ
´¿¿ª·¢£¬¶¼²»ÉËÐÄ¡£
DBA£¬¶¼ÉËÐÄ¡£
³õѧ~~Ò»Æð¼ÓÓͰÉ
ÏÈÇø·ÖһϸÅÄî°É¡£
SQL SERVERSQL Server ÊÇÒ»¸ö¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ
ORACLE Ò²ÊÇÒ»¸ö¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ
Ö»ÊÇÁ½¸ö¹«Ë¾µÄ²»Í¬²úÆ·¡£SQL²ÅÊÇÄãҪѧºÃµÄ¡£
ÓÐɶ³ÔÁ¦µÄ£¬ÎÒÎÊÄãµÄ²»Ñ§¿ª±¼³ÛÖ±½Óѧ¿ª±¦Âí£¬³ÔÁ¦Âð£¿
Õâ¸öÖпÏ~~
¿ÉÒÔÖ±½Óѧѽ.OracleÀíÂÛ¾ÍN¶àÄØ...ÂýÂýÀ´°É......Java¿ª·¢Ö÷ÒªÊÇsqlÓï¾ä
SqlServerÓÐËüµÄT-Sql ¶øOracleÓÐËûµÄPl-Sql ϵͳº¯Êý¶¼²»Ò»ÑùµÄ
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......