oracleµÄËæ»úÅÅÐò
ÏîÄ¿ÀïÒ»¸ö¹¦ÄÜÒªÓõ½Ëæ»úÅÅÐò£¬µ«ÊǺóÀ´ÓÖÒòΪÊý¾ÝÁ¿´óµÄÔÒò£¬Òª·Öҳȥ²éѯÊý¾Ý£¬½á¹ûµ¼Ö²éѯ³öÀ´µÄÊý¾Ý³öÏÖÖØ¸´¡£
ÔsqlÈçÏÂselect * from ( select row_.*, rownum rownum_ from
(select * from tble order by dbms_random.random) row_ where rownum <= 12) where rownum_ > 10;
ºóÀ´½â¾ö°ì·¨£¬²åÈëÒ»ÕÅÁÙʱ±í¼ÇÂ¼Ëæ»ú³öÀ´µÄÊý¾Ý£¬È»ºó°´ÁÙʱ±í·Öҳȥ²é£¬Ïë²»µ½ºÃ°ì·¨£¬Ö»Äܵ±ÈÎÎñÀ´Íê³ÉÁË¡£
¹ýÂ˵ôorder by µÄÅÅÐòÕýÔò
sql = sql.replaceAll("order by [^\\)]+", "");
Ïà¹ØÎĵµ£º
MDSYS.CS_SRS ----- ¸Ã±í¶¨ÒåÁË×ø±êϵµÄÃû×Ö¼°ÆäÔÚOracle SpatialÖеÄIDÖµµÈ£¬ÕâÐ©×ø±êϵ¶¼ÊÇÓÉOpen-GIS¹«²¼µÄ¡£Ä¿Ç°¶¨ÒåµÄ×ø±êϵÒѾ´ïµ½1018¸ö¡£
MDSYS.SDO_ANGLE_UNITS ----- ¸Ã±í¶¨ÒåÁ˽Ƕȵ¥Î»£¬·Ö±ðÊÇDegree,Gon,Grad,Minute,Radian,Second
MDSYS.SDO_DIST_UNITS ----- ¸Ã±í¶¨ÒåÁ˾àÀëµÄµ¥Î»¡£±ÈÈçkm,m£¬¹²ÓÐ27ÖÖ¾à ......
ÔÚÊý¾Ý¿âÖУ¬ÓÐÁ½¸öÓû§usera£¬userb£¬Èç¹ûÔÚbÖÐÓиö´æ´¢¹ý³Ì£¬ÐèÒªÓÃaµÄÓû§È¥µ÷Ó㬣¨±ÈÈçbÊÇȨÏ޺ܸߵÄÓû§£¬¶øaÖ»ÊÇÆÕͨÓû§£¬ÎªÁËÆÁ±Î¸øa×îСµÄȨÏÞÖ»ÄÜÈç´Ë£©¡£ÓÚÊÇ£¬ÎÒ¾ÍÓÃgrant execute on ´æ´¢¹ý³ÌÃû to usera¡£ÕâÑù£¬ÔÚaµÄÓû§ÏÂÃæ¾ÍÄÜ¿´µ½´æ´¢¹ý³ÌÁË£¬µ«ÊÇÎÒÖ´ÐÐÒԺ󣬻¹ÊDZ¨ora-1031£¬ËµÊÇûÓÐȨÏÞ£¬¾¹ýÓ ......
CLOB:ÓÃÀ´´æ´¢µ¥×Ö½ÚµÄ×Ö·ûÊý¾Ý
NCLOB:ÓÃÀ´´æ´¢¶à×Ö½ÚµÄ×Ö·ûÊý¾Ý
BLOB£ºÓÃÓÚ´æ´¢¶þ½øÖÆÊý¾Ý
BFILE:´æ´¢ÔÚÎļþÖеĶþ½øÖÆÊý¾Ý£¬Õâ¸öÎļþÖеÄÊý¾ÝÖ»Äܱ»Ö»¶Á·Ã¡£µ«¸ÃÎļþ²»°üº¬ÔÚÊý¾Ý¿âÄÚ¡£
CLOB£¬NCLOB£¬BLOB¶¼ÊÇÄÚ²¿µÄLOBÀàÐÍ£¬×4G£¬Ã»ÓÐLONGÖ»ÄÜÓÐÒ»ÁеÄÏÞÖÆ¡£
select lpad(to_number(nvl(max(classid),to_number( ......
¾¹ýÊýÌ첻иµÄŬÁ¦£¬LINUXÀú¾¡Èý´Î֨װ£¬ORACLE֨װN´ÎÖÕÓÚÔÚLiNUXAS4 update6 x86_64 ϰ²×°ºÃORACLE10g R 2 (64λ) ÁË¡£
ÏÂÃæ°Ñ°²×°¹ý³ÌºÍ´ó¼Ò·ÖÏíһϣ¬ÒÔÃâ¸ü¶àÈËÏñÎÒÒ»Ñù»¨·Ñ´óÁ¿µÄʱ¼äÔÚĪÃûÆäÃîµÄÎÊÌâÉÏ¡£
Ê×ÏÈҪ˵Ã÷µÄÊÇ£¬¹Ù·½Ò²ÓÐÏàÓ¦µÄÎĵµ°²×°µ«ÊÇʵ¼Ê¹ý³ÌÖУ¬»áÓÐһЩÎÊÌâÐèÒª½â¾ö¡£
±¾Îĵµ²ÎÕÕÁËÏà¹ØËµ ......
Ò». Óû§¹ÜÀí
1.1 ½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
CREATE USER DAVE IDENTIFIED BY pwd
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 5m ON users;
1.2 ÐÞ¸ÄÓû§
......