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

oracleÃæÊÔÌ⣺sqlµ÷Õû×î¹Ø×¢µÄÊÇʲô£¿

ÈçÌ⣺sqlµ÷Õû×î¹Ø×¢µÄÊÇʲô£¿
µ±ÃæÊÔ¹ÙÕâÑùÎÊÎÒʱ£¬ÎÒÔõô»Ø´ð²Å¹»×¨Òµ£¿£¿£¿£¿Ï£ÍûµÃµ½×¨Òµ¡¢ÕýÈ·µÄ»Ø´ð£¡£¡
ÐÔÄÜ£¿Ï¹²Â£¬ºÇºÇ¡£

¹Ø×¢Ö´Ðмƻ® ,±ØÐë×ßindex seekµÄʱºò¾ø²»×ßscan, ˵µ½µ×ÁË ¾ÍÊÇÓÃ×îÉÙµÄ×ÊÔ´×ö×î¶àµÄÊÂ,
²¢ÇÒ°ÑÓ¦Óõĵ±Ç°»·¾³¿¼ÂǽøÀ´,Æ©Èç~ lockÁ£¶ÈµÄÑ¡Ôñ...²¢·¢µÄÁ¿ ,tableµÄÉè¼Æ..

- -ÃæÊԵϰ,´óÌåÉϺ­¸Ç¼¸¸ö´ó·½Ãæ¼´¿É,ÈôÊÇϸ½ÚµÄ»° ...ÍÆ¼ö¿´ the art of sql,ΨÓÐʱ¼ä²ÅÄܳöÕæÖª

ף¥Ö÷˳Àûͨ¹ýÃæÊÔ~

ÊÇʵ¼ù ²»ÊÇʱ¼ä... - -!!

ÐÔÄÜ¡£

ÐÔÄܺÍÄÚ´æ×´¿ö


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸ö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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

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 ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ