oracleµÄ¶Áд±í²¢·¢²Ù×÷
k ˵(14:52):
ÎʸöÎÊÌâ ²éѯÊý¾Ý¿â±íµÄʱºò ¸Ã±í»¹ÄÜдÊý¾ÝÂð ÊÇ°´ÕÕÅŶӵÄ˳Ðò »¹ÊÇ°´ÕÕ²Ù×÷µÄʱ¼ä˳Ðò(²»ÖªµÀoracleÈçºÎ´¦ÀíÕâ¸öÎÊÌ⣩ ¼ÙÉèÒ»¸öÇé¿ö£ºÎÒÏÖÔÚÔÚ²éѯ¼Æ·Ñ±í£¨Õâ¸öʱ¼ä¿ÉÄÜÒª»¨10·ÖÖÓ£© 10·ÖÖÓÓкܶà¼Æ·ÑÊý¾ÝÒªÈë¼Æ·Ñ±í£¨ÄÇÕâ¸öдÊý¾ÝÊÇÒªµÈÎÒ²éѯÍêÁËÖ®ºó²ÅÄÜдÂ𣩠дÊý¾Ý¿â¿Ï¶¨ºÜ¿ì£¨0.1Ã루»¹ÊÇÀ´ÁËÊý¾Ý¾Íд£© ²éѯÒÀÈ»²éѯд֮ǰµÄÊý¾Ý
m˵(14:54):
ÄÜд
m1˵(14:54):
ÄãÓÃselect .... for update nowait ºÃÏñÊÇ ÎÒÍüÁ˾ßÌåÔõôдÁË£¬ÕâÑù¾Í¿ÉÒÔËø±íÁË£¬µÈÄã²éÍêÁËÌá½»ºó±ðÈ˲ÅÄܸüÐÂ
m˵(14:55):
¸úÊÂÎV±ðÓйØϵ
m˵(14:55):
²¢·¢¼¶±ðÉèÖÃ
m3 ˵(14:56):
²éѯʱºòǧÍò±ðËø±í
k ˵(14:59):
ÎÒÏÖÔÚÒ²¾õµÃÄÜд ÒòΪÎÒ²éѯ±¨±í¿â ¶©¹º±í Êý¾Ý³öÀ´µÄºÜ¿ì£¨597.797Ãë) ÏÖÔÚÎÒ²éÏÖÍø¿â »¨ÁË 1184.062Ãë ÕâÖÐ;¿Ï¶¨Ð´Êý¾ÝÈ¥ÁË
m ˵(14:59):
ÄÜд
m˵(14:59):
²éѯ£¬Ð´È붼ÊDz¢·¢µÄ
ÏÖÔÚÓÐеÄÎÊÌ⣬¼ÈÈ»²éѯÊý¾ÝµÄʱºòÒ²ÔÚдÊý¾Ý£¬ÄÇôÎҵIJéѯ³¡¾°Ó¦¸ÃÊÇд֮ǰµÄ³¡¾°£¬ÒòΪÈç¹ûдһ´ÎÊý¾Ý£¬ÎÒÓÖ´ÓÍ·¿ªÊ¼²éѯ£¬ÄÇÎҵIJéѯ¾ÍÍê³É²»ÁËÁË¡£ËùÒÔoracleÓ¦¸ÃÊÇÓÃÁË»º³åÊý¾ÝµÄ¹¦ÄÜ£¬²éѯµÄ¹ý³ÌÖУ¬ÏÈ°ÑдÈëµÄÊý¾Ý·Åµ½»º³åÇøÀµÈ²éѯÍê±ÏÁË£¬ÔÚдÈë±í¿Õ¼äÀï¡££¨²»ÖªµÀÊDz»ÊÇÕâÑù£¬¶ÔÊý¾Ý¿â²»ÊǺÜÁ˽⣬ÕâÊÇÎÒµÄÒ»¸öÏë·¨¶øÒÑ£¬×Ô¼º¾õµÃ»¹Óеã¶ùµÀÀí£©
Ïà¹ØÎĵµ£º
Ò»°ãÊý¾Ý¿âÖÐʱ¼äµÄ¸ñʽΪDATEÀàÐÍ£¬¶øÎÒÃÇ´ÓÒ³ÃæÖлñÈ¡µÄʱ¼äÍùÍùΪStringÀàÐÍ£¬Õâ¸ö¾ÍÐèÒªÀàÐ͵Äת»»¡£Ò»°ãÎÒÃÇ»áͨ¹ýµ÷Óà Java.text.SimpleDateFormat JAVAÀàÀ´¶ÔÆä½øÐÐת»»¡£Õâ¸öJAVAÀàÖÐÎÒÃǾ³£Óõ½µÄ·½·¨ÓÐÁ½¸ö£¬Ò»¸öÊÇformat(½«Ê±¼ä¸ñʽµÄÊý¾Ýת»»³ÉStringÀàÐÍ)£¬ÁíÒ»¸ö¾ÍÊÇ parse(½«StringÀàÐÍת»»³ÉDATEÀàÐÍ)¡£ÎÒ ......
ÔÚ$ORACLE_HOME/sqlplus/admin/login.sql (»òÕßÊÇglogin.sql)ÖÐÌí¼Ó£º
set termout off
COLUMN prompter new_value m_prompt
select host_name || ':' || instance_name ||' >' prompter
from sys.v_$insta ......
ORACLE 10 ѧϰ±Ê¼Ç-µÚ4¿Î-ÃüÁî¡£
1.commit;rollback;
2.select * from dictionary;
describe dba_users;
select * from dba_users;
select name from v$controlfile;
3.
alter database drop logfile group 3
select archiver from v$instance;
alter tablespace userdata read only;
4.
select tablespace_nam ......
·¢ÏÖһƪ¹ØÓÚÓαêµÄÎÄÕ£¬¸Ð¾õдµÄºÜ²»´í£¬ÏÈÊÕ²ØÁË£»µ«ÊÇÀïÃæÓÐһЩ´íÎó£¬=ÓÐʱ¼äÁËÔÙÕûÀíһϡ£
--------
ÎÒÃǽ«ÌÖÂÛ¸÷ÖÖÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄDDLºÍTCLÓï¾ä¡£
²éѯ
SELECTÓï¾äÓÃÓÚ´ÓÊý¾Ý¿âÖвéѯÊý¾Ý£¬µ±ÔÚPL/SQLÖÐʹÓÃSELECTÓï¾äʱ£¬ÒªÓëINTO×Ó¾äÒ»ÆðʹÓ㬲éѯµÄ·µ»ØÖµ±»¸³Ó ......