oracle´´½¨±í¿Õ¼ä Óû§ Êý¾Ý¿âµ¼ÈëºÍµ¼³ö
ÒѾ°²×°orcale 9i ºÍpl/sql(6.0)
OracleJobSchedulerORCL¡¢OracleOraDb10g_home1iSQL*Plus
OracleOraDb10g_home1TNSListener
OracleServiceORCL
µÚÒ»¸öÊÇoem¿ØÖÆ̨·þÎñ½ø³Ì
µÚ¶þ¸öÊǶ¨Ê±Æ÷ºÍisql*plusµÄ·þÎñ½ø³Ì
µÚÈý¸öÊǼàÌýÆ÷µÄ·þÎñ½ø³Ì
×îºóÊÇÊý¾Ý¿â·þÎñ½ø³Ì
1. pl/sql
¿Í»§»ú°²×°ºó»¹ÒªÅäÖÃtnsnames.oraÎļþ,ÔÚoracle¿Í»§¶Ë°²×°Ä¿Â¼µÄnetworkµÄadminĿ¼ÏÂ
ÄÚÈÝÀàËÆÏÂÃæ:
ORADB =
(DEs criptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradb)
)
)
¾ßÌåÀý×Ó£º
192.168.1.2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.13.35)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcaletest) ) )
//SERVICE_NAME ΪÊý¾Ý¿âʵÀýÃû
2.pl/sqlµÇ½֮ºó£¬¿ªÊ¼´´½¨±í¿Õ¼äÒÔ¼°Óû§£»
//´´½¨±í¿Õ¼ä
create tablespace test_users
logging
datafile 'D:\oracle\ora92\oradata\test_users_idx.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
create tablespace test_interface
logging
datafile 'D:\oracle\ora92\oradata\test_interface_idx.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
create tablespace test_business
logging
datafile 'D:\oracle\ora92\oradata\te
Ïà¹ØÎĵµ£º
Oracle IOÎÊÌâ½âÎö
Êý¾Ý¿âµÄ×÷ÓþÍÊÇʵÏÖ¶ÔÊý¾ÝµÄ¹ÜÀíºÍ²éѯ¡£ÈκÎÒ»¸öÊý¾Ý¿âϵͳ£¬±ØÈ»´æÔÚ¶ÔÊý¾ÝµÄ´óÁ¿¶Á»òÕßд»òÕßÁ½ÖвÙ×÷¶¼´óÁ¿´æÔÚ¡£IOÎÊÌâÒ²ÍùÍùÊǵ¼ÖÂÊý¾Ý¿âÐÔÄÜÎÊÌâµÄÖØÒªÔÒò¡£ÔÚÕâƪÎÄÕÂÖУ¬Ö÷Òª°ïÖú´ó¼ÒÔÚÀí½âOracleµÄ¶Áд²Ù×÷»úÖƵĻù´¡ÉÏ£¬Áé»î½â¾öÓöµ½µÄ¸÷ÖÖ³£¼ûµÄIOÎÊÌâ¡£
1 OracleÖÐIOµÄ²úÉú
IOµ±È»°üÀ ......
½¨SEQUENCEÐòÁÐ
CREATE SEQUENCE ÐòÁÐÃû×Ö£¨ÀýÈ磺"URLIMAGE_SEQ"£© MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 10 NOORDER NOCYCLE ;
½¨trigger ´¥·¢Æ÷
create or replace trigger ´¥·¢Æ÷Ãû×Ö£¨ÀýÈ磺URLIMAGE_TRI £©
before ins ......
ÔÚoracleÖд¦ÀíÈÕÆÚ´óÈ«
TO_DATE¸ñʽ
Day:
dd number 12
dy abbreviated fri
day spelled out friday
ddspth spelled out, ordinal twelfth
Month:
mm number 03
mon abbreviated mar ......
oracleÖ´Ðмƻ®Ïà¹Ø¸ÅÄî http://blog.csdn.net/wh62592855/archive/2009/11/06/4778343.aspx
1. ʲôÊÇÖ´Ðмƻ®£¿ÎªÊ²Ã´ÒªÁ˽âÖ´Ðмƻ®£¿
ΪÁËÖ´ÐÐÒ»ÌõsqlÓï¾ä£¬oracle¿ÉÄܱØÐëÒªÖ´ÐÐijЩ²½ÖèµÄ²Ù×÷£¬Ã¿Ò»²½Öè¿ÉÄÜÊÇ´ÓÊý¾Ý¿âÖÐÎïÀí¼ìË÷Êý¾ÝÐУ¬»òÕßÓÃijÖÖ·½·¨×¼±¸Êý¾ÝÐУ¬¹© ......
1.desc(ÃèÊö£© emp ÃèÊöempÕâÕűí
2.desc dept ²¿Ãűí
3.desc salgrade нˮµÈ¼¶
4.select *from table ²éÕÒ±íÖеÄÔªËØ
5.dual &nbs ......