Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

²»Ñ§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 ϵͳº¯Êý¶¼²»Ò»ÑùµÄ 


Ïà¹ØÎÊ´ð£º

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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

SqlÅÅÐò - MS-SQL Server / »ù´¡Àà

ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......

sql º¯ÊýÎÊÌâ

sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔΠ µ ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ