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

Oracle²é¿´Óû§±í

ÔÚOracleÖв鿴ËùÓеıí: 
select * from tab/dba_tables/dba_objects/cat; 
¿´Óû§½¨Á¢µÄ±í   :  
select table_name from user_tables;  //µ±Ç°Óû§µÄ±í   
    
select table_name from all_tables;  //ËùÓÐÓû§µÄ±í   
    
select table_name from dba_tables;  //°üÀ¨ÏµÍ³±í 


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracleµÄÊý¾ÝÀàÐÍ

ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿(Scalar)¡¢¸´ºÏ(COMPOSITE)¡¢ÒýÓÃ(REFERENCE)ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ¡£
£¨Ò»£©±êÁ¿(Scalar)
    ±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£
    ËüÓÖ·ÖΪÆ߸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿ÉÐÅ¡£
¢ÙÊý×Ö
¡¡
    ÓÐÈ ......

ÓÃORACLE½¨Á¢Êý¾Ý¿â£¨Ïê½â£©


Êý¾Ý¿â½á¹¹ºÍ¿Õ¼ä¹ÜÀí£¨Êý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢±í¿Õ¼ä¡¢¶Î¡¢Ä£Ê½ºÍģʽ¶ÔÏó£©
   Ò»¸öORACLEÊý¾Ý¿âÊÇÊý¾ÝµÄ¼¯ºÏ,±»´¦Àí³ÉÒ»¸öµ¥Î»¡£Ò»¸öORACLEÊý¾Ý¿âÓÐÒ»¸öÎïÀí½á¹¹ºÍÒ»¸öÂß¼­½á¹¹¡£
   ORACLEÂß¼­Êý¾Ý¿â½á¹¹ÊÇÓû§ËùÉæ¼°µÄÊý¾Ý¿â½á¹¹¡£Ò»¸öORACLEÊý¾Ý¿âµÄÂß¼­½á¹¹ÓÉÏÂÁÐÒòËؾö¶¨:
  &nb ......

oracle³£Óþ­µäSQL²éѯ£¨×ªÔØ£©

³£ÓÃSQL²éѯ£º
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
select tablespace_name, file_id, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ