oracle ÖÐ like ×Ó¾äÎÊÌâ
ÊäÈëÈçÏÂÃüÁ
SQL> select tablespace_name,status,contents
2 from dba_tablespaces;
TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
SYSTEM ONLINE PERMANENT
UNDOTBS1 ONLINE UNDO
TEMP ONLINE TEMPORARY
DRSYS ONLINE PERMANENT
EXAMPLE ONLINE PERMANENT
INDX ONLINE PERMANENT
ODM ONLINE PERMANENT
TOOLS ONLINE PERMANENT
USERS ONLINE PERMANENT
XDB
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
::CoInitialize(NULL);
hr=m_pConnection.Creat ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......