oracle ×Ö¶Î×¢ÊÍ Êý¾Ý×ÖµäÏÔʾ
select lower( column_name) ||','||'--'||comments
from user_col_comments c
where c.table_name = upper('acc_fundcap')
SELECT * from USER_TAB_COMMENTS WHERE TABLE_NAME='T_META';
INSERT INTO ±íÃû(×Ö¶ÎÃû1, ×Ö¶ÎÃû2) SELECT ×Ö¶ÎÃû1, ×Ö¶ÎÃû2 from ÁíÍâµÄ±íÃû;
Ïà¹ØÎĵµ£º
mysql ´ó¶ÔÏó´æÈ¡:
ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
mediumblodÊÇ24´Î·½,
Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL varName=value.
linux°æ± ......
1¡¢²éÕÒ±íµÄËùÓÐË÷Òý£¨°üÀ¨Ë÷ÒýÃû£¬ÀàÐÍ£¬¹¹³ÉÁУ©£º
select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = i.table_name and t.table_name = Òª²éѯµÄ±í
2¡¢²éÕÒ±íµÄÖ÷¼ü£¨°üÀ¨Ãû³Æ£¬¹¹³ÉÁУ©£º
select cu.* from user_cons_columns cu, user_constr ......
ÎﻯÊÓͼÊÇÒ»ÖÖÌØÊâµÄÎïÀí±í£¬“Îﻯ”(Materialized)ÊÓͼÊÇÏà¶ÔÆÕͨÊÓͼ¶øÑԵġ£ÆÕͨÊÓͼÊÇÐéÄâ±í£¬Ó¦ÓõľÖÏÞÐÔ´ó£¬ÈκζÔÊÓͼµÄ²éѯ£¬Oracle¶¼Êµ¼ÊÉÏת»»ÎªÊÓͼSQLÓï
¾äµÄ²éѯ¡£ÕâÑù¶ÔÕûÌå²éѯÐÔÄܵÄÌá¸ß£¬²¢Ã»ÓÐʵÖÊÉϵĺô¦¡£
¡¡¡¡Oracle×îÔçÔÚOLAPϵͳÖÐÒýÈëÁËÎﻯÊÓͼµÄ¸ÅÄî¡£µ«ºóÀ´ºÜ¶à´óÐÍOLTPϵͳÖÐ ......
½ñÌ쿪·¢¹ý³ÌÖÐÓöµ½ÁËÒ»¸öºÜÂé·³µÄÍâÁ¬½ÓµÄÎÊÌ⣬µ½×îºó¶¼Ã»ÓÐÕÒµ½ºÜºÃµÄ½â¾ö·½·¨£¬×îºóÖ»ÄÜÓÃunion all ʵÏÖÁË£¬ËäÈ»ÐÔÄܲ»±ÈÍâÁ¬½Ó£¬µ«ÖÁÉÙÍØÕ¹ÁËÍâÁ¬½ÓµÄ¾ÖÏÞÐÔ¡£ Ê×Ïȸø³öÎÒ²âÊÔÓõÄÈý¸ö±íºÍÊý¾Ý£¨×óÓÒÍâÁ¬½ÓµÀÀíÊÇÒ»ÑùµÄ£¬ÎÒÖ»×ܽáÁË×óÁ¬½Ó£©£º KC21±í£º crea ......